Simple JSON API & Dashboard Variables don't appear to work

  • What Grafana version and what operating system are you using?

Grafana Cloud Version 9

  • What are you trying to achieve?

I’m trying to add variables to a dashboard using an JSON feed → https://services.nvd.nist.gov/rest/json/cves/1.0?

  • How are you trying to achieve it?

I go to the dashboard that I want to add a variable too. I create the variable using the following param using SimpleJSON as my API.

Datasource = https://services.nvd.nist.gov/rest/json/cves/1.0?
Field = $.result.CVE_Items[*].cve.CVE_data_meta.ID

This returns a list of the data I want my dashboard to filter on.

I add this to the dashboard but when I select a particular CVE at random, it doesn’t get applied to any of the underlying tables. It’s almost like the variable is not dynamic.

  • What happened?

As above.

  • What did you expect to happen?

I should be to filter on the data that I want only to show.

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

N/A

  • Did you follow any online instructions? If so, what is the URL?

NA/

how are the underlying queries using this variable? can you please share?

I presume you mean this? See image.

As you can see, I’m just doing something very basic at the moment. I’m polling the data and looking to just view CVE-2022-32561. I’m yet to append any additional fields.

does not look like you are using the variable (from the drop down) anywhere in your A query. having a variable in of itself does not mean it will do something as far as I understand it. you have to use it in your queries

Hmmm there doesn’t appear to be any viable option to add this. Not at least using this Simple JSON api.

take a look at this, it should help out

https://grafana.com/docs/grafana/latest/variables/variable-examples/

Thanks for the advice. I feel like what I’m trying to do isn’t possible with using the Simple JSON api. I’ll keep playing around and see if I can work it out.