Trigger Azure Function which update the status of a record on blob containers file deletion

Question

Use Case : We have a blob container contains CSV files which gets deletes on 24 hours from the creation. On delete event of file would like to call a azure blob trigger function to update the status of respective file row in SQL DB to expired/deleted.

Question: is it possible to achieve this scenario using Azure blob trigger function? if yes i appreciate the reference documents/ your inputs thank you.

Solutions already tried:

https://medium.com/@kvanshika94/connecting-to-azure-blob-storage-using-azure-functions-python-4fefa1adf66b

i need to receive the container and file details as a out parameters to pass as input params of the blob trigger function.

Thank you!

Answer 1

I created event grid trigger in my environment and got expected results given below. the way to create event grid trigger function is to create it using Azure portal. Firstly, created a python Event grid trigger function as below

Then I created an event subscription.

Using blog trigger function created an event subscription. and then we select an endpoint. Any further reference link.