Pulling an excel report from a .aspx website

Question

My question is similar to this one: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reading-ASPX-file-from-URL-with-download-tool-quot-HTTP-1-1-400/td-p/583225

My website is slightly different. This webpage takes you to a table of data that can export to an Excel. I tried using the text input with the download tool and it leads to an "Unauthorized" error. I tried using my login credentials in the download tool connection block and it still didn't work. Any other ideas?

Alayna · Answer

Still didn't work. The thing is, I don't need to login to the website. I guess it automatically detects I'm on a VPN and will immediately pull it up, and lead to a page error if I'm not on a VPN. I'll try to look more into it and maybe ask my IT for any suggestions. Thank you

AkimasaKajitani · Answer

According to the download header, the error is "HTTP/1.1 401 Unauthorized". So you couldn't login by Download tool.
The way of login type is different at web sites, firstly you can try to set the ID and password at Download tool.

If this way is not work, you have to check the login way.

Alayna · Answer

Hi Akimasa, I tried to login and it's giving me the same error. I'll note that I have to be on my company's VPN in order to access the file. Are there any settings that should be changed for the download tool? Thanks!