SAP CPI JSON to XML conversion: Use JsonReader.setLenient(true) to accept malformed JSON

[iglmarkus]

Hello Experts,

I am getting the this error using standard JSON to XML converter: Use JsonReader.setLenient(true) to accept malformed JSON.

I got the payload from HTTP get consuming 3rd party API. With a groovy script I removed already the first "[" and last "]" (as JSON to XML will fail).

Below the payload and the corresponding error message.

this part of the payload:

"Id":"579dc1e6-e983-4543-917c-f524115db14e","CountryCode":"US","Name":"United States"},{"Id":"7b218eb7-219e-46aa-a4fc-694afedb2fe0","CountryCode":"CA","Name":"Canada"},{"Id":"38a20ece-6356-4a56-919f-959a7c94e9b7",

thanks, Markus

[MortenWittrock · Accepted solution]

Hi Markus

The JSON to XML Converter step wants a top-level JSON object, not an array (even though a top-level array is valid JSON). So you need to fit your array into an object. This is one way to do it:

{
  "objects": [
    {
      "Id": "579dc1e6-e983-4543-917c-f524115db14e",
      "CountryCode": "US",
      "Name": "United States"
    },
    {
      "Id": "7b218eb7-219e-46aa-a4fc-694afedb2fe0",
      "CountryCode": "CA",
      "Name": "Canada"
    },
    {
      "Id": "38a20ece-6356-4a56-919f-959a7c94e9b7"
    }
  ]
}

You can accomplish this by adding a Content Modifier step after your API call with the following body expression:

{
  "objects": ${body}
}

This assumes that your API call returns a JSON array.

Regards,

Morten

[iglmarkus · Accepted solution]

HI Morten,

it works well!

thanks for your help!!

cheers Markus

[MortenWittrock · Accepted solution]

Hi Markus

Great, glad to hear it. Since my answer solved your problem, I'd appreciate it if you would accept it as well.

Regards,

Morten

[naga33]

[

    {

        color: "red",

        value: "#f00"

    },

    {

        color: "green",

        value: "#0f0"

    },

    {

        color: "blue",

        value: "#00f"

    },

    {

        color: "cyan",

        value: "#0ff"

    },

    {

        color: "magenta",

        value: "#f0f"

    },

    {

        color: "yellow",

        value: "#ff0"

    },

    {

        color: "black",

        value: "#000"

    }

]