#59. Azure Data Factory - Get Last Modified Date of all Files in a Folder

In ADF, using get metadata activity, we can know about the meta data of a file\folder or a DB table. In this video, we discuss how to use the get meta data activity to know the last modified date of files in folder in BLOB path.

[ViralBiharUpdates]

Thank you so much for making this video it's really helpful ❤ keep it up 🥰

[dvadana]

Nice video..Can we get latest last modified from folder..instead of getting for all old blobs?

[jb-idgs]

How would you save the date next to each filename? Do you have any tips on how to save these values as a csv file in datalake? :)

[hou]

Is there a way to add 'last modified' as a column in the file you are ingesting?

[nawazmohammad]

How to get latest folder and folder structure is in yyyy mm dd format have to pick the latest folder

[ANILKumar-ebpq]

how to copy the last modified file alone into target folder from source FTP ..

[Bloody_August]

maam what if the source is excel files and has two sheets? what are the settings? please?

[sravanthiyethapu]

How to copy last 30 days files from data lake folder ?? Pls rly??

[amruthamu]

I have tried the same: But getting the below error:

Field 'lastModified' failed with error: 'Type=Microsoft.WindowsAzure.Storage.StorageException, Message=The remote server returned an error: (404) Not Time:Wed, 01 Jun 2022 15:09:50 GMT, , ''Type=System.Net.WebException, Message=The remote server returned an error: (404) Not Found., Source=System, '.

Can you please help me to sort it out?

[aparnaappu]

just a small comment here .we can quickly implement the same requirement using a single get metadata activity .The only change required is we need to add Childitem and also last modified .this will get the filename type and also the last modified date of each file without having to go for a foreach loop here