Extract file from SFTP using the PrivateKey and the password

Question

Hi everyone,

I want to automate a manual task of :

1. opening the SFTP [URL(sftp://example.com), Username, Private key and password used]
2. going to a particular folder
3. picking the latest file and downloading to my system
4. unzip the file and use it in my alteryx workflow.

I know there is some confusion as to how to automate this task. I would really appreciate any help in this matter. If any working alteryx workflow that could be provided for reference, even better.

Thank You in advance!

Jotigautam · Accepted Answer

@i_m_AB you can refer to these posts around same scenario

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Download-from-SFTP/td-p/44846

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SFTP-tools-for-Alteryx/td-p/576401