ServiceNow Connector
Documentation
Version: 2
Documentation
Endpoint

Get Table Rows


Name

get_table_rows

Description

Get table rows [API reference]

Related Tables

[Dynamic Table]

Parameters

Parameter Label Required Options Description
TableName TableName YES Table name
PagingRowCount Page Size (Default=2000, Max=10000) YES Max can be 10000 but it may decrease performance if you fetching less than 10K rows in some requests.
SysId SysId NO Row 'sys_id'
Fields Fields NO Comma-separated field names you want to return in the response. E.g. sys_id,name,label,sys_name,sys_updated_on. Using this setting reduces the response size and speed up the processing.
Query Query / Order By (Server Side Filter) NO
Option Value
Equal Example numberISINC0000060
AND Example category=software^category=hardware
OR Example category=software^ORcategory=hardware
IN Example categoryINsoftware,hardware
STARTSWITH Example categorySTARTSWITHsoftware
NOT EQUAL Example category!=software
Filter Condition AND Order By category!=software^ORDERBYname
Order By name column ORDERBYname
Order By name column (Descending) ORDERBYDESCname
Order By Multiple Fields (ASC + DESC) ORDERBYcolumn1^ORDERBYDESCcolumn2
Server side search / filter condition [API reference]

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
sys_id DT_STR varchar(64) 64 False
[$parent.Pivot_Name$] DT_WSTR nvarchar(2000) 2000 False
If the column you are looking for is missing, consider customizing ServiceNow Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use ServiceNow Connector in API Source component to read data or in API Destination component to read/write data:

Read from [Dynamic Table] table using API Destination

This Endpoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

ServiceNow
[Dynamic Table]
Select, Lookup
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get table rows

SELECT * FROM get_table_rows
WITH
(
    "TableName" = 'abcd-1234-tablename'
)

get_table_rows endpoint belongs to [Dynamic Table] table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get table rows

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_table_rows
WITH
(
    "TableName" = ''abcd-1234-tablename''
)';

EXEC (@MyQuery) AT [LS_TO_SERVICENOW_IN_GATEWAY];

get_table_rows endpoint belongs to [Dynamic Table] table(s), and can therefore be used via those table(s).