Cannot seem to delete files from the SFTP in Automation Studio. It returns success but doesn't delete.
Step 0) Transfer file
hello_world_2021-05-27T17-06-19Z.csv to sftp
Create Automation with the following:
Step 1) Create File Drop for files which start with
Step 2) Import into DE
Step 3) Delete file from Import folder with Data Extract
Extract Type: Delete File from ET FTP or Safehouse
FTP Folder: Import
%%BASEFILENAME_FROM_TRIGGER%%.csv (to match naming pattern above)
Open SFTP via terminal.
Removing /import/hello_world_2021-05-27T17-06-19Z.csv Couldn't delete file: No such file or directory
Any insight into why I can't delete files from the SFTP would be appreciated, thank you.
Edit: If i write a manual filename in and execute the activity once, it will delete. It's when i try to use substitute strings that it doesn't work. Can anyone else confirm that they have this working? Thanks.