topic Re: tRestClient to tExtractJSONFields unable to extract data in Talend Studio

tRestClient to tExtractJSONFields unable to extract data

anand17072020 — Fri, 15 Nov 2024 22:05:31 GMT

Hi All,

I am able to print to tLogRow from tRestClient the whole json file without any issues. But having issues with extracting the fields I need using tExtractJSONFields from tRestClient.

Json file:

{

"message": "Successfully retrieved promotions",

"errors": [],

"validationErrors": [],

"data": [

{

"tlt": "005",

"appName": "platform"

{

"tlt": "007",

"appName": "server"

}

]

}

Re: tRestClient to tExtractJSONFields unable to extract data

rhall1 — Fri, 17 Feb 2023 01:40:04 GMT

You need to make a couple. of changes here. The first change is that the tRestClient will be passing the JSON using the "string" column and not the "body" column. So change your JSON field to "string". The next is your "Loop jsonpath query". This needs to be....

" $.data[*]"

After these changes, it should start producing results for you.

Re: tRestClient to tExtractJSONFields unable to extract data

anand17072020 — Fri, 17 Feb 2023 17:09:55 GMT

Thank you so much!! it worked.