Forum

Web Query with the ...
 
Notifications
Clear all

Web Query with the credentials , Error saying (404) Not found

3 Posts
3 Users
0 Reactions
234 Views
(@bklaalyahoo-co-in)
Posts: 1
New Member
Topic starter
 
1) I want to get the data into the web query from  url https://www.screener.in/screens/7780/all-stock/
2) This screen can be accessed with user is logged in 
3) but when user is not logged in this screen cannot be accessed
4) I want to retrieve this data into the excel.
5) Added the following code in Advance Editor and authentication type as basic 
7) Following error is thrown, attached in the xls
8) Any help in this regards is highly appreciated.
 
Posted : 26/10/2021 5:02 am
Philip Treacy
(@philipt)
Posts: 1630
Member Admin
 

Hi Bakshi,

Unfortunately Power Query doesn't have a way to login to websites that require a form to be completed via the web browser interface.  If this website had an API that you could use then you could login that way, but the site doesn't appear to provide an API.

An alternative is to use something like Selenium and VBA to interact with the website, login and get the data you want.

Web scraping - filling in forms

Regards

Phil

 
Posted : 27/10/2021 7:16 pm
Alan Sidman
(@alansidman)
Posts: 223
Member Moderator
Share: