[SalesForce] SSJS to delete files on enhanced FTP

Extracts are for getting data out of the Marketing Cloud. What you would need to set up is an Import Activity, and a Custom File Location.

Creating File Locations

1. Go to the Email Application
2. Click the Admin tab on the navigation bar.
3. Under the Data Management tab, click File Locations. The File Locations workspace appears.
4. Click Create from the toolbar.
5. Select Location Type as "External FTP Site"

You don't need to set up the transfer that this page is detailing. Just set up the location, and your import activity will grab the file from where you uploaded it.

Note: You cannot use subfolders in the file location. The FTP username must be chrooted to the specific folder you will upload the file to. If you need subfolders, you would need additional FTP users, and File Locations set up in the Marketing Cloud.

Creating Import Activites

1. Go to the Email Application
2. Go to Interactions -> Import
3. Click Create from the toolbar.
4. Use your custom file location from previous step

Once these items are set up, you can then run your imports adhoc, or set up as part of an automation.

We're looking at deletion as part of controlling sensitive data on the SFTP. Do you have access to a safehouse as a file transfer solution? If not, you may need to create one (thanks Eliot Harper for the writeup)

If so, you can add a step to the end of your import automation workflow to move to the Safehouse. Files within a safehouse have a 21 day retention policy applied to them.

TL;DR: Move the files to a safehouse where they'll be deleted after 21 days.

Details on safehouses: https://help.salesforce.com/articleView?id=mc_overview_file_locations.htm&type=5

Creating a Safehouse:

The Safehouse file location is not created by default. If you do not have this in Email app > Admin > Data Management > File Locations, create one named 'Safehouse' and set the Location Type to 'Safehouse'.

SFMC Safehouse Retention Policy

Creating a safehouse location allows you to import decrypted files into the Salesforce Marketing Cloud without them being exposed in the Enhanced FTP Site Import directory. Only authenticated users can access safehouse locations, which reside on highly redundant, highly available central storage servers. Data retention policies default to retaining files for 21 days before deletion.