Need to figure out how to extract JSON without looping

Two Stars

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
}

 

Community Manager

Re: Need to figure out how to extract JSON without looping

Just set the loop path to.....

"$"

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog