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

Grafana Configuration
#1
  • 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/

#2

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

#3

I presume you mean this? See image.

query1
query11550×749 45.2 KB

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.

#4

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

#5

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

#6

take a look at this, it should help out

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

#7

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.