Forum Discussion

Anonymous

Not applicable

4 years ago

Linking authentication-needing files

Hello! I have a domain/website that needs a form authentication. After I authenticate, I can click on some links which will download some xls files. I want to put these links into a Data Conn...

Microsoft Employee

4 years ago

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.

Anonymous
Not applicable
4 years ago
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!
- Ehren
  Microsoft Employee
  4 years ago
  Try using Anonymous auth for domain.com.
  - Anonymous
    Not applicable
    4 years ago
    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?