DoNotCallEntries
Query phone number entries in a Do Not Call List. Requires DoNotCallListId 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.
- 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 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.
- 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. |