Can ServiceNow delete a file it has retrieved using SFTP after it grabs the file?

Cameron Wilson
Tera Expert

We are looking to setup a data source using SFTP to grab a file each day and then run an import and transform of that file to create records from the file. This would repeat everyday. My question is that after the file is retrieved is there a way for ServiceNow to delete that file off of that server so we are 100% positive the same file is not picked up the next day if there were any issues out of our control?

5 REPLIES 5

Raj_Esh
Kilo Sage
Kilo Sage

Hi Cameron,

 

Can you check the below link, 

Removes a file on an SFTP server

 

Thanks,

Raj

 

--Raj

Thanks Raj. I did take a look at that and it requires the Integration Hub Professional Pack subscription which we currently do not have. If we did have it, that appears to be a good solution so thank you for sharing.

J_r_my1
Kilo Guru

I guess it's a bit late, but it might be useful for other people.

After an import, you can delete the data on the sftp using the field property with the following property : remove_file=true

Can you let me know where we can give this property?