DoNotCallEntries
Query phone number entries in a Do Not Call List. Requires DoNotCallListId filter.
Select
The connector 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 connector.
- DoNotCallListId supports the following operators: =.
- PhoneNumber supports the following operators: =.
For example, the following query is processed server-side:
SELECT * FROM DoNotCallEntries WHERE DoNotCallListId = 'value'
The connector pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the connector.
- ExpirationDate supports the following sort directions: ASC, DESC.
- CreatedAt supports the following sort directions: ASC, DESC.
- UpdatedAt supports the following sort directions: ASC, DESC.
For example, the following query is sorted server-side:
SELECT * FROM DoNotCallEntries WHERE DoNotCallListId = '84a58336-383e-4c98-9c7e-faf557845cc7' ORDER BY ExpirationDate DESC
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the entry. | |
| DoNotCallListId [KEY] | String | The unique identifier of the do not call list. Required filter. | |
| PhoneNumber | String | The phone number on the do not call list. | |
| Reason | String | The reason for adding this phone number to the do not call list. | |
| ExpirationDate | Datetime | The date when this entry expires. | |
| CreatedAt | Datetime | The record creation date. | |
| UpdatedAt | Datetime | The record update date. |