Extracting .zip files from HTTP response

[ericonline]

Hello,

I'm having trouble with this scenario:

1. HTTP request to a URL provides a .zip file
   1. The response looks like this:

   2. {
          "statusCode": 200,
          "headers": {
              "version": "2018-03-28",
              "creation-time": "Tue, 23 Jul 2019 15:55:25 GMT",
              "Content-Length": "358346",
              "Content-Type": "application/x-zip-compressed",
              "Last-Modified": "Tue, 23 Jul 2019 15:55:49 GMT"
          },
          "body": {
              "$content-type": "application/x-zip-compressed",
              "$content": "big long string"
          }
      }

2. I want to extract this .zip file to OneDrive

The goal was to parse the JSON response for the $content, then pass it to OneDrive for business. I receive the following error when trying to parse JSON. 

Any ideas on how to get at the .zip content?

Thank you

[RezaDorrani]

Hi @ericonline 

expressions to the rescue !!!

body('HTTP')?['body']?['$content']

will give you 

"big long string"

If you need the content type use

 body('HTTP')?['body']?['$content-type']

Regards,

Reza Dorrani

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

[ericonline]

Hi @RezaDorrani !

Thank you. I'm able to select the $content value, but how to get it into a valid .zip file? It appears as 0kb.

I tried wrapping body('HTTP')?['body'}?['$content'] in dataUriToBinary() and uriComponentToBinary(). No go.

Confirmed that when the URL is put into the browser, a 350kb .zip file is immediately downloaded.

[RezaDorrani]

Hi @ericonline 

The data you are getting seems to be simple text

Do you want to create a zip file and include the text file in it

Which action are you using to create the file?

[ericonline]

RE: The data you are getting seems to be simple text:

• The data is a .zip file (folder with multiple files within)

RE: Do you want to create a zip file and include the text file in it

• Yes. I want the .zip file in the response to be placed in OneDrive for Business'

RE: Which action are you using to create the file?

• OneDrive for Business Create File Action
• 

[RezaDorrani]

Hi @ericonline 

try

body('HTTP')?['body']

[ericonline · Accepted solution]

Hi @RezaDorrani ,

Even simpler! Ended up being body(['HTTP']) in the OneDrive for Business File Content field!

[RezaDorrani]

@ericonline 

Glad it worked out

[Prakash05]

I have the similar requirements, a folder with multiple files within and I need to create a Zip folder using power Automate flow. Can You Share all the actions for refernce

[BogdanKochesch]

I am running into the same problem myself, however, your expression body(['HTTP']) is not a valid expression due to the square brackets within the regular brackets.... How did you solve this in fact? I tried all kind of expressions to no avail.