My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Web Query with the credentials , Error saying (404) Not found|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Web Query with the credentials , Error saying (404) Not found|Power Query|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Web Query with the credentials , Error saying (404) Not found
Avatar
bakshi laal

New Member
Members
Level 0
Forum Posts: 2
Member Since:
October 25, 2021
sp_UserOfflineSmall Offline
1
October 25, 2021 - 7:02 pm
sp_Permalink sp_Print
1) I want to get the data into the web query from  url https://www.screener.in/screen.....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.
Avatar
Philip Treacy
Admin
Level 10
Forum Posts: 1614
Member Since:
October 5, 2010
sp_UserOfflineSmall Offline
2
October 27, 2021 - 9:16 am
sp_Permalink sp_Print

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

Avatar
Alan Sidman
Steamboat Springs, CO
Member
Members


Trusted Members
Level 0
Forum Posts: 205
Member Since:
October 18, 2018
sp_UserOfflineSmall Offline
3
October 28, 2021 - 6:24 am
sp_Permalink sp_Print

The following users say thank you to Alan Sidman for this useful post:

Philip Treacy
sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 929
Purfleet: 415
Hans Hallebeek: 354
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
EXerOrqW PRqmMlMeyNd
EZKeMKxZBN iWcVrtJiiOmoVRc
Pamela Malthouse
Lila Huron-Albinger
Harry Maxwell
Jie Liu
Susan Lanham
Dhanushka Rathnayake
Rena Towles
Wim Verhaege
Forum Stats:
Groups: 3
Forums: 25
Topics: 7093
Posts: 31099

 

Member Stats:
Guest Posters: 49
Members: 34528
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen