[SalesForce] Can we delete file from SFTP Import folder after import activity

Can we delete file from SFTP Import folder after import activity?

I have an automation that picks up the file based on name. The file is uploaded frequently on SFTP import folder and I have noticed an issue.

When we upload a new file, old file is read by the automation / import activity because file name is in same format except date.

How to resolve this issue?

Best Answer

There is a custom Data Extract activity type available called "Delete File From ET FTP or Safehouse", and that will allow you delete a file from the FTP site. However, it will only allow you to delete files from Safehouse or the Import or Export folders; no other File Locations.

Related Solutions

[SalesForce] Automation studio SFTP file drop trigger to Import Activity

So the way I solve file conflict scenarios if I have no control over the file naming patterns is:

Create 2 File Locations pointing to 2 seperate folders in your FTP:

File Locations:

import/ftp_file_drop_1/file.csv
import/ftp_file_drop_2/file.csv

Setup 2 seperate File Triggered Automations, each automation pointing to 1 of the file locations.

This prevents conflicts with same file naming patterns.

If you have control over the file naming pattern, then @Data_Kid's Answer with time wild cards appended to the file name will solve your problem and then you can just use a Substitution String %%FILENAME_FROM_TRIGGER%% to pick up the latest file name dropped on FTP as each file drop will contain a different timestamp.

Hope this helps.

Best Answer

Related Solutions

[SalesForce] Automation studio SFTP file drop trigger to Import Activity

Related Topic