I need to fetch multiple XML files from external source using Data source SFTP and load it into servicenow target table .
The xml files are stored in external folder and using SFTP as file retreival method in data source,i need to fetch data in all those files and transform it in servicenow.
Since,there are more than one files,I cannot give exact file path for multiple files in single data source.
The XML files count in external folder is not fixed and can change everyday.
Any suggestion,how can we do this?
