ServiceNow Connector
Documentation
Version: 1
Documentation
Home > Connectors > ServiceNow > EndPoints > Get Table Rows

EndPoint Get Table Rows

Name

get_table_rows

Description

Get table rows [API Help]

Parameters

Parameter Label Required Options Description
TableName TableName YES Table name
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 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
Server side search condition [API Help..]
PagingRowCount PagingRowCount YES

Output Columns

Label DataType Length Raw Description
sys_id DT_STR 64 False
[$parent.Pivot_Name$] DT_WSTR 2000 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.