How to import data from a csv file at local host into an import set?

[kj]

Hi,

I am developing an integration wherein I need to import data from a CSV file at a local host location: 

https://123.456.78.90:4321

Apart from the link, what I have is username and password for the link.

My question is: Is it possible to import data from such a file/location into ServiceNow? If so how do I create a Data Source connection?

And if not, what else do I need to get it working?

Thanks in advance!

[sachin_namjoshi]

This can be done using DATA source and Schedule Imports.

 Data Source:

File retrieval method as: SFTP

File Path: (your file location)

Server: IP of the server (we also gave the port number serverip:22)

Give the Import set table lable and name.

Once the data source is created, you can configure job in schedule Import.

Regards,

Sachin

[mukulgupta]

Hi!

For your requirement there are different File type of data source which you can use:

You can import a file from a local source, a remote network server, or another instance by providing a path and authentication information.

For file type import sets, you can select from a list of file retrieval methods, including FTP, FTPS, SCP, and HTTPS.

File retrieval methods

The following file retrieval methods are available to copy the file from where it resides to ServiceNow to be loaded into an import set.

After defining the files that are compatible with importing, define how the files can be imported.

Note: For the import to succeed, your FTP server and client must be set up for the same authentication mechanism that you select here. Refer to the following article for an explanation of FTP protocol support http://en.wikipedia.org/wiki/FTPS.

File Retrieval Methods

Attachment	Attach a file to the record and import that file in an import set.
File	Select a file to import from a local drive or a network location (not typical). Selecting this method provides a field to specify the network path. The system limits your selection to one of these file locations for increased security. Tomcat home. For example, /Apache Tomcat. Glide system home. For example, /<Tomcat home>/webapps/glide/itil/WEB-INF/. Temporary directory. For example, /tmp or /var/tmp depending on how your system is configured. If you need to specify an arbitrary network path, consider using a different file retrieval protocol such as FTP or SCP where you can secure the communications channel. Note: The ability to retrieve character-separated value (CSV) files from a MID Server is not available in the base system.
SFTP	Retrieve a file using SFTP. Fields are provided for the server name and logon credentials.
FTP	Retrieve a file from an FTP server in your network. Fields are provided for the server name and logon credentials. Note: FTP transfers are sent as clear text and cannot be encrypted. Use SCP or SFTP instead whenever possible.
FTPS (Auth SSL)	An FTP Secure authentication command issued through the Secure Socket Layer (SSL) protocol. This method is also known as explicit FTP over SSL.
FTPS (Auth TLS)	An FTP Secure authentication command issued through the Transport Layer Security (TLS) protocol. This method is also known as explicit FTP over TLS.
FTPS (Implicit SSL)	In implicit security, the FTPS server defines a specific port for the client (990) to use for secure connections. Implicit security automatically begins with an SSL connection the moment an FTPS client connects to an FTPS server.
FTPS (Implicit TLS)	In implicit security, the FTPS server defines a specific port for the client (990) to use for secure connections. Implicit security automatically begins with a TLS connection the moment an FTP client connects to an FTP server.
HTTP	Retrieve a file using HTTP. FIelds are provided for the server name and logon credentials. Important: For HTTP and HTTPS protocols, the file path is automatically URL encoded. Do not specify a URL-encoded file path when using either of these protocols.
HTTPS	Retrieve a file using HTTPS. Fields are provided for the server name and logon credentials. Use this method to transfer data between ServiceNow instances.
SCP	The Secure Copy protocol (SCP) securely transfers files between a local and a remote host or between two remote hosts, using the Secure Shell (SSH) protocol.

Reference Doc URL: https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/import-sets/refer...

Please let us know if the shared info was helpful by marking the response as Helpful.

Feel free to reach out if you have any additional questions.

Best Regards,

Mukul Gupta @ ServiceNow

[kj]

Thanks Mukul!