Delete files through sftp

Hello analytics far and wide!
Today I present you with a problem, where we have a workflow in designer. The workflow is amongst other things supposed to fetch a certain file from our Linux server through SFTP. The connection works fine and the file uploads&downloads are successful.

However, when we try to delete the aforementioned file from the server, we are at an impasse. The HTTP -action DELETE does nothing at all and neither does giving the custom -action any of the typical Linux commands.
As the situation is quite difficult to describe, I will add a bunch of footage to boot.

Any tips how to successfully delete the file or what commands to run on the custom action?

Thank you kindly for any insight

customaction.png

dataupload_download.png

deleteaction.png

workflow.png

Datasets

In Database

Download

Database Connection

In-Database

Accepted answers

JohnPo

Hi Kakelad,

Thank you for posting on the Community forum. The DELETE action won't work because in the back-end the curl command that is sent to the server is different depending on whether you're using SFTP or FTP. A colleague of mine created a workflow that will dynamically delete the file for you from the SFTP server. Would it be possible to setup a Webex call? If so, I'd gladly walk through with you how to remove the file from the SFTP server using the run command and a .bat file. I'll can also provide the workflow after the meeting as well. Please message me with your availability and your email to send the Webex meeting invite.

Best,

John Posada

Senior Customer Support Engineer

Alteryx

All comments

JohnPo

Hi Kakelad,

Best,

John Posada

Senior Customer Support Engineer

Alteryx

Kakelad

Hello and thank you for the response!
I will discuss this with our analytics team ASAP and I'll get back to you. It might be more beneficial for one of our analytics' guys who actually deal with the workflows to have a call with you. I'm just the Technical Manager, but am somewhat familiar with Alteryx.
Do you use skype at all?

Thanks again and I'll be in touch!

saajith

Hi John - I am interested in this solution as well (Delete files from SFTP Server). Would you be able to share the solution with me?

Thanks in advance!

Sajith

ninasun

Hi John,

Would you share the workflow to delete files from sFTP? I've been looking for a solution and found this thread today. Would appreciate your help!

Thanks,

Nina

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703