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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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.