JSON to XML error Rest

[former_member190536]

Hello,

I am using REST Adapter to receive JSON format message in PO.

the normal XML work for me, but when we have ATTRIBUTES in our strucutre then the json to xml conversion error is coming due to this in mapping the message gets failed.

My target xml strucutre like this.

<CalculationBaseQuantity unitCode="KG">1</CalculationBaseQuantity>

in my source JSON  it is coming like this..

                            "CalculationBaseQuantity": {

                                "-unitCode": "KG",

                                "#text": "1"

After Seder adapter the message come in mapping as ...

<CalculationBaseQuantity><-unitCode>KG</-unitCode><#text>1</#text></CalculationBaseQuantity>

due to this mapping getting failed as xml formatting issues.

error in mapping - The content of elements must consist of well-formed character data or markup., BaseRuntimeException: The content of elements must consist of well-formed character data or markup., BaseRuntimeException: The content of elements must consist of well-formed character data or markup.,

does standard REST adapter wont support this functionality? does i need to go for Custom adapter only?

[Former Member]

Hello Khaja,

I guess the source JSON is not well formatted.

Tats why getting the error while converting to XML.

https://www.freeformatter.com/json-to-xml-converter.html

[former_member190536]

Ya i am doing from those tools only.

[Former Member]

Source Has the same JSON?it seems to be wrong.

Might you require a module to convert it in SAP PI.

[former_member190536]

so for this <CalculationBaseQuantity unitCode="KG">1</CalculationBaseQuantity>

how JSON to be expected? then I will correct this JSON and I will send test to PO.

[Former Member]

Check the below example

JSON Example