File retrieval from FTP to servicenow and creating record in servicenow

[Sriniwas]

Hi,

I have a requirement to retrieve the file from FTP server to servicenow and then create record in servicenow.

As per process,

1)we can create the data source with type FTP and provide the username and password and path where the file located.

2)create the transform map with import set table and load the data to target table.

can anyone please help me with below questions:

1)what is the difference if we use MID server and with out MID server for this requirement.

2)if i have so many folders in FTP (for example more than 50 folders and each folder contains one file), how to retrieve the files from all the 50 folders and load the data into servicenow.

Is one data source is enough or do we need to create 50 data sources?

Thanks,

Sriniwas

[Allen Andreas · Accepted solution]

Hi,

We didn't speak too thoroughly on the MID Server, which is a bit more complex, but you may be able to work through that. Here's a SN HI article covering some of the ways to do this (so you can evaluate for yourself). These are examples, but you get the idea:

https://hi.service-now.com/kb_view.do?sysparm_article=KB0817437

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Sriniwas]

Thanks Allen for your quick response and much useful information.

Thanks,

Sriniwas