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.
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
Thank you! I didn’t use exactly the same jsonata query but your answer was very helpful because it gave me an idea!!!