Pulling an excel report from a .aspx website

[Alayna]

My question is similar to this one: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reading-ASPX-file-from-URL-with-downlo...

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?

[AkimasaKajitani]

Hi @Alayna 

Does the web page that you are trying to access require a credential(ID and Password)?

If that, you set up the ID and Password or credential to Download tool.

[Alayna]

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!

[AkimasaKajitani]

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]

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