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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tREST->tExtractJSONFields empty result

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.

0683p000009Lsva.png

The result is unfortunately empty.

0683p000009Lsvf.png

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.

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

$.list[*]

from each json_query field.

The fields should just be:

0683p000009LsnI.png

 

View solution in original post

2 Replies
Anonymous
Not applicable
Author

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

$.list[*]

from each json_query field.

The fields should just be:

0683p000009LsnI.png

 

Anonymous
Not applicable
Author

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