Download files from SFTP (that need SSH keys public, private) and move files to Archive

[priyaraghuveer1990]

Hello

Does anyone have a workflow that will download files from SFTP (using SSH public and private keys) and then move these files to an Archive folder? How do I achieve this?

Edit: Looking for a workflow that uses WinSCP. Please share it if you have one.

[apathetichell]

You can use cli to use putty/winscp or you can use paramiko in python. This is not natvely supported by Alteryx and you will need to script it yourself.

[priyaraghuveer1990]

Do you have any workflow I could use that uses WinSCP?

[apathetichell]

Sorry - I built one a few years back but I don't have access to it anymore.

[megaron]

I also need this setup. Does anyone have a workflow for me to follow

[apathetichell]

1) read up on how to install python packages (one off paramiko install)

2) ask chatgpt for a script using paramiko tailored to your file naming logic which takes in whatever variables you need.

3) put in python tool.

the issue is really your logic --- what files do you want - how do you know you want them? what are you doing with them after? The 'how do I connect to an SFTP via private key' --- is not the problem - that's easy - you use paramiko. The problem is once you've connected --- only you know what you are doing.