I want to grab xls files via specific links through a website that has a form authentication. Because it has an additional sms authentication step, it will not be possible to fully automate a live connection.
The session is set at 60 minutes so I am thinking if I ping/query the website every 30min, the cookie will renew/refresh.
However, this pinging will need to come from a 24/7 server and not my laptop as I cannot have it on all the time.
Is there any free solution for this?
I was thinking to create a Sharepoint Flow where it will download the xls every 30 min refreshing the cookie/auth/sessionID each time. I was hoping that I can somehow login manually for the first time via Sharepoint and then since the flow will be scheduled every 30, it will run forever refreshing the session.
Or do you have any other idea?
I was checking some of the free Azure services if they are suitable but no luck.