AnsweredAssumed Answered

JSON Document Splitting and Process

Question asked by faisal.ali397074 on May 18, 2017
Latest reply on May 19, 2017 by RaphaelRivero

Hi

I have a Boomi RESTful listener setup that can receive 1 or more JSON objects in a single request

 

Here is an example JSON request with three objects  :

i.e.

{
"empinfo": [{
      "eid": "1234567",
      "sid": "s1234567",
      "eml": "test@xyz.com"
},
{
      "eid": "2234567",
      "eml": "test2@xyz.com"
},
{
      "eid": "3234567",
      "sid": "s3234567"
}
]
}

 

I put this above JSON data in a message shape - for test purposes -  and the process looks like:

 

 

Message - contains the JSON data above

Data Process - split the JSON by object

New Map - created by importing:

{
"empinfo": [{
"eid": "1234567",
"sid": "s1234567",
"eml": "test@xyz.com"
}]
}

 

For some reason, when reaching the message shape only, I get:

 

Test execution completed with errors. Embedded message: can't parse argument number: "empinfo": [{ "eid": "1234567"; Caused by: For input string: " "empinfo": [{ "eid": "1234567""

 

Not understanding why this is trying to parse at the message shape? If I put the above JSON in a JSOn validator, it does come back as valid 

Outcomes