Forum Discussion
Need to download a zip file from a website and unzip it and call its content in Log Analytics worksp
Hi All, I want to download a zip file from an external website and unzip the file. The unzipped file contains 4 different excel which I want to read and write data to Sentinel. How can I ach...
CliveWatson
Microsoft
Microsoft
You can see examples in the [Azure-Sentinel] channel, posts like this https://techcommunity.microsoft.com/t5/azure-sentinel/mapping-ips-to-autonomous-systems-number-and-name/m-p/1204314#M1127 and the link contained within, explain the use of Externaldata for ingesting files from URLs or BLOB.
Thanks
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
- CliveWatson
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
