topic Trying to tExtractJSON from REST response, running into problem in Talend Studio

Trying to tExtractJSON from REST response, running into problem

_AnonymousUser — Sat, 16 Nov 2024 10:13:04 GMT

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

Re: Trying to tExtractJSON from REST response, running into problem

Anonymous — Thu, 08 Dec 2016 15:19:24 GMT

for some reason my images didnt post here they are

Re: Trying to tExtractJSON from REST response, running into problem

vapukov — Thu, 08 Dec 2016 22:07:28 GMT

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"