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

[DScolari1623331702]

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

}

"

[DScolari1623331702]

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

 

[Anonymous · Accepted solution]

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"

[DScolari1623331702]

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

[Anonymous]

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