I am using a REST call to get a JSON reply back from our CRMs API - this all works and I get the reply placed in a string variable.
When I watch a reactive debug, the string variable with the JSON response is using escape charaters for the double quotes as below which I would expect is normal for a string:
sResponse String U"[ { \"id\": 70333 }]"
I then am using a Create JSON Document step to put the string into a JSON doc for parsing but while watching in the reactive debug, the DOC value following this step still contains the escape characters and the subsequent Get JSON Document Data step to parse it fails:
dJSONOutput Document TEXT[[ { \"id\": 70333 }]]
JSON path I am using is $.*.id which I have validated using JSONpath
Full script attached:
Am I missing something to get the JSON properly in the document? Any help would be much appreciated!
Thanks,
Greg
