Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.

Straight DL of a non-modified xlsx file from app

salbol1
8 - Asteroid

Pretty straight forward, an xlsx file with multiple tabs is being downloaded from an outside SFTP server is being loaded to a local drive. It's formatted already as the users would like it, only needing an app that upon run will save it to a local directory path chosen by the user.

 

Don't build apps much, pretty much just process flows. What's the easiest/cleanest method to provide this function?

 

TIA

1 REPLY 1
JeffK
Alteryx
Alteryx

Hi @salbol1 - In Designer you'll want to use the Interface tools, specifically the File Browse on the final Output Tool with an Action Tool for the path update.

 

The File Browse will specify the what to Save As.

JeffK_0-1642601011422.png

 

The Action Tool will update the original Output file path that you used in the workflow in Designer.

JeffK_1-1642601098201.png

 

You'll also want to view the Interface Designer to allow the user to choose the Save As selection in the app.

JeffK_2-1642601177734.png

 

Just that setup alone will make the app run the workflow and generate the output as specified which would be the easiest/cleanest. There are also some Interactive Lessons via the Academy that can give you some walkthroughs that can help the setup as well.