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 |
---|---|---|
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:
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:
Note: The Application name value will be ignored if the Mode is set to |
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 Default is |
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 |
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, |
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:
Default is Actual. |
Start Date | Yes | Required. The Start date to be used to filter the data. The format must be |
End Date | Yes | Required. The End date to be used to filter the data. The format must be |
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 |
---|---|
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 |
Created in 2020 by Google Inc.