Woah cool use case @maillme! We have a feature request on file to build in better support for xml responses. I'll post back here if we're able to fulfill that request.
In the meantime, this is doable with some Javascript code.
I followed this community post to get started.
- Import the fast xml parser library (or any xml parsing library that you prefer) using these instructions
- Add a transformer to your query that parses the xml. The code may look slightly different for your app, but here's an example:
I've attached this sample app if you'd like to import it to your instance & test it out
xml-20parsing (1).json