Connecting to ftpserver from Alteryx

[spraveenkd]

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.

[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 · Accepted solution]

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.

[spraveenkd · Accepted solution]

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.