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 achieve this?
Once I get these excel files, I want these to be reference to txt files contained in BLOBs which will be referenced in rules in Sentinel.
Please help. I am very new to Azure Sentinel and Azure cloud.
Regards,
Mitesh Agrawal
6 Replies
- CliveWatson
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
