Pulling data from a password protected website.

Hi

I read a previous post with this problem

I am trying to set up a formula that will pull data from a password-protected website but using the suggested methods isn't working. I can't seem to get the "Access web content " window to open; I enter the URL and it just opens without giving me the option of selecting "Basic" so I can enter my username and password.Is there any way to force the "Access web content" window to open?

A "forum expert" replied :


I assume you are using Get & Transform, from web. It should always take to Access Web content dialog window.
There you should have Anonymous, Windows, Basic, Web API etc.

If you don't get that. Connect to base URL (i.e. login page). Then edit source in the query editor to the URL you need. And then, go to Data source settings in the query editor and hit Edit Permissions..
There you will find Credentials section. Hit Edit. It should bring up Access Web contend dialog.

Unfortunately I'm not allowed the post the link


I'd like to follow the same procedure but I'm getting lost in the process.

For example using this web page

I hit F12 to access the source page then I have some icons on the bar on the right - one of which is called Sources.

Is this right so far ? Perhaps someone could show me slowly how to get to credentials so that I can access my full log on details so that I can learn how to connect another protected web page to excel.

Thank you

Yes I know what my username and password is.

I'm trying to connect it to an excel spreadsheet.

Maybe I've misunderstood the original post.

I'm trying to connect a web page where I need to log into with username and password (which I have) to an excel spreadsheet.

Originally Posted by AliGW

In Excel, go to the Data ribbon > From Web > paste the URL into the box and hit OK > select Basic on the left (in the green panel) > enter your credentials.

I have no Basic option on the left nor Green Panel


I type the url into the 'From Web' box.

It Connects

I see the 'Navigator' Page where I see the displayed text

Desktop app

I get that box from the Amazon url but not from the site I'm trying to access

https://sorareinside.com/

I'd be surprised if they've disallowed access like this

(Thanks for your help)

How strange!

Have you any suggestions? Are there cookies or something I could clear ?

To ensure that the ability to enter your credentials is available :

Data > Get Data > Data Source Settings > Global Permissions

And delete the relevant url from the list

After a week of trying I've reached the end of the road for this. I've learnt plenty but getting the url to connect to excel has proved beyond me.
The website / url is a niche hobby and my password hides no personal data but I can't really post my password here

Thank you. Message sent