Forum Discussion
Linking authentication-needing files
PQ in Excel will use saved Internet Explorer (not Edge) cookies if you're using Web.Page to download the data. However, there's no way to script page clicks or other kinds of automation.
Ehren thanks but can you tell me please how to set up such connection?
Normally I go via IE to https://some.domain.com and I login via a form and then there is another form for authentication. At the end, I manage to authenticate and initiate a session.
Then, if I visit https://some.domain.com/donwload/943/ an xlsx will be downloaded.
How do I create a connection to such xlsx file?
I add a Get Data > From Web connection and insert the https://some.domain.com/donwload/943/
Then, it asks me for authentication type, which should I choose and at which level (i.e. domain.com or domain.com/donwload etc)?
Thanks!
Try using Anonymous auth for domain.com.
Ehren thanks, I did try it and it does not work. It downloads this and it shows the login webpage:
I can check the headers when I visit the domain.com/download/425 link, would that help?
Does the website maintain the login across sessions? In other words, if you login in IE and are able to download the xls files, and then close the browser, are you able to download the xls files without logging in the next time you open IE?