ServiceNow Connector

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

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC 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.