ServiceNow Connector
The high-performance ServiceNow Connector provides read/write capabilities within your application, allowing you to perform numerous ServiceNow operations with minimal coding or even no-coding at all. Integrate ServiceNow data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.
Download for SSIS Download for SQL Server and ODBC Documentation
Integrate ServiceNow with these applications
Actions supported by ServiceNow Connector
ServiceNow Connector supports following actions for REST API integration:
Delete a Table Row
Description
Insert a row into the table.
Parameters
You can provide the following parameters to this action:
-
TableName
Input Fields
You can provide the following fields to this action:
-
[Dynamic Column]
Output Fields
The following fields are returned after calling this action:
-
sys_id
-
[Dynamic Column]
Visit documentation for more information.
Delete table row
Description
Delete the specified row in the table by row 'sys_id'.
Parameters
You can provide the following parameters to this action:
-
TableName
-
SysId
Input Fields
You can provide the following fields to this action:
-
sys_id
Output Fields
The following fields are returned after calling this action:
-
status
-
sys_id
-
http_status
Visit documentation for more information.
Get List Of System Tables Admin Use Sys Db Object
Description
Get a list of tables created by 'system' user.
Parameters
You can provide the following parameters to this action:
-
Page Size (Default=2000, Max=10000)
-
SysId
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
sys_id
-
name
-
label
-
sys_name
-
create_access
-
alter_access
-
access
-
live_feed_enabled
-
sys_updated_on
-
sys_class_name
-
is_extendable
-
user_role
-
create_access_controls
-
delete_access
-
sys_updated_by
-
sys_class_path
-
sys_created_on
-
caller_access
-
client_scripts_access
-
extension_model
-
actions_access
-
sys_scope_link
-
sys_scope_value
-
sys_created_by
-
sys_class_code
-
read_access
-
super_class
-
sys_mod_count
-
ws_access
-
update_access
-
sys_package_link
-
sys_package_value
-
sys_update_name
-
scriptable_table
-
configuration_access
-
number_ref
-
sys_policy
-
sys_scope
-
sys_package
-
super_class_link
-
super_class_value
-
number_ref_link
-
number_ref_value
-
user_role_link
-
user_role_value
Visit documentation for more information.
Get List of Tables
Description
Get a list of tables.
Parameters
You can provide the following parameters to this action:
-
N/A
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
name
-
label
Visit documentation for more information.
Get List Of Tables Admin Use Sys Db Object
Description
Get a list of tables by quering sys_db_object. To read data from this object make sure user has read permission to this table.
Parameters
You can provide the following parameters to this action:
-
Page Size (Default=2000, Max=10000)
-
SysId
-
Query
-
Fields
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
sys_id
-
name
-
label
-
sys_name
-
create_access
-
alter_access
-
access
-
live_feed_enabled
-
sys_updated_on
-
sys_class_name
-
is_extendable
-
user_role
-
create_access_controls
-
delete_access
-
sys_updated_by
-
sys_class_path
-
sys_created_on
-
caller_access
-
client_scripts_access
-
extension_model
-
actions_access
-
sys_scope_link
-
sys_scope_value
-
sys_created_by
-
sys_class_code
-
read_access
-
super_class
-
sys_mod_count
-
ws_access
-
update_access
-
sys_package_link
-
sys_package_value
-
sys_update_name
-
scriptable_table
-
configuration_access
-
number_ref
-
sys_policy
-
sys_scope
-
sys_package
-
super_class_link
-
super_class_value
-
number_ref_link
-
number_ref_value
-
user_role_link
-
user_role_value
Visit documentation for more information.
Get List Of User Tables Admin Use Sys Db Object
Description
Get a list of tables not created by 'system' user.
Parameters
You can provide the following parameters to this action:
-
Page Size (Default=2000, Max=10000)
-
SysId
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
sys_id
-
name
-
label
-
sys_name
-
create_access
-
alter_access
-
access
-
live_feed_enabled
-
sys_updated_on
-
sys_class_name
-
is_extendable
-
user_role
-
create_access_controls
-
delete_access
-
sys_updated_by
-
sys_class_path
-
sys_created_on
-
caller_access
-
client_scripts_access
-
extension_model
-
actions_access
-
sys_scope_link
-
sys_scope_value
-
sys_created_by
-
sys_class_code
-
read_access
-
super_class
-
sys_mod_count
-
ws_access
-
update_access
-
sys_package_link
-
sys_package_value
-
sys_update_name
-
scriptable_table
-
configuration_access
-
number_ref
-
sys_policy
-
sys_scope
-
sys_package
-
super_class_link
-
super_class_value
-
number_ref_link
-
number_ref_value
-
user_role_link
-
user_role_value
Visit documentation for more information.
Get Table Columns
Description
Get a list of columns of a table.
Parameters
You can provide the following parameters to this action:
-
TableName
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
name
-
element
-
label
-
internal_type
-
max_length
-
column_type
-
type
-
filterable
-
reference_display_field
-
reference_attributes_display_field
-
reference_attributes_ref_ac_columns
-
reference_attributes_ref_ac_columns_search
-
reference_attributes_ref_ac_display_value
-
reference_attributes_ref_auto_completer
-
canmatch
-
cangroup
-
max_unit
-
mandatory
-
reference
-
default
-
base_type
-
read_only
-
hint
-
attributes
-
cansort
-
multitext
-
choice_type
-
choices
Visit documentation for more information.
Get Table Columns Admin Use Sys Dictionary
Description
Get a list of columns by quering sys_dictionary. To read data from this table make sure user has read permission to sys_dictionary table.
Parameters
You can provide the following parameters to this action:
-
TableName
-
Page Size (Default=2000, Max=10000)
-
PagingOffset
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
sys_id
-
name
-
element
-
internal_type
-
max_length
-
column_label
-
sys_name
-
comments
-
calculation
-
dynamic_ref_qual
-
choice_field
-
function_field
-
sys_updated_on
-
spell_check
-
reference_cascade_rule
-
reference
-
sys_updated_by
-
read_only
-
sys_created_on
-
array_denormalized
-
element_reference
-
reference_key
-
reference_qual_condition
-
xml_view
-
dependent
-
internal_type_link
-
sys_created_by
-
use_dependent_field
-
delete_roles
-
virtual_type
-
active
-
choice_table
-
foreign_database
-
sys_update_name
-
unique
-
dependent_on_field
-
dynamic_creation
-
primary
-
sys_policy
-
next_element
-
virtual
-
widget
-
use_dynamic_default
-
sizeclass
-
mandatory
-
sys_class_name
-
dynamic_default_value
-
write_roles
-
array
-
audit
-
read_roles
-
sys_scope_link
-
sys_scope_value
-
create_roles
-
dynamic_creation_script
-
defaultsort
-
use_reference_qualifier
-
display
-
reference_floats
-
sys_mod_count
-
default_value
-
staged
-
reference_type
-
sys_package_link
-
sys_package_value
-
formula
-
attributes
-
choice
-
reference_qual
-
table_reference
-
text_index
-
function_definition
-
sys_scope
-
sys_package
Visit documentation for more information.
Get Table Rows
Description
Get table rows.
Parameters
You can provide the following parameters to this action:
-
TableName
-
Page Size (Default=2000, Max=10000)
-
SysId
-
Fields
-
Query / Order By (Server Side Filter)
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
sys_id
-
[Dynamic Column]
Visit documentation for more information.
Update a Table Row
Description
Insert a row into the table.
Parameters
You can provide the following parameters to this action:
-
TableName
-
SysId
Input Fields
You can provide the following fields to this action:
-
[Dynamic Column]
-
sys_id
Output Fields
The following fields are returned after calling this action:
-
sys_id
-
[Dynamic Column]
Visit documentation for more information.
Make Generic API Request
Description
This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.
Parameters
You can provide the following parameters to this action:
-
Url
-
Body
-
IsMultiPart
-
Filter
-
Headers
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.
Make Generic API Request (Bulk Write)
Description
This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.
Parameters
You can provide the following parameters to this action:
-
Url
-
IsMultiPart
-
Filter
-
Headers
Input Fields
You can provide the following fields to this action:
-
N/A
Output Fields
The following fields are returned after calling this action:
-
N/A
Visit documentation for more information.