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

Created in 2020 by Google Inc.