HTTP get download file

[Ozcar]

Hi

I have a service that provides an API where I can download files with at HTTP GET command and basic auth. It works fine when Im testing the API with Postman but I cant find out how to download that file with Flow and for example put it in my onedrive. Anybody that could help me out a bit?

Regards,

Ozcar Ardfors

[v-micsh-msft]

Hi @Ozcar,

Please check the following blog:

Five new services and improved advnaced capabilities for JSON and HTTP

In your scenario, I think HTTP action and the Parse JSON should be suitable to work.

Regards,

Michael

[Ozcar]

Hi

Thank you for showing me that! It was super cool to parse JSON respones. But unfortunally I dont know how to write a schema that will take care of a binary gzip file. Any idea?

Regards,

Ozcar Ardfors

[ashwinsa · Accepted solution]

If the file is a binary and you are looking for a way to simply transfer files between the HTTP endpoint and any storage service, you can add a HTTP to download the file and save the content using the "Create File". Here is an example of a flow

[Ozcar]

Yes it works! Sometimes the solution is so so easy. Thank you very much.

Regards,

Ozcar Ardfors

[Alerodri]

Hello Ozcar

kann you post screenshots of the solution you used?

Does your link links direct to the file or is a Callback or Server Response?

It seems that with JSON can be done but I also don´t know how to do it exactly.

I would strongly apreciate your help!

Cheers

Alex

[Ozcar]

Hi

Its very simple. Works exactly as described above. Do an HTTP GET and create the file with the body response. Not sure what is unclear with the solution.

[Alerodri]

Thank you for your feedback Ozcar. The problem with this settings is that the URL is a redireccion, and I get a 302 error. These are the details.

Do you have any ideas to manage this URLs?

Thanks in advance.

 

[Ozcar]

No it seems to be a problem with response from the service you are trying to use. I dont have a direct solution for you but I recommend to use Postman first before attempting to get it to work in Flow.

https://www.getpostman.com/

[Alerodri]

Hello Ozcar, 

It just workt parsing the JSON. Thank you very much anyway.  This is how I did it. 

[dav_formica]

Is this working still? I'm trying the same exact thing but I don't get the "Body" variable containting the csv data from the HTTP GET.  Usually, when available it shows as Dynamic content but it's not there.   I typed it it to no avail.

[Ozcar]

Its working fine for me.

//Ozcar

[Anonymous]

@Alerodri can you include a screenshot of you entire parse JSON schema?

[Anonymous]

I am doing the same thing and have the Flow working perfectly. The Create File has the contents of the file, etc.
BUT, I can't figure out how to force the PowerApp to display or download the file.
First, I added a "Respond to PowerApp" with the "TheFile" from the "Create File" and I can reference "TheFile" in the PowerApp - BUT - the Download() function expects a URL.
So, how to a force the PowerApp to show and/or download the file to the user?

[tphill]

What URL would you enter in Power Automate since the link will vary with every email? For example, https://api.realwebsite.com/files/abcdefg/[variableparthere]

[scorpio24]

@Ozcar @tphill @dav_formica @Alerodri HTTP is a premium function, right?