Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
37
Views
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
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
crossposted: https://chandoo.org/forum/threads/excel-web-query-datasource-error-404-not-found.47081/#post-279855
Please read: https://www.excelguru.ca/content.php?184
Posted : 28/10/2021 4:24 pm