How to get files from FTP into ServiceNow

[Community Alums]

Hi,

Please help with methods that can be used to get files from FTP into ServiceNow. Should it be done via Mid Server or via script?

[Ankur Bawiskar]

Hi,

you can connect with the FTP Server using data source and bring the file and load it.

You can create Data Source with all the details for ftp server

You need to create scheduled imports and associate it with the above data source created

The scheduled import has configuration wherein you can specify the time.

Schedule a data import

Regards
Ankur

[Community Alums]

Hi Ankur,

Thanks for the reply, we tried the data source method and we are getting the error(attached) while trying to test load the data. Also there are 3 different CSV files wherein the name of the file changes everyday based on date and time and we need to get the data from all these 3 files.

[Ankur Bawiskar]

@Vineeth P V 

Possibly the instance is not able to directly connect with the FTP Server directly.

Let the file name change everyday.

If you know the file syntax then just before your scheduled import runs you can run schedule job to update the file name on the data source record.

Example: if file name is incident_2021-07-08.csv then next day it would be incident_2021-07-09.csv

So you can run daily scheduled job just before the scheduled import runs and change the file name and system will find the file and get the data

Regards
Ankur

[Ankur Bawiskar]

@Vineeth P V 

Thank you for marking my response as helpful.

If my response helped you please mark it correct to close the question so that it benefits future readers as well.

Regards
Ankur