SFTP Data Source with a changing filename

troyholmes
Giga Contributor

‎11-09-2016 09:06 AM

I have setup a Data Source that is pulling files from an SFTP server as the source. The system that places the file appends numbers to the end of each exported file so the name of the file changes each day.

The file path that works is /my_inboxes/venafi/Manged Non-F5 Certificates 161108-1100.CSV

The numbers at the end of the file change with each export.  

Is there a way in the file path to use a wild card or to just pickup all the files in the directory.

Troy Holmes

Labels:
0 Helpfuls
  • 2,621 Views
6 REPLIES 6

kdevireddy
Giga Contributor

‎07-22-2017 05:50 AM

Hi All,



Selecting zipped option helped me overcome this issue.File with dynamic name will be zipped into   zip file with unique name, and we will configure zip file name in file path.This is the simplest method for this issue. Hope this will help someone who is still looking for solution.



Kiran


0 Helpfuls

Nikhil Raj
Kilo Contributor

‎02-07-2022 02:20 AM

I am having a similar kind of setup with sFTP where the files path along with the file name is as case sensitive. So if there is a mismatch in the name as in sFTP folder, Filename - CI_input.csv and in servicenow path mentioned as /Account/CI_Input.csv then it fails.

 

Is there any option to overcome this and it should take the value of the file path in any case ?

0 Helpfuls