Forum Discussion

vladenache's avatar
vladenache
Regular Visitor
1 day ago

sftp file modified date

Hei  Having a hard time picking up the modified datetime of files from a sftp server. With a Get MEtadata activity, the Last Modified field actually is just the time when I run that activity - so t...
data engineering
data pipeline
nielsvdc's avatar
nielsvdc
Icon for Super User rankSuper User
1 day ago

Hi vladenache​, you should be able to solve with the following steps in the pipeline,

  1. Add Get Metadata activity on the folder and select field list Child items.
  2. Add a ForEach using @activity('Get Metadata1').output.childItems.
  3. Inside the foreach loop, add a second Get Metadata activity and use @item().name in the file path. In the field list select Item name and Last modified.

,