topic Re: passing value to trest in Talend Studio

passing value to trest

Anonymous — Sat, 16 Nov 2024 09:24:12 GMT

hi ,

I have an issue in my job.

I have loaded some reports from an API using tRest component.

while I am extracting that API ,I am getting some data like id,name and key column and value below it.

so I have done the job like tRest component(POST method) --> tExtractJSONFields ----> finally loaded it to tfileoutputexcel

so in this I am getting ouput like

id,name,key

1,janu,Mnv674=

so the key which I got will be expired in every 8 hours.

so I want the key to be parsed to another trestcomponent (POST method) automatically.

I have done the job like

tREST component (POST method) --> tExtractJSONFields ----> tfileoutputexcel --------------------- (on component ok) ------> tREST component -------> tExtractJSONFields ------------> tfileoutputjson

in the 2nd tREST component I will pass the key we are getting from the excel output into the http headers.

I want the key to be automatically loaded to the second job.

could anyone of you please help in this.

regards,

harshi

Re: passing value to trest

Anonymous — Thu, 17 Aug 2017 10:49:59 GMT

Hi Injarapu,

I don't know if it's work, but you can try this.

After your tfileoutputexcel, you can use a tJavaFlex and in the principal code, write : globalMap.put("KEY", tFileoutputExcelRow.key)

Then : tJavaFlex --- Iterate --- tRest

And on your tRest, "http://www.blabla.com/"+(String)globalMap.get("KEY")

Good Luck ,

SGV

Re: passing value to trest

Anonymous — Thu, 17 Aug 2017 11:08:55 GMT

Hi
Store the key to context variables for used on the second calling. eg:'
tREST component (POST method) --> tExtractJSONFields ----> tfileoutputexcel -----main--tjavaRow---------------- (on component ok) ------> tREST component -------> tExtractJSONFields ------------> tfileoutputjson

on tjavarow:
context.key=input_row.key;

on the second tRest, you can use this context variable.

Regards
Shong

Re: passing value to trest

Anonymous — Thu, 17 Aug 2017 13:53:10 GMT

thank you but its not working sir

Re: passing value to trest

Anonymous — Thu, 17 Aug 2017 13:53:48 GMT

thank you sir its working

Re: passing value to trest

Anonymous — Thu, 17 Aug 2017 14:00:12 GMT

You talk about which solution ? Can you send screen shot of your test please with settings ? I'm pretty sure that my solution works, or I don't understand the purpose of your job ...

Re: passing value to trest

Anonymous — Thu, 17 Aug 2017 14:32:21 GMT

sir,

sorry the solution you gave is not working.

context.key=input_row.key;
after passing it into tJavaRow then talend is throwing error as
key cannot be resolved or is not a field.

could you please tell me any other way

Re: passing value to trest

Anonymous — Fri, 18 Aug 2017 09:56:13 GMT

can anyone please help me in this

Re: passing value to trest

Anonymous — Fri, 18 Aug 2017 13:19:30 GMT

Where are you blocking ?

I thought that your problem was solved.

Re: passing value to trest

Anonymous — Fri, 18 Aug 2017 13:34:49 GMT

sir ,

I want the output coming from tJavaflex or tjavarow and sending it to trest http header value.

I am not able to pass the variable to another trest component.

please help me in this

Re: passing value to trest

Anonymous — Fri, 18 Aug 2017 13:49:28 GMT

Please send a screenshot of Job and settings, and show us what element cause you trouble.
I don't understand where is the problem exactly, i need a visual explication.

Re: passing value to trest

Anonymous — Fri, 18 Aug 2017 14:18:25 GMT

sir,

my job is
tREST---------->tExtractJSONFields----------->tJavaRow------------->on component ok----------->tREST------------->tExtractJSONFields-------------->tfileoutputjson

so I have applied your logic in tJavaRow.
now this I have to pass this variable to second tREST component in http header value.
please look into this and give the solution

Re: passing value to trest

Anonymous — Fri, 18 Aug 2017 14:26:33 GMT

What did you write in your tJavaRow ?

Re: passing value to trest

Anonymous — Fri, 18 Aug 2017 14:44:14 GMT

sorry ,
not tJavaRow.
In tJavaflex,
globalMap.put("token", row2.token);

this I have written.
from this tJavaflex I have connected to tREST.
I want this value to be in http header value in tREST

Re: passing value to trest

Anonymous — Fri, 18 Aug 2017 14:50:22 GMT

in your http header value, you have to write : (String)globalMap.get("token")

If it doens't work as expected, show us the error message.

Re: passing value to trest

Anonymous — Mon, 21 Aug 2017 07:11:14 GMT

No sir. Its not working...

Re: passing value to trest

Anonymous — Mon, 21 Aug 2017 13:32:22 GMT

hi sgv,

thank you for your help.
I have passed globalMap.put("token", row2.token); in tJavaflex
---->main--->tFlowToIterate --> iterate--->tREST
In tREST I have written ((String)globalMap.get("row3.token")) in http header value (where I want this value I have posted)

regards,
harsitha