topic Re: output row value in tRest URL in Talend Studio

output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 11:27:27 GMT

My first REST call returns ID that I need to use in second REST call URL (GET request)

I thought in URL I can do something like:

context.host + row2.id

context.host + globalMap.get("row2.id");

but I'm getting "row2 cannot be resolved to a variable" error.

How do I reference this "id" in tRest and other components?

Thanks,

Dima

Re: output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 11:41:16 GMT

Hi Dima,

Just add a tFlowToIterate immediately before your map, and you'll be able to reference row2.id.

Regards,

Chris

Re: output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 13:07:44 GMT

Thanks, Chris. That helps iterate tRest but I get 'null' for my ID

Re: output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 13:18:24 GMT

Can you either use debug or drop a tLog in there to ensure you do actually have data in the field?

Re: output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 14:36:51 GMT

It does return the correct ID

Re: output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 14:50:35 GMT

Can you show the entire job with the tFlowToIterate in place? Thanks.

Re: output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 14:56:07 GMT

Replace tLogRow_3 with tSetGlobVar and capture the id in a variable
Example: your_variable_name=row2.id

Then You can reffer the id in next call using globalMap.get('your_variable_name')

Re: output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 15:14:53 GMT

That's it! Thanks a lot. I guess I can only reference "row2.id" in tMap but for components like tRest I need to declare a variable

Re: output row value in tRest URL

Anonymous — Wed, 11 Oct 2017 15:46:18 GMT

If you want your job to run multiple restGET1+restGET2 then ,
You should propogate the rowX.id to a t FlowToIterate & then to restGeT2, as suggested by @ciw1973