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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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.