RecordListRecords
Query records (contacts) within a Record List. Requires RecordListId filter.
Select
The add-in uses the Talkdesk API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.
- RecordListId supports the following operators: =.
- Priority supports the following operators: =, IN.
- PhoneNumbers supports the following operators: =.
For example, the following query is processed server-side:
SELECT * FROM RecordListRecords WHERE RecordListId = 'value'
The add-in pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the add-in.
- UpdatedAt supports the following sort directions: ASC, DESC.
- Priority supports the following sort directions: ASC, DESC.
For example, the following query is sorted server-side:
SELECT * FROM RecordListRecords WHERE RecordListId = 'recordlistid-1' ORDER BY UpdatedAt ASC
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the record. | |
| RecordListId [KEY] | String |
RecordLists.Id | The unique identifier of the record list. Required filter. |
| FirstName | String | The first name of the record. | |
| LastName | String | The last name of the record. | |
| Timezone | String | The timezone of the record. | |
| Priority | Integer | Priority of the record within the record list (1-10). | |
| ExternalId | String | Unique identifier for resource in external source. | |
| ExternalProvider | String | Name of the external resource. | |
| ExternalUrl | String | Resource location in external source. | |
| SyncExternalId | Boolean | Whether to sync external ID with contacts. | |
| PhoneNumbers | String | JSON array of phone numbers with phone_number and phone_type fields. Filtering with = matches records that have the given phone number. | |
| ExtraData | String | Extra data associated with the record as JSON. | |
| CreatedAt | Datetime | The record creation date. | |
| UpdatedAt | Datetime | The record update date. |