Getting multiple dashboard variables from one JSON query

Grafana
, ,
1

The Problem:
I have an API query which returns following JSON:

{
  "ver": 1745357818,
  "list": [
    {
      "id": "111",
      "inner_list": [
        {
          "inner_id": "222"
        }
      ]
    }
  ]
}

and i want to use “id”, “inner_id” and “ver” from that JSON in different text panels across dashboard. I want to have only one query for all dashboard panels.

What I’ve tried:

  1. I’ve tried to create a master variable “MasterVar” like this (i use inline source instead of an actual API query just to simplify):

    image
    image895×740 26.2 KB

    image
    and use it directly in the text panels for display at least “ver” like this: ${MasterVar.ver} or ${MasterVar:ver} or ${MasterVar}.“ver” or in other hundred variants, but as a result i only had same original json:
    image
    image
    sometimes with some minor modifications. I didin’t even try to display nested values like “id” and “inner_id” since i didn’t succeed with “ver”.

  2. I’ve tried to make other variables and parse “MasterVar” in these variables but didn’t succeed as well and get empty result

I think i didn’t get something significant because this process of getting multiple variables from one query should be basic and simple. I would appreciate any help.

2

2 values from one variable is doable by using key/value

but 3 is also possible but it depends. Will you will be displaying the list of these values like so?

image
image1627×745 69.3 KB

3

Thanks for your answer! But seems like i didn’t get it. I need way more that 3 values in original JSON, something around 20. And Is it necessary to use Business Text plugin, because i’d like to use only standart elements? Now i only have ordinary text panel and i can use only dashboard variables here.

It’s seems strange for me to presume that grafana doesen’t have standart mechanism to minimize amount of queries, maybe i still miss something here.

4

I am not sure you can reference values via ${Master:ver}

5

Me too, because i already tried it as i said in my initial post.

Anyway, thanks for your help @yosiasz i am really appreciate it! I still have two more questions below, please, consider to answer them.

  1. I installed Business Text plugin, but still cant’t get result from your screenshot.
    Here is what i got in normal view mode(empty cells):

    image
    image1756×783 63.2 KB

    And in table view mode (all data is parsed correctly):
    image
    image1830×781 69.9 KB

    Can you please show me full settings from your screenshot?

  2. I still can’t figure out how using Business Text plugin can help me to solve problem from initial post. Can you please eleborate it to me?

6

This should help

Since it is html you can add click events to capture values from your data to use as you wish