Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have added a rest call to a job. It returns a response that contains a status and a body object. The body contains JSON. There is no array. I want to parse/extract the data using tExtractJsonFields, but it seems to require a loop path, which I don't have. Any suggestions? Here is the json in the body:
{
"sid": 154427,
"spaJobType": "DATAMART_POST_PROCESSOR",
"spaJobStatus": "ABORTED",
"startedByUser": "spa-datastage-batch",
"targetCount": 4753123,
"progressCount": 12798,
"errorCount": 0,
"createdAt": "2019-02-14T02:42:03Z",
"modifiedAt": "2019-02-14T03:02:12Z",
"completedAt": null
}
Just set the loop path to.....
"$"
Then set your paths for the values relative to the start of the JSON document.