Import data from SFTP server ( hosted in Customer network) via MID server

[Manik Arora]

Hi All,

 We have a requirement where we need to import data into our ServiceNow instance using an import data source and with the following options:

Type is : 'File'

Format : 'CSV'

File retrieval method : SFTP

I know we have the option 'Server' where we can give domain name/IP address of server where file is stored, my question is can we pick up the file from SFTP server ( Customer Network) via Mid-Server ?

Can you guide me after this what steps we need to follow to import data if it is possible.

I can see MID server option only comes for JDBC type, can we use File type and use MID server in this case also?

 Please help. @Mihir Mohanta @Chuck Tomasi

[Prateek kumar]

See if the below helps:

https://community.servicenow.com/community?id=community_blog&sys_id=475eeaaddbd0dbc01dcaf3231f96198a

[Manik Arora]

Thank you for your response. I actually found this but in this case, they are exporting data from ServiceNow using export set and MID server. I actually want to import data from SFTP server(located at customer location) via MID server.

[Liz26]

Hi Manika, did you get a solution to this? I have a similar scenario, if you could help me.

thank you

[Richard Hine]

Liz,

I don't believe the sys_data_source for SFTP supports MID server use. Probably the best way is to use the SFTP Flow step to retrieve your file but that does require Integration Hub Professional licence.

If you don't have that licence then you might have to look at having something customer side send the file(s) you want to ServiceNow using the attachment API.

Hope this helps,

Richard