How to pull multiple csv files located in a SFTP server into the servicenow data source for process

saikatmitra6919
Tera Contributor

Hi All,

 

Need one suggestion quickly as how to pull multiple csv files located in a SFTP server into the ServiceNow data source for processing one by one using the transform map. This is needed urgently. Need some advise suggestion. Data Source can track one file as mention in the file path but can not pull all files in a folder one by one.

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

@saikatmitra6919 

1 data source can bring only 1 file at 1 point of time.

so you will have to create those many data sources

then create respective scheduled data import and make the scheduled data import parent of previous one so that it runs after the 1st is done

Schedule a data import 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader