sftp Download tool - Failed Initialization

Hello, i am pulling data (GET request) from a clients sftp.

The download tool and workflow was working fine for the last 2 months, no changes were made to the workflow nor the download process

suddenly i am getting Error transferring data: Failed initialization error from the download tool. I am passing just the url and user/pass, one file download per run.

Has anyone found the cause of this?

I am able to access the folder thru filezila just fine with the credentials, just not thru Alteryx.

Developer Tools

Download

Accepted answers

Qiu

@Mmisiji60

Most likely your IT changed the security settings according to this post.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-transferring-data-failed-initialization-with-Download-Tool/ta-p/558597

Plamena10

Sure- this script is looking for .csv files in folder

Create 2 folders:

1. for keyfile you will need to create folder both on your local PC and the server if required -in my case i store txt file with SSH key

2. folder to where the file will be downloaded and (if needed) picked up back into the workflow

hope it helps

SFTP-Python.txt

All comments

Qiu

@Mmisiji60

Most likely your IT changed the security settings according to this post.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Error-transferring-data-failed-initialization-with-Download-Tool/ta-p/558597

Mmisiji60

Yes you are right, the server's security was raised and is not matching the download tool security transfer protocol. I am looking for a workarounds/ substitute for download tool.

thank you

CHarrison

Hi Mmisiji60! Did you find a solution/workaround to this problem yet?

Plamena10

Hi, it turned out that my client's encyption was higher than alteryx's and this blocked the connection.

I ended up using a python script in the workflow that would download the files from the SFTP to alteryx server.

CHarrison

Hi Plamena10! Thanks for the swift response - any chance you could share an anonymised version of the Python script with me?

Plamena10

Sure- this script is looking for .csv files in folder

Create 2 folders:

1. for keyfile you will need to create folder both on your local PC and the server if required -in my case i store txt file with SSH key

2. folder to where the file will be downloaded and (if needed) picked up back into the workflow

hope it helps

SFTP-Python.txt

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335