EndPoint Get Table Rows

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_table_rows

Description

Get table rows [API Help]

Parameters

Parameter

Label

Required

Options

Description

TableName

YES

Table name

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

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

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.