EndPoint Get Table Rows

Name

get_table_rows

Description

Get table rows [API reference]

Parameters

Parameter

Label

Required

Options

Description

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

Row 'sys_id'

Fields

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)

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`

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:

Get Table Rows using API Source

ServiceNow

Get Table Rows

SSIS API Source - Read from table or endpoint

Get Table Rows using API Destination

ServiceNow

Get Table Rows