topic Re: tRestClient - GET - using parameters in Talend Studio

tRestClient - GET - using parameters

Anonymous — Thu, 07 Mar 2019 04:42:58 GMT

Hello All,

I am stuck with a scenario where I use Talend rest API [ POST ] to run a different job and in response it gets 2 attributes in json run_id and number_in_job.

Now, I need to take the run_id number and invoke a API GET call to see the job result [ Success or Failure ] .

I know the URL for POST and GET.

How can I integrate API request [POST} and API [GET] to see the final output.

Thanks

Sathya

Re: tRestClient - GET - using parameters

vapukov — Thu, 07 Mar 2019 08:31:17 GMT

Hi Sathya

call the first API, use tExtractJSONFields to extract values from response JSON, store it to variable

use this variable in 2nd subjob to 2nd API call

Re: tRestClient - GET - using parameters

Anonymous — Thu, 07 Mar 2019 10:39:40 GMT

Hi Vapukov,

Thanks for your response. Can you please explain me a bit as I am very new to ETL world.

I am trying as in the attached pic.

I a using tRest with POST to trigger a job and in response I am getting {"run_id":96,"number_in_job":20}

I need to use the "run_id":96 in another GET API to see the result.

GET API :- https://abc.net/api/2.0/job/runs/get?run_id=96

Thanks for helping

Sathya

pics1.PNG

Re: tRestClient - GET - using parameters

Anonymous — Thu, 07 Mar 2019 10:53:55 GMT

Given the JSON you are receiving back, you need to configure your tExtractJsonFields component as in this image....

Your "JSON Field" value will be the output String column of your tRest component. If you configure the tExtractJsonFields component as above, it will output the values held in the JSON. Then you need to create your URL for your next API call using String concatenation.

Re: tRestClient - GET - using parameters

vapukov — Thu, 07 Mar 2019 11:23:20 GMT

@thinksathya wrote:

Hi Vapukov,

Thanks for your response. Can you please explain me a bit as I am very new to ETL world.

I am trying as in the attached pic.

I a using tRest with POST to trigger a job and in response I am getting {"run_id":96,"number_in_job":20}

I need to use the "run_id":96 in another GET API to see the result.

GET API :- https://abc.net/api/2.0/job/runs/get?run_id=96

Thanks for helping

Sathya

as showing by @rhall

first, you need to extract JSON

then you could use this column value in next component

Re: tRestClient - GET - using parameters

Anonymous — Thu, 07 Mar 2019 13:05:25 GMT

Sorry @vapukov, I wasn't meaning to steal your thunder. I thought you might be asleep now 🙂

Re: tRestClient - GET - using parameters

vapukov — Thu, 07 Mar 2019 13:09:52 GMT

this is global resource - "The early bird catches the worm" 🙂

Re: tRestClient - GET - using parameters

Anonymous — Fri, 08 Mar 2019 02:34:31 GMT

Hi,

Thanks for your response. I tried the same but couldn't achieve what I need. Attached the snapshot of what I have done in the name 1,2 and 3.png.

I can see the job is running but I can't see the output from the GET API.

Thanks

Sathya

1.PNG
2.PNG
3.PNG

Re: tRestClient - GET - using parameters

vapukov — Fri, 08 Mar 2019 04:19:37 GMT

you need to use different connections between components

Iterate in your case does not transfer the value but do the loop only

and in 2nd tRESTClient, you need variable stored by iFlowToIterate, by default, it will be

(String)globalMap.get("row2.run_id")

row2 - it is name of input connection line for tFlowToIterate,

tJavaFlex - do nothing, empty