SFTP Connection, Directory Input, Wildcard File Selection

I am able to successfully connect to SFTP via using the Text Input + Download File functions but would like to know how to be able to connect to SFTP, show a list of available directories/folders and use wild card formula tool to select a file to download to OneDrive.

The current Text Input+Download file forces a user to specify which specific file in the SFTP connection to download.

Given that the file that I am looking to download has a date stamp that changes daily, I am looking to use a formula tool to identify which specific file to download.

I have previous experience performing such a function on files that are stored on shared drives/share point by using Dynamic Input tool and would like to see if there is a similar method for SFTP as well.

Developer

Database Connection

Accepted answers

PedrodeOl

@Jes

Could you try:

1. Use the data cleasing tool to remove trailing spaces or duplicate whitespaces in the Download Data field

2. Use the text to columns tool and split the information into rows using \s

Probably there will be a pattern.

Please let me know.

All comments

Harbinger

@Jes you'll likely need to iterate with multiple downloads passing deeper and deeper folder structures. can you share a screen shot of what you're returning with the first output from the download?

Jes

When using text input & download file, the downloaddata output is a long string without any sort of pattern to how it is pulling the directory's files.

Looking to extract CSV files based on date stamp, which is embedded in the file name.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703