How to parse this data on Grafana

[gagiuntoli]

I have the result of the following GraphQL query on the Query Inspector -> Data:

{"trades":[{"timestamp":"1668617006","tradeAmount":"100000000"},{"timestamp":"1673707542","tradeAmount":"100000000"}]}

I want to parse it an create a table:

timestamp | tradeAmount
1668617006 | 100000000
...

I am stuck at this point using the backend parser. This is my query:

{
  trades (first: 50) {
  	timestamp
	  tradeAmount
	}
}

And my endpoint: https://api.thegraph.com/subgraphs/name/sportsfi-ubet/ubetmumbai-sandbox

[deathsaber]

You can use the UQL parser to extract the fields and create a table out of them.
Try using -

json-parser
| scope "trades"

Hope it helps you!