Get file from a website using HTTP connector

[gasilva8]

I'm trying to download a file from a password protected website.

My flow uses a HTTP connector to access the site, but I can't find a way to download the file, which have a direct URL to be accessed/downloaded.

Instead of downloading the .xlsx file from the URL, the flow is downloading the webpage body content.

I appreciate any help!

[ChristianAbata]

hi @gasilva8 you need first file name with extension and content. If your HTTP request gives you those you cna use parse json to get the properties from HTTP > You can find how to use parse Json here https://www.youtube.com/watch?v=eSwdxAJQmJU&t=853s

[gasilva8]

Hi @ChristianAbata,

Actually the HTTP request returns the HTML code from the website (logon page), using the (generic) URL bellow:

https://website.com/auth/login?redirectUrl=/generatefile/file.xlsx

I don't know what to do to get the file content instead of the HTML code. Is there any trick?