This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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 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.
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?
Here is an example workflow that deletes files from an SFTP using a combo of the Download & Python tools. The example should be pretty straightforward, you just need to plug in your SFTP info in the necessary places (the red Comment boxes indicate tools that need to be updated).
Please let me know if you have questions, happy to help.