Download tool works in Designer Desktop but Unable to Connect to API on Server

[brennen5246]

Hello all,

First post in the community, so please let me know if I've missed any details or if you have any questions.

I've a workflow that reads in data from our db looking for new addresses. In a separate workflow, I am taking that information and converting it into a JSON array (along with doing some other basic cleansing) and feeding it into the Download tool to format via Geocodio's API in order to return correctly formatted addresses with lat/long. I am then kicking off a third workflow to validate the data and to upload this data back into our db. 

When I run each of these manually within Designer Desktop, I run into no issues, however, upon publishing to server and placing them on schedules, the second workflow (with the download tool) errors out when it is ran giving error message:

"Error transferring data "https://api.geocod.io/v1.7/geocode?api_key=XXXXXXXXXXXXXXXXX: Couldn't connect to server"

I've attached screenshots of my workflow/download tool configuration with sensitive data removed for additional information.

Does anyone have any idea what might be going wrong here? I suspect that there is something within server that needs to be configured, but I am unsure what that could be at this point.

Thanks in advance!

[fmvizcaino · Accepted solution]

Hi @brennen5246 ,

Some companies have servers with no access to the internet or your IT department has a firewall blocking this URL, which would explain this issue.

There are no configurations in the Alteryx Server that can block the workflow from running so it will be something related to the network.

Best,

Fernando Vizcaino

[brennen5246]

This was the issue, I reached out to our IT/Networking team and was able to get a rule added to our firewall to allow the API through. Thank you!!!