topic Talend: How can I set global variable into tREST HTTP Body? in Talend Studio

Talend: How can I set global variable into tREST HTTP Body?

DScolari1623331702 — Fri, 15 Nov 2024 22:18:44 GMT

I am developing a new REST webservice for our application.

My goal is to pass instead of the fixed date, a date that I retrieve from a database ,

but as I report in the images below the parameter does not work correctly.

While if I pass the date as per the field below the job works correctly.

Would you know how to help me. Thank you

" {

"tokenKey": "ofsodfdsnsd frrfmoic",

"dbKey": "dd_ab",

"customerKey": "lp_ProdG100",

"from":"2022-11-01",

"period": "DAY",

"profile": 1

}

Re: Talend: How can I set global variable into tREST HTTP Body?

Anonymous — Thu, 01 Dec 2022 08:20:48 GMT

Hello @Davide Scolari ,

Regarding to your job snapshot, you can get the date value by globalMap.get("row93.oggi")

please reset it in the HTTP Body of tREST component to re-try?

Best regards

Aiming

Re: Talend: How can I set global variable into tREST HTTP Body?

DScolari1623331702 — Thu, 01 Dec 2022 08:39:49 GMT

Sorry, but I didn't quite understand.

I tried to rewrite the code in the following way:

\"from\":\" "+((Date)globalMap.get("row93.oggi"))+"\",

is correct, but no data is returned.

Re: Talend: How can I set global variable into tREST HTTP Body?

Anonymous — Thu, 01 Dec 2022 08:57:52 GMT

Another way is to setup a Customize key for the tFlowToIterate component in the job like the below

then rewrite the code in tREST body like

\"from\":\" "+globalMap.get("oggi")+"\",

Re: Talend: How can I set global variable into tREST HTTP Body?

DScolari1623331702 — Thu, 01 Dec 2022 09:15:30 GMT

Thank you, I think I have identified the error.

Instead of just returning me '2022-11-02' it gives me '2022-11-02 00:00:00' consequently it goes into error. I don't know how to force it

Re: Talend: How can I set global variable into tREST HTTP Body?

Anonymous — Thu, 01 Dec 2022 09:57:18 GMT

@Davide Scolari , in the tDBInput_2 component schema settings, please reset the column oggi Date Pattern to 'yyyy-MM-dd' like the below, then re-try the job?

Re: Talend: How can I set global variable into tREST HTTP Body?

DScolari1623331702 — Thu, 01 Dec 2022 10:08:44 GMT

Thank you, but I had already tried but it doesn't work

Re: Talend: How can I set global variable into tREST HTTP Body?

Anonymous — Thu, 01 Dec 2022 10:14:01 GMT

@Davide Scolari , you can substring the oggi value, in the tREST body , try the below

\"from\":\" "+globalMap.get("oggi").toString().substring(0, 10)+"\",

Re: Talend: How can I set global variable into tREST HTTP Body?

DScolari1623331702 — Thu, 01 Dec 2022 10:25:44 GMT

Thank you, but you expect a Date the Trest . I discovered this by running the job in Trace Debug

Re: Talend: How can I set global variable into tREST HTTP Body?

Anonymous — Thu, 01 Dec 2022 13:10:48 GMT

A date passed via a web service will either be passed as a String or a number. A Date in Java is essentially a number that when it is shown to users as a String, can be formatted in a number of different ways. If the error is caused by not receiving "2022-11-02", then your date is arguably expecting a String.

Re: Talend: How can I set global variable into tREST HTTP Body?

DScolari1623331702 — Thu, 01 Dec 2022 14:01:35 GMT

Thank you very much, but I don't know what to do anymore.

I will bring back the job as per your suggestion

This is the job in which I hand them the date manually

Re: Talend: How can I set global variable into tREST HTTP Body?

Anonymous — Thu, 01 Dec 2022 14:51:45 GMT

You appear to have a space between your globalMap containing the date and your opening double quote ("). You have...

\"from\":\" "+((String)globalMap.get("oggi"))+"\",

....and I think you need....

\"from\":\""+((String)globalMap.get("oggi"))+"\",

A tiny change, but it would end up producing your date like this....

" 2020-11-01"

...instead of this....

"2020-11-01"

Re: Talend: How can I set global variable into tREST HTTP Body?

DScolari1623331702 — Thu, 01 Dec 2022 16:16:18 GMT

You are right, stupid mistake! I thank you, I was going crazy. It works perferctly

Re: Talend: How can I set global variable into tREST HTTP Body?

Anonymous — Thu, 01 Dec 2022 17:15:22 GMT

It's easy to overlook an empty space. I've wasted days on stuff like this before 😉