RecordListRecords

Query records (contacts) within a Record List. Requires RecordListId filter.

Select

The component 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 component.

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 component pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the component.

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.

SSIS Components for Talkdesk

RecordListRecords

Select

Columns