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

Question

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!

GoogleAPI_test.yxmd

gautiergodard · Accepted Answer

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.