Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

File type data source fields

File type data source fields

These additional fields appear on the data source form when the Type field value is File.

Field Description
Format Select one of the following formats from the list: CSV, CSV (tab), Excel, XML.
Zipped Select this check box if the import file is compressed.
Xpath for each row Specify an XPath expression that selects the nodes which become rows in the import table. The children of the selected nodes will become the columns in the rows.
Expand node children Select this check box child elements of the node should be converted into additional columns. Clear this field if the parent column value should be an XML fragment.
File retrieval method Choose the appropriate retrieval method for this file. See File retrieval methods for more information.
File path Specify the path to the file to import.
SCP authentication method Select to authenticate with a Username and Password or with a Public key.
Note: You cannot authenticate to data sources with a public-private key pair. Use a username and password authentication instead.
Server Enter the name of the server from which the file will be imported.
Port Enter the port to use to connect to the specified server. This field appears if you select HTTP or HTTPS as the file retrieval method.
User name Enter the user name for authentication on the file server.
Password Enter the password for authentication on the file server.
Private keyfile Specify the keyfile when using legacy SCP public-private keyfiles.
Note: You cannot authenticate to data sources with a public-private key pair. Use a username and password authentication instead.
System KeyStore Select this check box to validate the certificate from the FTPS server against all saved certificates. This certificate may be any type supported by the instance. If you do not select this check box, the instance uses the Java default certificate to validate the FTPS server. This field is available only for data sources with a File retrieval method value of FTPS (Auth SSL)