Error in retrieving file from SFTP server (https://)

[mshin]

Hello all.  I am trying to access a file from an internal SFTP server that we have.  I am using the Text Input and the Download tools in Designer (v 2024.2).  Please refer to the attached Download configuration details (I set-up DCM for the access to the SFTP server).  When I run the process, I get the following error in Designer:  Error transferring data.  Func 'curl_easy_perform' failed, ret = 35, desc = SSL connect error.  I don't believe that our SFTP server also requires a SSH key.  Any thoughts on why I am getting this error?

Mike

[mceleavey]

Hi @mshin ,

have you defined the port in the SFTP connection? If so, is the port open and the firewall allowing SFTP requests?

Can you access it using FileZilla/Postman etc.?

[mshin]

Hello  @mceleavey .  Yes, I am able to access the SFTP server via WinSCP.  Yet, I cannot seem to get this to work with Alteryx Designer 2024.2.  I also tried hardcoding the username/pw/Port number in the Text input. This did not work either (vs the DCM approach).

[SPetrie]

Double check your URL that you are passing to the download tool. It looks like you may have the base url twice in the call.

Edit: Adding a screenshot and addition info.

The download tool is appending the URL field to the base url from the DCM connection, so what needs to be in that url input is just the subfolder that you want the download tool to look in. If you only need to the main folder, that URL field could just be a forward slash. I would also recommend changing the https in your url to be sftp instead. Since sftp uses port 22 by default, you should not have to specify it and it can be omitted, but no harm in leaving it in either.

.