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!