Given that you have a blob storage container with multiple files, you could download the most latest one easily with az cli
In my scenario I have a container named backups which includes multiple MS SQL backups. I wanted to download the latest in order to restore through a pipeline on SQL server.
In order to accomplish that you should first login with az cli.
If this is not possible through automation you would have to create a managed identity for your resource. The code is uploaded on the below gist.
You should replace your connection string by getting yours under access keys.
If you remove descending date the default value would be Ascending.
By executing the script you will get a json output like the below: