Can't acces specific data in nested json object using infinity datasource

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

  • What are you trying to achieve?
    Access properties from nested objects

  • How are you trying to achieve it?
    Using infinity datasource to do a POST request. Then using transformations and the query options to access to them. I tried writing $.health.healthStatus in the Rows / Root part of the quwery to get to them but it doesn’t work. Writing $health works but just to get to the first properties, and I need to get to the healthStatus properties of each. I need a sort of table with all those healthStatus per object. I left attached the json example I use and the query.

  • What happened?
    I can’t access them because it is not an array of objects and I can’t find the way.

  • What did you expect to happen?
    Be able to create a chart I show in the attatched file

You can use jsonata kind of query to get what you want

Thank you! I didn’t use exactly the same jsonata query but your answer was very helpful because it gave me an idea!!!