ServiceNow Batch Source

Plugin version: 1.2.0

Reads from one or multiple tables within ServiceNow depending on the mode value set for this plugin. In case of Reporting mode, the source will output a record for each row in the table it reads, with each record containing an additional field that holds the name of the table the record came from. In case of Table mode, this additional field will not be there in the output. In addition, for each table that will be read, this plugin will set pipeline arguments where the key is multisink.[tablename] and the value is the schema of the table.

Configuration

Property	Macro Enabled?	Description

Property	Macro Enabled?	Description
Label	No	Required. The name of the node in your data pipeline.
Use connection	No	Required. Browse for a connection to the source. If Use connection is selected, you don't need to provide credentials.
Connection	Yes	Required. Name of the connection to use. If Use connection is selected, this field appears. Database and table information is provided by the connection.
Reference Name	No	Required. Name used to uniquely identify this source for lineage, annotating metadata.
Mode	Yes	Required. Mode of query. The mode can be one of two values: Reporting. Will allow user to choose application for which data will be fetched for all tables, Table. Will allow user to enter table name for which data will be fetched. Default is Reporting.
Reporting Mode: Application Name	Yes	Optional. Application name for which data to be fetched. The application can be one of three values: Contract Management. Will fetch data for all tables under Contract Management application. Product Catalog. Will fetch data for all tables under Product Catalog application. Procurement. Will fetch data for all tables under Procurement application. Note: The Application name value will be ignored if the Mode is set to `Table`.
Reporting Mode: Table Name Field	Yes	Optional. The name of the field that holds the table name. Must not be the name of any table column that will be read. Note, the Table name field value will be ignored if the Mode is set to `Table`. Default is `tablename`.
Table Mode: Table Name	Yes	Optional. The name of the ServiceNow table from which data to be fetched. Note: The Table name value will be ignored if the Mode is set to `Reporting`.
Client ID	Yes	Required. The Client ID for ServiceNow Instance.
Client Secret	Yes	Required. The Client Secret for ServiceNow Instance.
REST API Endpoint	Yes	Required. The REST API Endpoint for ServiceNow Instance. For example, `https://instance.service-now.com`
User Name	Yes	Required. The user name for ServiceNow Instance.
Password	Yes	Required. The password for ServiceNow Instance.
Type of values	Yes	Required. The type of values to be returned. The type can be one of two values: Actual. Will fetch the actual values from the ServiceNow tables. Display. Will fetch the display values from the ServiceNow tables. Default is Actual.
Start Date	Yes	Required. The Start date to be used to filter the data. The format must be `yyyy-MM-dd`.
End Date	Yes	Required. The End date to be used to filter the data. The format must be `yyyy-MM-dd`.
Page Size	Yes	Optional. The number of records to fetch from ServiceNow. Default is 5000.

Data Type Mapping

ServiceNow Data Type	CDAP Schema Data Type

ServiceNow Data Type	CDAP Schema Data Type
decimal	double
integer	int
boolean	boolean
reference	string
currency	string
glide_date	string
glide_date_time	string
sys_class_name	string
domain_id	string
domain_path	string
guid	string
translated_html	string
journal	string
string	string
glide_date	date
glide_datetime	datetime