Hello All,

We are using Sterling Integrator 5.2.6.2 and we come across one Integration where we need to call REST API with only Json format supported.
I know from SI 6 onwards there is XMLtoJSON and JSONtoXML service by default with Product but in current SI version we have is there any recommended way by which we can achieve this integration with REST API in json format ?
Kindly help.
Thank you.

//Kartik

------------------------------
Kartik Patel
------------------------------

#SupplyChain
#B2BIntegration

Hi Kartik,
as you correctly indicated, XMLroJSON service, to transform an XML to a JSON and vice versa is available from 6 onwards.
In 5.2.x you can use the map editor to  have in input an XML file  and in output a CSV one (or vice versa, depending on the transformation you want to achieve). In the CSV file the filed separator will be the ":". You will need to play with the brackets "{}" but it's achievable.
Another way when changing from XML to JSON is to use an XSLT to do the job.
Best regards
Emiliano Pacelli

------------------------------
Emiliano Pacelli
------------------------------