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

Question

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 · Answer

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.

megaron · Answer

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

apathetichell · Answer

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