How to fetch latest file from the file path in data sources

[Priyanka145]

Hi, I have created a scheduled import to run the transform map via data source. How to fetch the dynamically based on latest updated file from the file path in SFTP folder in data source. If the file path is having multiple files, it has to pick the latest added/updated file. Please guide me how to achieve it

[Ankur Bawiskar]

@Priyanka145 

unfortunately you cannot achieve this using any OOB logic/configuration.

You need to determine just before your scheduled import in that SFTP file path which one is the latest and update the file path accordingly.

1) run scheduled job 30mins before your scheduled import and determine which file is latest and update the data source file path

2) when scheduled import runs it will fetch the file

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Priyanka145]

Hi @Ankur Bawiskar 

Could you please guide me with the steps for scheduled job how to determine latest file

[Ankur Bawiskar]

@Priyanka145 

will the complete file name change or just the date in file name will change?

based on that you can define the logic

check this

https://www.servicenow.com/community/developer-forum/retrieve-sftp-data/m-p/1631355/page/2 

[Priyanka145]

Hi @Ankur Bawiskar  , File name wont change, date in the file name changes.