How to join and display data from XML and JSON APIs in a single Grafana Infinity Datasource panel without external preprocessing?

[AdnanKahveci]

Hello,

I want to create a Grafana panel using the Infinity Datasource that combines data from two different API endpoints: one returning XML data and another returning JSON data.

Is it possible to join these two data sources directly within Infinity Datasource and display the merged results in a single panel? If yes, how can I configure this? If not, what would be the best approach to achieve this within Grafana without external data processing?

Thanks in advance!

[gdiana]

The answer is yes it is possible and all done within GRAFANA with no external processing.

You simply need to create 2 separate queries A and B to each provide their own table of data one from XML and the other from Json.

If your data sources require tokens or passwords then these will have to be parsed as query paraneters as each source may only have one set of passwords and tokens. If this is not a problem then no issue.

The XML data will need to be parsed using the UQL jsonata feature but the json data may use the JSONATA front end feature.

You can use either to format the data into columns one for QUERY A and another for QUERY B and then use the transformation feature to join them and then reorder and rename as you require.

If you can you can provide a short sample of your xml and json data and I can try and show what may be done?