| Info |
|---|
The ServiceNow Batch Multi Source is available in Preview from the Hub. |
Plugin version: 1.12.0
ServiceNow is a cloud-based software platform that provides service management software as a service. It provides a range of solutions around IT ticket, operation, business management and helps customers in their business transformation.
...
The user can also enter the start date and end date to filter the table data within a specific time period.
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. Used to uniquely identify this source for lineage, annotating metadata. |
Table Names | Yes | Required. The name(s) of the ServiceNow table from which data is to be fetched. |
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, For example, |
User Name | Yes | Required. ServiceNow username. Add what minimum permission the user should have, not in detail |
Password | Yes | Required. ServiceNow password. |
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 | Optional. The Start date is to be used to filter the data. The format must be |
End Date | Yes | Optional. The End date to be used to filter the data. The format must be |
Table Name Field | Yes | Required. The name of the field that holds the table name. Must not be the name of any table column that will be read. Defaults to Defaults to |
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 |
Example
Sample data in Table: pc_hardware_cat_item
Name | Price | Class |
|---|---|---|
Microsoft Wired Keyboard | $11.92 | Hardware Catalog |
Logitech Wireless Mouse | $35.88 | Hardware Catalog |
Apple iPad 3 | $600.00 | Hardware Catalog |
Sample data in Table: pc_software_cat_item
Name | Price | Class |
|---|---|---|
Zoom | $0.00 | Software Catalog |
Postman | $0.00 | Software Catalog |
Mozilla Firefox | $0.00 | Software Catalog |
To read data from these two tables, both of them must be entered in the Tables Names field under the Table specification section.
The output of the source will be the following records:
Name | Price | Class | tablename |
|---|---|---|---|
Microsoft Wired Keyboard | $11.92 | Hardware Catalog | pc_hardware_cat_item |
Logitech Wireless Mouse | $35.88 | Hardware Catalog | pc_hardware_cat_item |
Apple iPad 3 | $600.00 | Hardware Catalog | pc_hardware_cat_item |
Name | Price | Class | tablename |
|---|---|---|---|
Zoom | $0.00 | Software Catalog | pc_software_cat_item |
Postman | $0.00 | Software Catalog | pc_software_cat_item |
Mozilla Firefox | $0.00 | Software Catalog | pc_software_cat_item |
The plugin will emit two pipeline arguments to provide a multi sink plugin with the schema of the output records:
...