| 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]
|
