Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Get data from a password protected website

I'm struggling to find a simple way to get data from a password protected website (It doesn't have an API or anything like that!).

I already tried Power Automate Desktop, using Desktop Recorder but it's both annoying and inefficient to use that, since I wanna the process running in the background.

(I didn't find a way of doing that using the web version of Power Automate!)

All I have to do is to access the website (using my username and password), and load a second URL which directly downloads a .xlsx file to my computer (I also would like to move the file from Downloads folder to an specific folder or even download directly to the SharePoint).

The generic URL below has the same format the original URL, without any kind of file extensions (i.e. .xlsx, etc.). I have no idea on how that URL actually works, I just know that when the URL is loaded a .xlsx file is downloaded.

https://generic_url.com/generateexcel

Does anyone have a guess on what is the best approach to do that?

Thank you!!

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • NimaiAhluwalia's avatar
    NimaiAhluwalia
    Continued Contributor
    4 years ago

    Hello @gasilva8 

     

    I worked on a similar use case like this if I got you right this can be the solution for you.

     

    My use case - I had to download the excel data from a password-protected website and then use that excel in the power bi, as this was a manual task of downloading the excel every time and updating the excel.

     

    solution  - with the help of power automate ( selenium ) - I recorded the whole process of logging in to the website and downloading the excel, but I did the whole process in a VM as scheduled to work as per the excel and power automate extraction time, and using FTP I transferred the file to the blob storage on azure and connected my power bi report.

     

    Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Did you try the web connector?

    Also I found this idea, maybe you need to vote for it: Microsoft Idea .

     

    Best Regards,

    Stephen Tao

     

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

     

  • SickStigma's avatar
    SickStigma
    Frequent Visitor
    2 years ago

    I can't find this panel;

     

    All I get is:

    What am I doing wrong?

    Sick