API conversion from XML to Json

[JonL]

Did you try the solution I posted?

Is there any way to deal with XML responses for data

I’ll add also the xml2json formatter with a more complex xml response in case it’s eventually needed. XML response: https://www.w3schools.com/xml/plant_catalog.xml PHP SC formatter: <?php namespace lib\core; function formatter_xml2json($val) { $xml = simplexml_load_string(strval($val)); return json_decode(json_encode($xml)); } SC file <?php require('../../dmxConnectLib/dmxConnect.php'); $app = new \lib\App(); $app->define(<<<'JSON' { "settings": { "options": {} }, "m…

PHP SC formatter:

<?php

namespace lib\core;

function formatter_xml2json($val) {
    $xml = simplexml_load_string(strval($val));
    return json_decode(json_encode($xml));
}

It's pretty simple.

{{ api1.data.xml2json() }}