tREST->tExtractJSONFields empty result

Anonymous — Mon, 05 Feb 2018 09:57:49 GMT

Hi all, I am using tREST to retrieve data from openweathermap.org with the following API call:

"http://api.openweathermap.org/data/2.5/forecast?id=5128581&APPID=845db74f9ad508bb72241cafec6f534f"

I get the data and can save it in a file locally. But I only need dt_txt and description. So I would like to extract this information directly from the tREST-component. In the screenshot my job design can be seen.

The result is unfortunately empty.

I tried with other tool to see if my Path Expression is correct and there it worked, so this shouldn't be the issue.

Can anyone point me to what I might be doing wrong and what I can do to make it work?

Thanks for help.

Re: tREST->tExtractJSONFields empty result

Anonymous — Mon, 05 Feb 2018 13:32:07 GMT

Looks like you have the loop query defined twice. Try deleting:

$.list[*]

from each json_query field.

The fields should just be:

Re: tREST->tExtractJSONFields empty result

Anonymous — Mon, 05 Feb 2018 14:43:47 GMT

Yes, this was my mistake, thank you so much for help.

topic Re: tREST->tExtractJSONFields empty result in Talend Studio

tREST->tExtractJSONFields empty result

Re: tREST->tExtractJSONFields empty result

Re: tREST->tExtractJSONFields empty result