How to create a dashboard with JSON datasource?

Grafana Dashboards
,
1

Hi everyone.

I’m asking your help :slight_smile:

This is my first try of grafana and it does look incredible !

I’m trying to create a dashboard with a JSON data-source. So far, I’ve been able to :

  • Install the plugin
  • Add the datasource (at least when I clic « Save & Test » it says « Data source is working » so I guess it’s ok !)

image
image2732×1779 205 KB

Now I want to display the data on a dashboard.

The URL for my data is the following :

https://www.vigicrues.gouv.fr/services/observations.json/index.php?CdStationHydro=F700000103&GrdSerie=H&FormatSortie=simple

It’s a French government website that provides all rivers water level (I’m living on an island on the Seine river in Paris, so I’m particularly interested when it could rise).

I’d like to get the same kind of result like this :

When I try to add the data source in a Panel, it says « No data ».

image
image2732×1784 242 KB

I have absolutely no idea what to do from there…

Any help from you would be much MUCH appreciated :slight_smile:

2

Hello.
Have you found a solution to integrate ‘Vigicrue’ into Grafana?
I also try to visualize the data of a river but without result.
I believe this may be from the data format.
It seems to me that the API of ‘Vigicrue’ provides GEOJSON and not JSON.
Thank you for your help.

3

Hi, yes I did, but not directly from Grafana. I’m using my Fibaro HC3 to get the Vigicrue data into an influxdb database, and then from influxdb to Grafana…

image
image2732×1786 1.26 MB

1 Like
4

Great.
I also use Influxdb but in Home Assistant.
Could you detail the method to feed an Influxdb database with json data from Vigicrue please ? Thank you very much for your help.
Bruno

5

Hello.
Could you indicate your method to integrate Vigicrue into Influxdb.
Thanks a lot.
Bruno

6

Toute aide de votre part serait beaucoup BEAUCOUP apprécié: :wink:

7

Hi guys,

As I said, I’ve used my domotic gateway (Fibaro Home Center 3) to query the data from Vigicrue. This is how I did it :

Then, I’m storing the data to an influxdb database, still with my HC3, and here’s how :
https://forum.fibaro.com/topic/47604-howto-hc2-grafana-influxdb/page/2/

Have fun )

1 Like
8

Here is a simple way to get vigicrues data into grafana using Infinity datasource. ( Directly calling the api from grafana. )

image
image1036×791 43.2 KB

9

yesoreyeram do you know how to install infinity data source on Grafana Labs?

1 Like
10

Hi @eyalsofer1 - Now the infinity datasource is available in grafana.com plugins catalog. you can install from Infinity plugin for Grafana | Grafana Labs

2 Likes