Question Re: XML to JSON conversion issues with Boolean and Double data types in Technology Q&A

XML to JSON conversion issues with Boolean and Double data types

amallick — Wed, 08 Apr 2020 20:11:47 GMT

Hello Experts,

I'm trying to use the standard XML to JSON Converter on the Cloud Platform Integration iFlow, but facing the following challenges:

1. In traditional PO environment when we use the REST receiver adapter and do the XML to JSON conversion, it does not add double quotes (" ") around Boolean data types, but the Cloud Integration converter is treating all data types as strings.

2. Again in traditional PO environment we could provide the default values in the adapter XML/JSON conversion rules, like following:

But I couldn't find a place in the Cloud Integration converter to do the same and it's also double quotes around Decimal/Double data types, like:

I feel a need to use a Groovy script, but I'm not an expert and there are not good documentation available on the internet today. I looked into SAP note 2521044 and tried using the sample groovy attached to it, but received the following error:

Looking forward to the experts to help me resolve it.

Thank you,

Anirban

Re: XML to JSON conversion issues with Boolean and Double data types

ibibhu — Wed, 08 Apr 2020 20:35:07 GMT

HI amallick,

Query 1:Cloud Integration converter is treating all data types as strings.

Please check Limitations for XML-to-JSON Conversion

"No conversion to JSON primitive types for XML to JSON. All XML element/attribute values are transformed to a JSON string."

And the same is also referred in 2521044 - CPI: XML to JSON Converter treats Integer as String

for the error:
Can you please attach the groovy script and body that you are passing to it (you can capture the same by enabling trace)

Regards,
Bibhu

Re: XML to JSON conversion issues with Boolean and Double data types

MortenWittrock — Wed, 08 Apr 2020 20:38:00 GMT

Hi Anirban

As you've discovered, the XML to JSON converter in CPI doesn't have a lot of functionality at this point. As mentioned in the note, all values are treated as strings, even though all values are not strings, obviously.

For now, you will have to clean up the JSON with a Groovy script. I don't see a problem with the sample script attached to the note.

I would suggest that you try and update the script yourself. If it doesn't work out, post a new question and include the script code, a sample of the JSON you want to clean up and what it should look like after it's been cleaned up. Post everything as text, please, for easier copy-pasting (i.e. not images).

Regards,

Morten

Re: XML to JSON conversion issues with Boolean and Double data types

amallick — Wed, 08 Apr 2020 21:01:44 GMT

Hi Morten,

Thanks for the comment, I opened a new question with the details and closing this thread.

Regards,

Anirban