Add Multiple Host Keys and cURL Options support to the Download Tool

[cam_w]

1) Add cURL Options support from within the Download Tool

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/File-Transfer-Protocol-FTP-Download/tac-p/41...

The Download tool allows adding Header and Payload (data), which are key components of the cURL command structure. However, there is no avenue to include any of the cURL options in the Download tool. Most of the 'solutions' found have been to abandon the use of the Download tool and run the cURL EXE through the Run Command tool. However, that introduces many other issues such as sending passwords to the Run Command tool, etc. etc.

With the variation and volume of connection requests that are being funneled through the Download tool, users are really looking for it to have the flexibility to do what they need it to do with the Options that they need to send to cURL.

2) Update cURL version used by Alteryx Download tool to a recent version that allows passing host keys

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Download-Tool-with-SFTP-and-multiple-K...

cURL added the option to pass host keys starting in version 7.17.1 (available 10/29/2007). The option is --hostpubmd5 <md5>:

https://curl.haxx.se/docs/manpage.html

And it appears that the cURL shipped with Alteryx is 7.15.1 (from 12/7/2005😞

PS C:\Program Files\Alteryx\bin\RuntimeData\Analytic_Apps> .\curl -V
curl 7.15.1 (i586-pc-mingw32msvc) libcurl/7.15.1 zlib/1.2.2
Protocols: tftp ftp gopher telnet dict ldap http file
Features: Largefile NTLM SSPI libz

Thanks for considering!

Cameron

[jarrod]

i think this gives power behind the idea of having a completely separate API tool (more like a postman setup) along with another separate FTP/SFTP tool. The advancement of auth standards and API usage has really increased and would love to see more support in native alteryx tools. @SeanAdams  would agree and even expand upon this thought.