How to convert json to datatable and add to queue orchestrator

Help Activities
, , , ,
1

Hi Team,

This is my json file

{
“responseCode” :0,
“responMessage”:Success,
“holdrecords”:[
{
“holdExp”:“157996457”,
“SampleType”:“ABB”,
“phone”:“489962574”,
“mail":"dahse@gmail.com”
},
{
“holdExp”:“217856457”,
“SampleType”:“MMS”,
“phone”:“982542574”,
“mail":"adeswse@gmail.com”
},
{
“holdExp”:“157996457”,
“SampleType”:“WIE”,
“phone”:“886342574”,
“mail":"ewswqske@gmail.com”
}
]
}

Expected output

image

Getting Error:

While using desterilize JsonArray activity this error appeares as shown below

"Desterilize JSON Array: Error reading JArray from JsonReader , Current JsonReader item is not an array:StartObject. Path “, line 1, position 2”

Please help anyone to comeout from this situation.

Regards,
Raja G

1 Like
2

You can’t add datatables to a queue. You can add the JSON as a string.

Anyway, the error is telling you that your JSON is not valid JSON, which it isn’t.

1 Like