Need to figure out how to extract JSON without looping

Anonymous — Wed, 29 May 2019 16:52:42 GMT

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
}

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

Anonymous — Wed, 29 May 2019 17:15:10 GMT

Just set the loop path to.....

"$"

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

topic Re: Need to figure out how to extract JSON without looping in Talend Studio

Need to figure out how to extract JSON without looping

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