Need to download only one file from s3

Question

I have a process where I need to retrieve the most recent file from an s3 bucket and use it to target specific customers in a recurring delivery. However, files are written to this bucket multiple times in a day and are saved for 14 days. Campaign only has read access to this bucket, so I can't archive the delete the files.

When I run the workflow, I load not only the newest file, but the others as well, which causes multiple deliveries to be triggered.

The file transfer is set to download and the server folder is configured like this:

How can I load only one file or how can I filter out the other files in the workflow so multiple files dont trigger multiple deliveries?

Manoj_Kumar · Accepted Answer

Hello @gkbowe

Are you facing any issues with your current configuration? I think you are on the right path to get the latest file.

Here are the steps that I would follow:

1. list the file

2. extract the timestamp from file name

3. check which timestamp is latest

4. pick the file with latest timestamp

5. pass the filename to get file from s3 activity

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded