Skip to main content
gururajn0112
gururajn0112
July 4, 2022
Question

SFTP smart service to retrieve files based on partial match

  • July 4, 2022
  • 2 replies
  • 1 view

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.

    2 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 4, 2022

    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.

    harshitb6843
    harshitb6843
    July 5, 2022

    This is the service - Get Remote Directory Contents Over SFTP

    And 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. 

    Terms & ConditionsAccessibility statement