Step 6:- (Optional) If you are using REST channel, don’t forget to set the data as JSON in the Receiver channel Step 5:- Assign values to these parameters in the Integrated Configuration as required Step 4:- Define Binding for the JAVA mapping in operation mapping as below:

NUM_TO_STRING – Simple Type – xsd:string.

LAST_LEVEL_TO_KEEP – Simple Type – xsd:int.

DELETE_ENTRY – Simple Type – xsd:string.

Step 3:- Define the 5 Import parameters in operation mapping. Step 2:- Use the java mapping in your operation mapping

So do import the orgXmlJson jar file also. Please note the Java mapping uses java library to convert XML to JSON, so if it’s not in your SAP library, you will receive missing ‘’ error. Import the 2 jar files in SAP ESR as Imported Archives. You can directly download the zip file from here and unzip it. This can be used in any SAP PI/PO version.Įxamples are illustrated further below after the implementation section. This blog focus on XML to JSON conversion using Java Mapping and also provides the liberty to play around with the structure. Hence, I have implemented a Generic Java Mapping that can be used to achieve this and many other tasks. The Custom XML to JSON Conversion bean also doesn’t help much here, especially if you wish to remove a node from the JSON structure.

However, this liberty isn’t available on SAP PI versions 7.4 & below. However, there are many restrictions on it in SAP PI/PO.īesides, in SAP PO 7.5 we can easily remove a key name by listing the tags in ‘setIgnoredElements’ on REST Receiver Channel. We can easily convert XML to JSON on the REST channel. I was recently trying to convert XML To JSON in the below format in SAP 7.4 and also trying to remove certain tags from the XML structure and force a few nodes as JSON Array. Update 10th July 2020 – Added functionality to convert numbers to String using the NUM_TO_STRING parameter.

Convert json to xml c#