appmixer.servicenow.record.ListRecords
1.0.0
Public
| Field | Type | Description |
|---|---|---|
| Table name | text | Name of the table from which to retrieve the record. |
| Query | textarea | An encoded query string used to filter the results |
| Display value | toggle | Return field display values (true), actual values (false), or both (all) (default: false) |
| Exclude reference link | toggle | True to exclude Table API links for reference fields (default: false) |
| Suppress pagination header | toggle | True to supress pagination header (default: false) |
| Fields | text | A comma-separated list of fields to return in the response |
| Limit | number | The maximum number of records to return. If you do not specify a value, the default is 1000. The maximum value is 10000. |
| Offset | number | Starting record index for which to begin retrieving records. Use this value to paginate record retrieval. This functionality enables the retrieval of all records, regardless of the number of records, in small manageable chunks. For example, the first time you call this endpoint, sysparm_offset is set to "0". To simply page through all available records, use sysparm_offset=sysparm_offset+sysparm_limit, until you reach the end of all records. Do not pass a negative number in the sysparm_offset parameter. |
| View | text | UI view for which to render the data. Determines the fields returned in the response. Valid values: desktop, mobile, both. If you also specify the sysparm_fields parameter, it takes precedent. |
| Query category | text | Name of the query category (read replica category) to use for queries |
| Query no domain | toggle | True to access data across domains if authorized (default: false) |
| No count | toggle | Do not execute a select count(*) on table (default: false) |
| Output Type | select | Choose whether you want to receive the result set as one complete list, or one item at a time or stream the items to a file. For large datasets, streaming the rows to a file is the most efficient method. |
Dynamic variables loaded from /component/appmixer/servicenow/record/ListRecords?outPort=out