How to convert json format into the xml format.

Legacy Contributor

Hi Everyone,

I'm getting the data in JSON format from the source system using API connection point.

How can i convert JSON response as xml format to send to the target system.

Kindly suggest.

Regards

Satish

Find more posts tagged with

ION Connect

Accepted answers

Legacy Contributor

Did you check the standard Output options in IONAPI connector? See the various formats available in the IONAPI connector in the Technology connector guide ->https://www.inforxtreme.com/esknowbase/root/DLPublic/50436/ion_12.0.x_iontechconceag_cloud_en-us.pdf -> Page 99. If the API returns an JSON and you simply want to convert that to a BOD, Then you should be able to do it automatically. Select the Output BOD document first. Usually such BODs will be a custom BOD, so you can also use the "Generate Metadata option" to generate schema for your custom BOD. This custom BOD will be based on the following steps:
1. Your JSON will be internally converted to an corresponding XML.
2. This XML will then form the Noun part of the DataArea of your custom BOD.

If you don't want an automatic wrapping, but want to control the output BOD according to your needs, you can also do in place hard coded XML or JSON output and substitute the values from the response using the $IonApiRef xpath addressal by choosing "Map API response to the document" option.

Subsequently you have to select the output format as "BOD from JSON".

This should automatically convert your JSON output to a (custom) BOD of your choice. Hope this helps.

All comments

Legacy Contributor

Hi Satish,

can you please describe a bit more, what you are trying to achieve? Maybe getting data from a web API and then do what? Create a BOD or what is the goal? What technologies are you using for getting the Json and what is the destination of the XML?

Regards,

Marc

Legacy Contributor

Hi Marc thank you for swift response.

I'm trying to fetch the data from one system using ION API connection point in json format, and want send that data/json data to an ERP application as bod(i mean in xml format).

Regards

Satish

Legacy Contributor

Hi Satish,

still not 100% clear for me, but I explain you what I have done, maybe this helps.

I am currently connecting the PIM system Akeneo to ION and LN. The conneciton to Akeneo is implemented by using SQL Server 2017 with SSIS. Inside SSIS I am pulling data from Akeneo via the Webservice API provided by Akeneo. The results are coming in Json format. That Json is then converted into XML BODs also using SQL Server/ SQL+SSIS. SQL Server 2017 is supporting Json and XML handling natively but there is an issue with UTF8 compatibility (you need a workaround with a SSIS script component) that should disappear with SQL Server 2019.

If any of those technologies mentioned fit to your environment, then let me know and I might help, but if not then you should explain a bit more about what you are achieving.

Best regards,

Marc

Legacy Contributor

Hi Marc,

The Integration between Sales force and XA platfrom. I used to get the data from SF using ION API connection point in JSON format and i have to send it to XA ERP application as a bod, then how can i proceed further

Regards

Satish

Copyright © 2025 Infor. All rights reserved.