Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need to figure out how to extract JSON without looping

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
}

 

Labels (4)
1 Reply
Anonymous
Not applicable
Author

Just set the loop path to.....

"$"

Then set your paths for the values relative to the start of the JSON document.