Grafana Dashboard with JSON APIs. visualize JSON, CSV, Graphql, XML in grafana
HTML-код
- Опубликовано: 5 окт 2020
- Infinity datasource: github.com/yesoreyeram/grafan...
Infinity datasource document : yesoreyeram.github.io/grafana...
Dashboard JSON : grafana.com/grafana/dashboard...
For support, queries and bugs visit github.com/yesoreyeram/grafan... 
Наука
I downloaded your plugin, it’s awesome! Simple and to the point...thank you for all the hard work!
Thanks, bro! You just saved me. I'm using JSON API until I found this video using Infinity.
Glad I could help!
Bro, you are our hero! Thanks for created this datasource
Hope this is useful. If you have questions or looking for more examples , refer the plugin documentation and GitHub discussions.
GH discussions : github.com/yesoreyeram/grafana-infinity-datasource/discussions
Plugin documentation : yesoreyeram.github.io/grafana-infinity-datasource
Thanks.
Beautiful
Great Job buddy. Keep doing more
Thank you, I will
excellent work
Nice video! Thanks a lot!
Thank you too!
Amazing!
Thank you! Cheers!
Hola, me ha funcionado bien en el computador que se ha instalado, pero al llevarlo a un html con un frame no lo visualiza ya sea en la misma red local ni en el vps privado, hay alguna forma de hacerlo funcionar, te agradezco si me ayudas
awesome! thanks!
My pleasure!
Thanks!
Thank you for sharing 👌👍. I am looking for how to get value/data from array.
Example JSON type array inside another JSON array. It is known as an array of arrays or a multi-dimensional JSON array.
🙏🙏
E se no lugar de country tivesse um valor numerico que, relacionada a 4 outras colunas. Algo como: " collum primary :{ 1 : { collum:"value" , 2.collum:"2.value" , 3.collum: "3.value"} , 2: { collum :"value" , 2.collum:"2.value" , 3.collum:"value" }, 3.{...} , ... , n:{ collum:"value" , 2.collum: "2.value" , 3.collum: "3.value"}}, como usar o plug-in quando a API retorna valores neste formato?(exemplo: API Alpha Vantage)
This is great. However I need to first user basic authentication to get the bearer (token) and then run the API URL to get my JSON info, can this plugin do that?
Hello Sir
did you work on Apache Ambari metrics data source migration from AngularJS to React
Thank you for the plugin. I am looking for the time interval support which comes along with Grafana in other plugins. How is it possible with Infinity plugin? For example, to display the data only during the last 2 days.
Got the answer from the discussion forum. github.com/yesoreyeram/grafana-infinity-datasource/discussions/84
How did you get Demo Data source in the drop down? Can I do it now? Can you guide, please?
how can I display data in multiple rows instead of colums?
Hi Sriram, Can we link two panels, I mean I want to change the Pie Chart when filtering the table values ? Is that possible with this plugin ?
Yes possible via variables and data links.
Thanks for this, If one wants to show ongoing live data , how will one be able to do it. Is there a way that the REST API gets called every 5 mins and the modified json is shown in graph ? Kindly advise
plugin doesn't track the data. It just returns the data whatever returned by the API. You can use grafana's time variables in addition to your API to filter your data. Also Grafana's timepicker can be set to auto refresh every 5 mins so you get data refreshed every 5 mins.
Hello!
Do you also have videos on how to create dashboard based on Netbox data? Basically we have custom fields in netbox using which would like to create dashboards.
Hey can you tell me
I'm unable to add the infinity datasource in my corporate Grafana instance. Can I do the same with simple-json?
What problem you are getting. Since last week you can add this now from.grafana plugin catalog.
Hi, Collectionlookup gives only the first list item in the variables. Other list items are not getting displayed with this plugin. Example - CollectionLookup(proxxx,6878,abcd,11328,$Application) gives 6878,none. This does not display other items. Can you please help?
Do you mind creating a GitHub ticket? RUclips is not a place for support requests.. 😂
Hi Sriram. Thank you for this quick introduction to infinity plugin. Looks great for many use cases. I have one question. Is it possible to show real-time data from an API? I have a use case where I need to show realtime data from a Kafka topic in a dashboard.
There is an other official Grafana plugin called SimpleJson. What is the difference between your plugin and this one? Thanks in advance.
Simple json datasource is a legacy plugin and that will expect your data to be in certain timeseries format grafana and expect endpoints such as search/query etc.
This infinity plugin doesn't have any requirement for such endpoints or formats. Works with most of the data formats and endpoints.
Showing data as a real-time/streaming is not possible with the plugin atm. Just point in time data it can show.
@@yesoreyeram g
How to count the different values in same column? Ex: i have 3 apples, 5 bananas and 6 strawberries in one fruit column. Using infinity datasource i want to represent in a pie chart which represents 3 apples,5 bananas and 6 strawberries of one column . Can you please help me with this?
Hi! Thanks for share this video. Is it possible to use Infinity datasource reading an API with JTW authentication?
With the current version it is not possible. I am willing to add those. Are you interested in any specific API? Proving more details at the github repp is appreciated as I reguralrly follow there
Hi Sriram, Good Day! Can we read JSON via HTTP link from a file which is stored in AWS S3 bucket ? where do we need to provide key id and secret key ? I tried different ways, seems not working for me.
I haven't tried. Probably you can't do that with the current version.
Hi Sriram
Instead of adding url, can I add a json file from my local machine?
I chose inline option instead of url and pasted the data from the json file but it isn't taking the data.
Appreciate if you could help!
Thank you
For security reasons, that is not allowed yet. But you can simply do it by serving your local file with web sever like nginx then access it by url.
What error you are getting when doing it inline? You can post it the plugin github page for support.
Can we do basic auth with JSON data source? I have added basic auth in settings of data source but seems like its not taking the credentials from there.
Create a GitHub issue with details on how to reproduce it.
Hi sriram, do we have option to use grafana variable in infinity data source?
Yes. Grafana variables should work. In case if something doesn't, create a GH issue with details.
How we can do it with 2OAuth RestAPI?
Hi Siriam.
This is a great video and ... that's more or less what I was looking for :)
I need to make API calls and based on the response, make a nice dashboard.
I saw that as data source you defined an "Infinity" but when I try today, the infinity is not available. There is a way to achieve something like that with Prometheus? Thanks for the great work :)
Hi Omar. Have you installed the plugin ? You can find instructions here in grafana.com/grafana/plugins/yesoreyeram-infinity-datasource/
@@yesoreyeram I didn't find this before !!!
Thanks Mate !!!
I Like and Subscribe to your channel 👌
Excellent video Sriram. The only issue is that the heroku api link is no longer functional. Do you have an alternative link? Thank you!
Which heroku link ? Demo instance is available in grafana-infinity-datasource.herokuapp.com/d/try/try?orgId=1&editPanel=2 (btw, it is a hobby instance . So expect it available only for demo purposes )
What if my csv files have names that starts with date (2022-12-20.csv for example) and they are stored locally?
Local files not supported. You have to expose the files via local web server such as nginx
You mean not supported by what? I finally managed this. There is a CSV plugin that works with local files. It is not very efficient (eats tons of RAM) but works.
hey your video is very helpful good job.
furthermore I am looking for JSON timeseries data plotting on grafana. do you have any idea for that ?
Have you checked the docs and GitHub discussions? They have more examples.
how to build time series from CSV ?
getting Data does not have a time field
By design, grafana won't save/track any data. It will just fetch and display data. If your data doesn't have historical data/timestamp you can't plot it time series
Hi, I'm from Brazil and I really liked the video. with this version it is not possible to consume data from an api with authentication via token? which version of the plugin or grafana? can you do otherwise? Thank you very much. Great video.
Api token via headers you can do. But things like OAUTH are not yet supported. Glad you liked the video.
With the recent version, now oauth is also supported.
@@yesoreyeram hey man. Thanks! I will see the new version!!
When I do everything according to the instructions, but for any request, Grafana Cloud gives me a 404
You may need to remove the URL from the data source config. I thing I am going to deprecate the URL from the data source config section.
great job can you do triggers and alerts also
Alerts are not currently supported. The plugin is slowly getting there. For the alerts to be supported, the plugin require backend component. I am still in the process of migrating it to backend component.
nice vedio, how to authenticate our own api here, as it asks authentication
Hi Sriram,How to link this panels to the dashboard time range so that panels will be interactive.
Data filtering based on grafana needs to happen at api itself. Infinity doesnt filter data or react based on time range.
In order to filter the data based on dashboard time range, you need to pass the grafana time range in your API url using grafana global variable syntax. Assuming your API supports filtering of data based on time range.
More details, create a discussion in GitHub repo
@@yesoreyeram thank you so much for your reply.
I want to try following your video, but unfortunately, the Covid 19 API has already been discontinued
data [
{
id : "222",
class : "Platinum",
area : "Aceh",
avail : [
- {
av_id : "112",
Stat : "red",
sla : 11
} ,
- {
av_id : "11",
Stat : "blue"
sla : 1
}
]
}
]
Hello, how can i call value from avail in rows/root (URL) ?
I need a way without going through the "Inline" source, I want it auto via URL
Hello buddy, I also had the same issue now, but I got the solution and thought I should share with you as well. Try this.
$._items.[avail] in the Roots/Rows field.
$._items is the main root node and returns all the data and by using .[avail] you will be able to go to a sub node.
Hi Sriram, its gives me an error "Object(...) is not a function" . Could you please help out?
I think you are trying with grafana 8. I am.working on a updates for grafana 8 which I will release by tomorrow.. in case if you got it for grafana 7, report a bug in github
@@yesoreyeram Thanks, Now with the help of support version i am able to use it. However, is there a way to use a basic auth based json api? i have tried using it with advanced feature in which i added the username and password of the application. But it still doesn't connect. Any way out? I have tried simpleJson and other json plugin too but no luck.
Yes you can. In advanced mode, you need to give only the domain name in the url on the config section. And in the query give the remaining url. Basically the plugin will join both the url to form the full url.
Hi.. Is there any way to. Load mutiple csv files with name headers in it?
No. But you can add multiple queries in Grafana
BTW, see if this alternative helps. github.com/yesoreyeram/grafana-infinity-datasource/discussions/404
Hello!
I Miss the Azure-Datasource plugin developed by you
I too..
Btw, you can use infinity to connect any azure API urls.
Works with azure monitor queries?
Yes with the recent support oauth client credentials support they work.
is this taking the json info in real time?
Yes. Infinity doesn't store any data.
is it possible to monitor multiple remote pcs ? using grafana? how?
Thank you, can this support alerts?
Alerts are not supported at the moment.
@@yesoreyeram thank you, is it planned to implement this feature in the short term? With alerts this plugin is just perfect
From 1.0.0 of the plugin, it supports alerts. ( You need to select backend parser in the query editor for the alerts to work )
HELLO SIR PLEASE SHOW HOW TO IMPORT A EXCEL OR CSV FILE PLEASE
I have installed grafana,, there is no demo option in it
Great but you have only showed GET request.
POST is also possible. Check documentation or give a try. Have you tried?
@@yesoreyeram I have tried the POST request and it worked but like Postman it doesnt show the new repo on Github nor it shows the updated table with the previous repos. I am using the Github API
So its just creating a dummy json content. But I want to make a POST request in github url.
I need to visualise JSON data from logstash to opensearch to grafana
can you maybe please help me with this?
Like can we hop on a call?
// JSON data from logstash to opensearch to grafana
You should use opensearch plugin. Not infinity plugin for your usecase
Hi is anyone facing a similar issue:
Fetch error: 404 Not Found Instantiating localhost:8080/public/@emotion/css Loading localhost:8080/public/plugins/yesoreyeram-infinity-datasource/module.js Loading plugins/yesoreyeram-infinity-datasource/module when trying to create a datasource?
Can you create a github ticket with reproduction steps? Appears that the plugin wasn't installed properly