I have a requirement where the files in our directory have the naming convention as: filename_{yyyymmdd}.{hh23miss}.txt
abc_20220131.121314.txt
The interface can and SFTP smart service combination can read the user input for file and date combination, but how can I retrieve a file which has timestamp associated?
Newbie to Appian, please assist.
Discussion posts and replies are publicly visible
I think that the FTP plugin allows you to fetch all file names from the remote directory. Then you can lookup the exact file name matching the data entered by the user and download it.
This is the service - Get Remote Directory Contents Over SFTPAnd then you can use the like() function if you do not have the exact name or use the combination of index() and wherecontains() if you have the exact name.