Issue extracting data from XML SOAP API to JSON array using Infinity Data Source

  • What Grafana version and what operating system are you using?
    Grafana 11.1 Enterprise under Ubuntu 24.04
  • What are you trying to achieve?
    Trying to display ALL the records and elements of data in Table Visualization
  • How are you trying to achieve it?
    Using Infinity DS through SOAP API trying to get an XML from a URL and then parsing it into JSON using UQL parser. After conversion, using table visualization transformations to display the required data.
  • What happened?
    Each index of array appears in a separate column as a single row
  • What did you expect to happen?
    Each array element separated as column and each array index as a separate row.
  • Can you copy/paste the configuration(s) that you are having problems with?
    Sure can, but cannot isolate at the moment whether the issue is in UQL parser or Grafana transformations.
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    JSONPath doesnt seem to work while extracting from JSON
  • Did you follow any online instructions? If so, what is the URL?
  • Several instructions and docs.

you cant do that as it does not have xml to json parser as far as I know
please post sample xml and which part of the xml you want to extract into what lomd of visualozation