I have a container with a blob called Weekly. Each week a new subfolder is added to the weekly blob and each each day a new csv file is added to the respective week subfolder. I am trying to use schedule trigger every sunday. Once the pipeline is triggered I need to get the latest week subfolder in the blob. I am thinking of following solutions.
I have around 200 week subfolder. Using get metadata activity and for each loop and comparing it with latest modified date is taking too much time. Instead I am trying use get metadata activity and get the last child item and assign it to a variable called folderpath. How to do this?
Using python functions how to get the latest subfolder in a blob?
Any help would be highly appreciated.
Thanks in advance