Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Download Data Tool - Error Transferring Data: Failure When Receiving Data from the Peer

CharltonFranklin
8 - Asteroid

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:

CharltonFranklin_2-1657153565634.png

Here's my workflow:

CharltonFranklin_0-1657153347157.png

CharltonFranklin_8-1657153929573.png

 

I left Headers, Payload and Connection at defaults:

Headers- Nothing selected

Payload = Get, no fields selected

Connection credentials are left blank

CharltonFranklin_3-1657153614870.png

 

I tried enabling proxy credentials, but that made no difference:

Options > User Settings > Advanced > Proxy Settings

 

CharltonFranklin_7-1657153776143.png

5 REPLIES 5
apathetichell
19 - Altair

This works fine for me. Text input/download tool - get mode of download tool.

grazitti_sapna
17 - Castor

Hi @CharltonFranklin, give this workflow a try.

grazitti_sapna_0-1657170816122.png

 

This workflow just fetches the data in the raw form you can apply the transformations as per the requirement.

 

I hope this helps!

 

Thanks!

Sapna Gupta
CharltonFranklin
8 - Asteroid

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...

 

 

grazitti_sapna
17 - Castor

Hi @CharltonFranklin,  the macro that you shared seems to work fine for me.

 

grazitti_sapna_0-1657252247562.png

 

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! 

Sapna Gupta
CharltonFranklin
8 - Asteroid

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.

Labels