Forum Discussion
Need to download a zip file from a website and unzip it and call its content in Log Analytics worksp
Hi Clive,
The link is quite helpful. Actually I want to automate the task which I have mentioned.
The zip file should be downloaded everyday and it should be unzipped. Later I can call the csvs using externaldata and create rules. But how to achieve the first thing.
Regards,
Mitesh Agrawal
Microsoft
I'd start looking at a Logic App - which has a schedule (recurrence option) to allow you to schedule and then move the file to blob https://social.msdn.microsoft.com/Forums/en-US/5643f6de-0c2b-4697-9b72-8307a6447db6/download-payload-of-file-at-http-connector-to-blob-storage?forum=azurelogicapps Note: I've not tried this.
Its the unzip operation I'm not sure about...
Thanks Clive
Hi CliveWatson,
I am exploring the option for Logic App. Used "Recurrence", "HTTP" and Azure Blob storage connectors and created a blob with the zip file.
Thanks a lot for the link. It helped a lot.
Now, I am looking for an option to unzip this zip file and create 4 more blobs from those 4 excel sheets in the zip file.
If you get to know anything then please update here. Also, if you have any other idea on achieving this then please tell me.
Regards,
Mitesh Agrawal
Hi CliveWatson ,
I got the below error when I tried to unzip the file.
```
{"status": 413,"message": "The file contains 50.5 megabytes which exceeds the maximum 50 megabytes.\r\nclientRequestId: abcd","error": {"message": "The file contains 50.5 megabytes which exceeds the maximum 50 megabytes."},"source": "azureblob-ci.azconn-ci.p.azurewebsites.net"```How can I increase this limit?By the way I got an option under Logic App connector - "Extract Archive to Folder" in order to unzip the .zip file.Regards,Mitesh Agrawal- CliveWatson
I believe that is a hard limit. Other options (from a quick search, so there maybe other ways) seem to be to use a Azure Function http://www.frankysnotes.com/2019/02/how-to-unzip-automatically-your-files.html