Uploading to vendor SFTP using public/private key pair

[LBCoEnterprises]

I have done quite a bit of searching on the forum and can't find an answer for what I am looking for, but most seem to be downloading from SFTP instead of uploading and others are several years old.

I need to upload a .csv file to a  vendor's SFTP server each morning.

I am using a text file to hold the URL which I have as sftp://sftp.xxxxxxxxxx.com:222/folder1/folder2

The text file also holds the filedoc for the blob tool to convert.

For the Download tool I have the URL selected on the basic tab, on the payload tab I have PUT on the action and BLOB on the Take Query/Body from field, and on the connection tab I have the username given by the vendor and the private key that was generated during the private/public key pair using puttyGen. 

The vendor has already loaded the public key on their end and has whitelisted our outgoing Alteryx gallery (where this is being run from) IP address.

I am not sure if I have the URL correct or really what is going on but I keep getting errors.

I've tried the URL several different ways and always get a 'timeout error'

When I use the URL above instead I get a 'Login Denied' error, which makes me think it has something to do with credentials.

Any ideas to get this to work?

[apathetichell]

I recommend using CLI scripting/run command and something like winscp for this.

[LBCoEnterprises]

That's beyond my skillset, and we can't download Winscp on our work system. 

Why won't this work with these standard tools? Is this not what they are even there for?

[apathetichell]

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

Alteryx's download tool needs a rename and a revamp - and probably needs to be split into a more FTP/SFTP friendly tool and a more API (99% REST with the oddball like me running SOAP).