Get list of files from SFTP

[BonusCup]

Hi,

I'm building a workflow where I need to go in and first get a list of filenames from an SFTP server.  Using the links below I found from the Community, I've created a workflow where I can successfully log into the SFTP and download a specific file using a Text Input and Download tool

ISSUE:  When I change the 'url' in the Text Input to just the directory where the files are located (http://abc-b0-c1:xxxx/def/data/ghi/) and change the Download Tool configuration to Output to a String the "DownloadData" field is blank in the Results 

Community Links:

https://community.alteryx.com/t5/Alteryx-Designer/Download-from-SFTP/td-p/44846

https://community.alteryx.com/t5/Alteryx-Designer/Download-SFTP-files-with-Pattern/td-p/482508

https://community.alteryx.com/t5/Alteryx-Designer/List-Files-on-SFTP-Server/td-p/78016

Thanks in advance for any assistance with this.

[kunvai1]

Yes I did check the example. I have a question regarding that example. Where is that info.dat file coming from?

[BonusCup]

Are you seeing that in the 'Read Results (Optional)' Input section of the Run Command properties?  If so, that is the location you specify in "Field8" in the first Text Input.

If you are asking in general, that "Info<datetime>.dat" is the name of the file I am downloading from the SFTP

[kunvai1]

I've attached my workflow here. One more question :What should be there in the bat file in the output section and run external program?

And you said "Info<datetime>.dat" is the name of the file you're downloading from the SFTP. How come you mentioned that file in the Read Results section because that is the file you are looking to download. It shouldn't be already there right?

[BonusCup]

The Output is just the .bat file that gets created in the temp folder and the the Run External Program runs the .bat file from the temp folder.  If you click on the "Output..." button, it looks like your delimiter is set wrong.  Try setting it to "\0" instead of ","

\0 is the syntax to indicate no delimiter

As for Read Results, I wanted to bring the data in from the file also for the rest of the workflow.