Version: 2021.3.2.54175
I have a simple workflow that I wanted to develop into an iterative macro. I can't get past the most basic step of the download tool. I pass a URL with a public non-credentialed API into the tool. I can enter that URL successfully in Edge browser. What am I missing?
Here's a sample URL:
https://www.routingnumbers.info/api/data.json?rn=122235821
https://www.routingnumbers.info/api/data.json?rn=[routing number]
The goal is to have any routing number fed in and have details about that routing number spit out. I was uncertain whether I would use JSON parse or the regular parse tool, but that's beside the point if I can't download the data. If I plug the URL in Edge browser, this is what I get:
Here's my workflow:
I left Headers, Payload and Connection at defaults:
Headers- Nothing selected
Payload = Get, no fields selected
Connection credentials are left blank
I tried enabling proxy credentials, but that made no difference:
Options > User Settings > Advanced > Proxy Settings
This works fine for me. Text input/download tool - get mode of download tool.
Hi @CharltonFranklin, give this workflow a try.
This workflow just fetches the data in the raw form you can apply the transformations as per the requirement.
I hope this helps!
Thanks!
Thanks @grazitti_sapna . Your macro works, but mine doesn't. Our settings are identical. I checked everything I think, but can't figure it out.
For the sake of someone else that comes after us, do you have any idea why yours works and mine doesn't? (I'm attaching the file.) I even recreated the macro to see if it was a glitch, but I got the same error. I did notice that you have a newer version of Designer when I opened the file. I'm using Alteryx Designer 2021.3.2.54175.
I realized that if I remove "https://www." in my version, it works. I also noticed that if I change "https" to "http", in my version, it works. But yours works with the defined API as-is starting with "https".
With https, the header says
HTTP/1.1 200 OK
Date: Thu, 07 Jul 2022 18:18:25 GMT
Content-Type: application/json
Transfer-Encoding: chunked
Connection: keep-alive
Access-Control-Allow-Origin: *
Via: 1.1 vegur
CF-Cache-Status: DYNAMIC
Expect-CT: max-age=604800, report-uri="ht...
With http the header says
HTTP/1.1 301 Moved Permanently
Date: Thu, 07 Jul 2022 18:19:41 GMT
Transfer-Encoding: chunked
Connection: keep-alive
Cache-Control: max-age=3600
Expires: Thu, 07 Jul 2022 19:19:41 GMT
Location: https://www.routingnumbers.info/api/data.json?rn=1222...
Hi @CharltonFranklin, the macro that you shared seems to work fine for me.
Maybe it is some kind of version issue or updates that have been made to the newer version of Alteryx Designer as this is something new for me as well.
In case you want to deep dive into this scenario, I would suggest you reach out to Alteryx Support at support@alteryx.com or maybe @AlteryxProducts can help you through.
Thanks!
I think the issue may have to do with something local, a network setting, firewall, port forwarding or something. I'm not strong with networking, so I don't know how to figure it out.