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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Trying to tExtractJSON from REST response, running into problem

I have a project where I have to make a rest call to first get an id , then use that id for a subsequent rest call
the best tutorial i found had it setup like so
tRestClient->fileOutPutJSON(result.json) then FileInputJSON(result.json) ->ExtractJSONFields->tRestClient2ndRequest

issue is that tRestClient  response returns this

{"data":[{"string":"{ \"id\": \"180244\" }","body":null,"statusCode":200}]}

the curl call for this would return

{ "id": "180244" }


and its the string that is not allowing me to parse out the data properly

here is where I am getting a JSON parsing error...how can i parse that string i have above, seems like its a string ina  string
Labels (4)
2 Replies
Anonymous
Not applicable

for some reason my images didnt post here they are


0683p000009MG5I.png 0683p000009MG1b.png
vapukov
Master II
Master II

First of all - You can save response  String in more correct form
if You plan use id for next tRESTClient call, You really do not need 2nd time extract column
tFileInputJSON already can extract it

Id - "id"

0683p000009MG5N.png   0683p000009MG5S.png