Webscraping ASPX page: high difficulty

[AndreLuiz]

Hello community,

I was trying to use Power Query/Get and Transform to connect to an ASPX webpage and import from it the excel file given as output after fill in some forms.

After some searching, the only tutorial I found was from Huang Caiguang in his blog post (https://pqfans.com/207.html).
The problem seems to be the parameters as __EVENTTARGET, __VIEWSTATE, among others that are sent to the website containing the information about the forms.
Obs: There is no API available from this website.

Has anyone also tried to do something similar and that could share the solution/approach?

Thanks in advance!

[AndreLuiz]

Hello Matt,
Looking more carefully, it seems that what is needed is a custom connector, because there is a need to first log in the website, fill in some forms which loads another page with more forms, etc, until the excel folder is gives as output.
I think that the case in which no login is needed might be solved with the resource you indicated.

[v-yuta-msft · Accepted solution]

@AndreLuiz ,

If web.page() function doesn't work, I would suggest you to use python script instead. 

Reference:

https://docs.microsoft.com/en-us/power-bi/desktop-python-scripts

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattAllington]

Have you tried webpage by example?

---