Question Re: Cannot transform JSON document to XML: JSON document does not start with '{'. in Technology Q&A

Cannot transform JSON document to XML: JSON document does not start with '{'.

former_member841349 — Thu, 09 Feb 2023 21:59:30 GMT

Hi experts,

I have an issue in CPI using the JSON to XML converter, I tried to use it and CPI response me the next message: com.sap.it.xmljson.JsonXmlException: Cannot transform JSON document to XML: JSON document does not start with '{'.

I have the following JSON body that I need to convert to XML

I know the problem is [ at the beginning of the body. My question is, how can I remove that symbol to be able to use the JSON to XML converter?

I appreciate your answers

greetings

Re: Cannot transform JSON document to XML: JSON document does not start with '{'.

Ryan-Crosby — Thu, 09 Feb 2023 22:11:59 GMT

I'd say it makes more sense to look further upstream and understand why you have invalid JSON at that step.

Re: Cannot transform JSON document to XML: JSON document does not start with '{'.

former_member841349 — Fri, 10 Feb 2023 04:22:52 GMT

Hi Ryan, this is the beginning of the message, this is the json that the server responds. I want to know how I can delete that symbol

Re: Cannot transform JSON document to XML: JSON document does not start with '{'.

RobertQ — Fri, 10 Feb 2023 08:11:12 GMT

Hello Sara,

this is a limitation from the Json to XML Converter as stated in the documentation.

You can simply add a content modifier as described their and process the message.

Here an example with a simulation. I also had to add a second "root" element as their is alos a limitation that the root Object can only have one member. So I added a second root (the name can be adjusted in the Converter).

Content Modifier:

JSON to XML Converter:

Simulation Body input:

Simulation Body Middle:

Simulation Body End:

I hope this helps you with your issue.

Best Regards

Robert

Re: Cannot transform JSON document to XML: JSON document does not start with '{'.

chris_75 — Fri, 10 Feb 2023 08:31:02 GMT

Hi Rian,

another simple solution without adding an additional root tag to the payload is to insert a script step which removes the first an the last String

def inputJson = message.getBody(String)
def outputJson = inputJson.substring(1, inputJson.length()-1)
message.setBody(outputJson)
return message

Re: Cannot transform JSON document to XML: JSON document does not start with '{'.

former_member841349 — Fri, 10 Feb 2023 16:00:01 GMT

Hi Christian,

I proved your solution but I recive another error:

com.google.gson.stream.MalformedJsonException: Use JsonReader.setLenient(true) to accept malformed JSON at line 1 column 519 path $

Re: Cannot transform JSON document to XML: JSON document does not start with '{'.

former_member841349 — Fri, 10 Feb 2023 18:47:22 GMT

Hi Robert,

Your solutions works,

Thanks for your help

Re: Cannot transform JSON document to XML: JSON document does not start with '{'.

RobertQ — Mon, 13 Feb 2023 08:06:06 GMT

Hello jaimestrada,

if the solution works, please mark my answer as accepted, so other peaople can find this solution more easily.

Best Regards

Robert