SFTP Couldn't resolve host name

[MattBenj]

I am trying to download files from an SFTP using the Download tool. I have tested and validated the SFTP and credentials in FileZilla but getting an error in Designer. I copy the URL, including filename, from FileZilla, set the Payload to GET, and add username & password in the Connection tab but get the following error:

Error: Download (2): Error transferring data: Couldn't resolve host name for sftp://username@ftp.newblims.com/folder/filename.xml

I'm trying to make this post without posting sensitive information but I'm confused why this URL works in FileZilla but not the Download tool?

Thanks

[apathetichell]

Are you using SSH to connect (ie private key) ---> if so that's not natively supported by Alteryx. You can use Python or some CLI utilities (WinSCP)

[MattBenj · Accepted solution]

I solved this by adjusting my URL. I removed the username@ portion. The URL patterned off of sftp://ftp.newblims.com/folder/filename.xml worked for me.