Generate a static link to dynamic files in the ADLSGen2?

Andrew Fogarty 6 Microsoft Employee

I have a requirement to output daily excel files to my ADLSGen2 (e.g., filename_24_June_2021, filename_25_June_2021).

Is there a way to create a SAS download link, or equivalent, which will not change -- meaning that it will always pull the newest file located in the folder? I would like to automate the process and not be forced to generate download links and update website URLs on a daily basis.

MartinJaffer-MSFT 26,061 Reputation points

2021-06-28T03:45:37.16+00:00

Hello @Andrew Fogarty and welcome to Microsoft Q&A.

I do not think it is possible from a SAS point of view, but I do have some ideas for automating the process.

Event grid can be set up to trigger whenever a new file is created. This can then feed into the link update mechanism.

Web services is not my area of expertise, so there is likely better options than what I suggest below.

We could set up the static link to a fixed location. Then whenever Event Grid triggers, copy the new file into the fixed location. Adjust the cache instructions in your link so end-user does not keep cache more than a day.
Andrew Fogarty 6 Reputation points Microsoft Employee

2021-06-28T12:44:54.083+00:00

Thanks, I think I did something similar. Right now it is with Logic App where it sends the data to OneDrive.
MartinJaffer-MSFT 26,061 Reputation points

2021-06-28T16:29:25.497+00:00

Thank you for sharing your solution and status. Have a good week!

Share via

Generate a static link to dynamic files in the ADLSGen2?