question

AndrewFogarty-1127 avatar image
0 Votes"
AndrewFogarty-1127 asked MartinJaffer-MSFT commented

Generate a static link to dynamic files in the ADLSGen2?

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.

azure-data-lake-storage
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @AndrewFogarty-1127 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.

0 Votes 0 ·

Thanks, I think I did something similar. Right now it is with Logic App where it sends the data to OneDrive.

0 Votes 0 ·

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

0 Votes 0 ·

0 Answers