Connecting to ftpserver from Alteryx

I am using Download tool and option as PUT to upload a xlsx file into the ftpserver but getting the below error

Getting the below error

HTTP/1.1 401 Unauthorized
Set-Cookie: currentAuth=Iu5e; path=/; secure; SameSite=None
Set-Cookie: CrushAuth=1649267987745_WjsaCdNPq5DdsDiw3e5XRftokXIu5e; path=/; secure; SameSite=None; HttpOnly
Pragma: no-cache
Connection: close
WWW-Authenticate: B...

But when I try manually using the same username and password I could able to upload.

Ftp_copy_latest.yxmd

Error1.png

Sharepoint

Accepted answers

SPetrie

Looks like that site is hosted by CrushFTP who Ive had to deal with in the past. They do have an API but I was never able to get it to work with the download tool.

I ended up just using a workflow to create a curl command and pass it to a run tool.

Im not a fan of this method since I have to store the password in plain text, but it does work.

If someone else can help get it to work with the download tool, Id be interested in that answer as well.

ftpcopy.yxmd

spraveenkd

SPetrie-- Thanks...its working.

I searched in %temp% folder in my system and i didnt get the Ftpcall.bat file.

From did its taking the file.

All comments

mceleavey

@TheOC

apathetichell

first off - don't share passwords. (see password in your connection field)

second off - your config is off - you are including username hard coded in your connection - you can't also include it as a variable in your header. Toggle that off. Add your username into connection.

third off - you don't want to include your file as a constant in your header - click that off.

Try again and see what you get.

SPetrie

Looks like that site is hosted by CrushFTP who Ive had to deal with in the past. They do have an API but I was never able to get it to work with the download tool.

I ended up just using a workflow to create a curl command and pass it to a run tool.

Im not a fan of this method since I have to store the password in plain text, but it does work.

If someone else can help get it to work with the download tool, Id be interested in that answer as well.

ftpcopy.yxmd

spraveenkd

SPetrie-- Thanks...its working.

I searched in %temp% folder in my system and i didnt get the Ftpcall.bat file.

From did its taking the file.

spraveenkd

The password which i shared is a dummy one.

I tried this options and its working.

SPetrie

Glad its working.

Although its written like it would be in your system temp folder, the batch file gets created in the engine temp folder.

usually c:\users\username\appdata\local\temp\engine###....\FTPcall.bat

you can find your engine temp folder in constants area of the workflow tab.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335