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.
In reply to Marc Schrod:
In reply to 1753258:
I need further discussion in the forum it seems.
Source system is sending data in JSON format using ION API.
Target system is expecting XML format, ERP Application.
In Mapping, For bods type only we can do the Graphical mapping or Sensitive mapping(Please find the below reference screen shot).
There is no option of JSON to XML mapping in Infor OS.(Please check in the mapping option once.)
Might be we need manual mapping here it seems.
Can any one suggest me, how can i proceed further ?
Please find the below references.
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.
In reply to Vignesh: