JSON data without element

Configuration
1

Hi, is there a way to get JSON data when there is no element? I need to get data from “values” - “43.98”…

{
   "status":"success",
   "isPartial":false,
   "data":{
      "resultType":"matrix",
      "result":[
         {
            "metric":{
               "central_unit_label":"0",
               "device_model":"MHT03",
            },
            "values":[
               [
                  1698218620,
                  "43.98"
               ],
               [
                  1698218920,
                  "43.98"
               ]
            ]
         },
         {
            "metric":{
               "central_unit_label":"0",
               "device_model":"HT02",
            },
            "values":[
               [
                  1698218620,
                  "59.4"
               ],
               [
                  1698218920,
                  "58.13"
               ]
            ]
         },
         {
            "metric":{
               "central_unit_label":"0",
               "device_model":"MHT03",
            },
            "values":[
               [
                  1698218620,
                  "54.16"
               ],
               [
                  1698218920,
                  "54.16"
               ]
            ]
         },
         {
            "metric":{
               "central_unit_label":"0",
               "device_model":"HT02",
            },
            "values":[
               [
                  1698218620,
                  "58.19"
               ],
               [
                  1698218920,
                  "52.95"
               ]
            ]
         }
      ]
   }
}
2

You can use the list-index: the first “43.98” for instance can be reached by: data["result"][0]["values"][0][1].
This might not be fully correct but this will give an idea how it could be done :slight_smile:

1 Like
3

Thank you @bouwew

This works fine:

{{value_json.data['result'][0]['values'][0][1]}}
4

You’re welcome!