How to call google timezone API in Alteryx via Download tool?

[Svetlana_Baranova]

Hi team!

I'm trying to call google timezone API in Alteryx via Download tool, but it gives me "HTTP/1.1 400 Bad Request".

My workflow is super simple: 

 

 

Text input with url: 

Url is correct, when I place it in browser, it gives me correct response:

{
   "dstOffset" : 0,
   "rawOffset" : -28800,
   "status" : "OK",
   "timeZoneId" : "America/Los_Angeles",
   "timeZoneName" : "Pacific Standard Time"
}

Download tool settings are the following:

 

And output from browser:

 What did I do wrong? And how to make it work?

Thank you in advance for your help!

[gautiergodard · Accepted solution]

Hey @Svetlana_Baranova 

Try unchecking the encode URL option in the download tool. I see you have “%2C” in there which maps to a comma “,” prior to being encoded which make me feel like the URL you are trying to pass through has already been encoded. 

[Svetlana_Baranova]

It worked! thank you so much!