topic Rest call with curly braces in Talend Studio

Rest call with curly braces

Anonymous — Fri, 24 Aug 2018 10:16:36 GMT

Hi,
I'm calling the facebook API with tREST and when adding the time_range to the URL the job fails.
The call works fine when testing in postman but it seems that Talend has problem with the curly braces {}.

My URL is: "https://graph.facebook.com/v3.1/6063275471072/insights?fields=campaign_id,campaign_name,clicks,impressions,spend&fields=campaign_id,campaign_name,clicks,impressions,spend&time_range={since:'2018-08-21',until:'2018-08-21'}&access_token=***"

The Error is: Exception in component tREST_1
java.lang.IllegalArgumentException: Illegal character in query at index 124

I tried different brackets, context variables and backslash \{
but I can't make it work. Can anyone give me a hint ?

Re: Rest call with curly braces

Jesperrekuh — Fri, 24 Aug 2018 10:36:48 GMT

I prefer to use tSystem with a cUrl command...
However since and until should be within quotes as what the api is telling me.
'since':

Im not sure if the url is encoded into a safe url by the tREST component, check your call by using fiddler or similar software to find out / debug whats happening on a lower level.

Re: Rest call with curly braces

Anonymous — Fri, 24 Aug 2018 13:09:45 GMT

Thank you Dijke!
curl in tSystem was a good tip. I made it work there.

Re: Rest call with curly braces

Jesperrekuh — Fri, 24 Aug 2018 13:21:10 GMT

Make sure the cUrl is called like this:

search for tSystem and bash array or something to load it in the same bash environment ... below an example on how I do it:

new String[]{"bash","-c","curl -k -L -v -c "+((String)globalMap.get("cookiesFolder"))+"/cookie.txt  https://somefreakingurl/login -d 'login=login&username="+context.Usr+"&password="+context.Pwd+"'" }