Is there a way to call API and save data to database within grafana cloud?

Grafana Dashboards
1
  • What Grafana version and what operating system are you using?
    Grafana cloud
  • What are you trying to achieve?
    Do simple api call to retrieve data and store data daily. see the analysis / graph of the data by day
  • How are you trying to achieve it?
    I was wondering if there is anything that could do that.
    seems like json api can retrieve data but cannot store it.
1 Like
2

Welcome

Pretty sure you could do it but save it elsewhere and not to grafana cloud database

1 Like
3

Thanks

yeah I was thinking maybe using MySQL or postgreSQL
seems like there used to be plug in called simplejson to mysql which will let users call api and save that data to mySQL but it is gone.
I’l looking at something similar

4

I agree with @yosiasz - it is possible to do for external databases, but I wouldn’t recommend it to be honest.

The JSON API data source can be used to craft arbitrary requests to remote APIs. That will easily let you fetch data from just about any REST-style API. As far as I know it isn’t possible to craft encoded POST bodies with it (Grafana is usually a consumer of information rather than a producer), but it would be possible to pass data in other ways, such as through headers and query params.

But beside it being possible, I would suggest you don’t do this. In practical terms, when you would be “saving data to a remote database” would be when Grafana ran certain queries which probably isn’t what you want.

There are a number of tools in the data movement space, like fivetran that might be better if you want to pull data from one source, transform it, and save it into a different database.

2 Likes
5

@davidallen5 ia spot on. Also what is your use case or requirements, what are you trying to accomplish by capturing the data

1 Like
6

thank you for your input, I will look into those

1 Like
7

just a very simple task of
getting certain values from api (date, number, number)
and just save it to database and see the difference over time

2 Likes
8

But with purpose what is the end goal of capturing these data points? What data values are these?
Because if it is values from yoir data source themselves then hitting api is definitely not the way to go

1 Like
9

they are customer ratings. just want capture daily average and display. more of analytics

10

Are these data points coming from customers using grafana or data coming from queries against your data source?

1 Like
11

queries against data source. but the query is just date. and it gives a json of that date’s ratings. simple API call with specific date, and return

12

what is the data source?

13

3rd party service where they collect ratings from app store / playstore
not sure if naming exact company is okay

1 Like
14

Is there a rate limit for this service and you are trying to piggy back on grafana? Does licensing from a legal pov allow this? If not can you call them outside of grafana. That would be my recommendation unless there us something we are not aware of