bakshi laal
New Member
Members
Forum Posts: 2
Member Since:
October 25, 2021
October 25, 2021
Offline
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. |
Philip Treacy
Admin
Forum Posts: 1586
Member Since:
October 5, 2010
October 5, 2010
Offline
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
Alan Sidman
Steamboat Springs, CO
Member
Members
Trusted Members
Trusted Members
Forum Posts: 193
Member Since:
October 18, 2018
October 18, 2018
Offline
crossposted: https://chandoo.org/forum/thre.....ost-279855
Please read: https://www.excelguru.ca/content.php?184
The following users say thank you to Alan Sidman for this useful post:
Philip TreacyForum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Andrea Fernandez-Trujillo, Lisa Matthews
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Stephen Keating
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30159
Member Stats:
Guest Posters: 49
Members: 33707
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —