How to get a value from a JSON stored in a variable

Grafana Dashboards
,
1
  • What Grafana version and what operating system are you using?
    Grafana v11.0.1 on macOS Sequoia
  • What are you trying to achieve?
    To get a JSON response from a REST API, store it in a variable and then, while in a panel query, filter out that JSON and get a value for a specific key, depending on another key.
  • How are you trying to achieve it?
    Using a dashboard variable, and then using Infinity data source to filter that JSON structure based on a given key.
  • What happened?
    I’m not sure what is happening.
  • What did you expect to happen?
    To get that value as a result and use it in a visualization panel.
  • Can you copy/paste the configuration(s) that you are having problems with?
    I need to store the response to this request, once: [GET] <an_appdynamics_controller>/controller/rest/applications?output=JSON
    Be the response something like this:
[
    {
        "name": "appName1",
        "description": "",
        "id": 626,
        "accountGuid": ""
    },
    {
        "name": "appName2",
        "description": "",
        "id": 122,
        "accountGuid": ""
    }
]

Then, while in a panel query, I want to get the ID for the corresponding name, which is stored in another variable.
I need that ID to be available for using it in another panel query, in the same panel, afterwards.

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

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

2

Did you checkout the uql documentation