CaseFields
Query case field definitions and their dictionary values.
Select
The CaseFields view does not push any filters to the Talkdesk API. The connector retrieves the full result set from the endpoint and applies any WHERE clause conditions client-side.
For example:
SELECT * FROM CaseFields
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique numeric identifier of the case field. | |
| FieldKey | String | The unique key of the case field. | |
| Name | String | The name of the case field. | |
| FieldType | String | The field type code (e.g., 001=dropdown, 004=text, 006=numeric, 009=date). | |
| Description | String | A description of the case field visible to agents. | |
| DictList | String | JSON array of dictionary entries with key, value, and children. | |
| Required | Boolean | Whether agents must fill this field to solve a case. | |
| Active | Boolean | Whether the case field is active. | |
| CreatedAt | Datetime | The date and time the case field was created. | |
| UpdatedAt | Datetime | The date and time the case field was last updated. |