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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
singhcv123
Contributor
Contributor

trestclient confusion to get exact data

Hi ,

I am trying to load the data from trestclient to tExtractJsonField.

While connecting i am confused to map the output with tExtractJsonFIeld .

0693p00000BAKpPAAX.png

here is the configuration for tRestClient

0693p00000BAKpZAAX.png

configuration for tExtractJsonField

0693p00000BAKpeAAH.png

I am unable to parse the data in tExtractJson Field.

Finally, my data looks like below :

URL: https://reqres.in/api/users/2

{"data":{"id":2,"email":"janet.weaver@reqres.in","first_name":"Janet","last_name":"Weaver","avatar":"https://reqres.in/img/faces/2-image.jpg"},"support":{"url":"https://reqres.in/# support-heading","text":"To keep ReqRes free, contributions towards server costs are appreciated!"}}

Labels (3)
1 Reply
Anonymous
Not applicable

Hi

Set the Loop Jsonpath query field as "$.data", you should be able to to extract the data from response.

 

Regards

Shong