Forum Discussion
Linking authentication-needing files
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?
Ehren indeed the website does not maintain the login session if I close the browser
What can be done in this situation?
I can keep IE/Edge open after I login manually, if needed!
Hi Anonymous ,
Did you try to click edit or transform at the right bottom corner of the pic showed below:
When you go into query editor,you could expand the tables to get the contents.
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
