Hello,
I’m trying to transform table data using the Infinity plugin as the main datasource (Grafana version 9.1.7).
API endpoint used:
https://9498199887151372.hostedstatus.com/1.0/status/5d849b1c02e65b3ec45369d4
Current table view is as follows:
We would like to represent the data as follows:
name (column 1) | status (column 2)
unique values from the column 2 | Operational status
Please find the current configurations set up and highly appreciate if you could advise which particular transformations can be used in this case.
Thanks,
Eugene
grant2
2
Hi Eugene @esheyko
Reply is 6 months late, but whatever 
I got this:
using this:
UQL code:
parse-json
| project "result"
| project "status"
| extend "containers"
| project-away "containers", "id", "status_code", "updated"
Thank you, it also worked using the URL source as follows:
result.status[name="United Kingdom Grid"].containers
Also, was trying to parse the [status.aws.amazon.com/rss/all.rss] RSS feed as suggested in the native plugin discussions:
https://github.com/grafana/grafana-infinity-datasource/discussions/244
It doesn’t look like it work if we specify the “rss.channel[0].item” value as Rows/Root but it works if I set the “rss.channel”.
Wondering if it’s possible to return the combined set of services if all are OK per region.
