Tables
The provider models the data in Zendesk as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider for Zendesk Tables
| Name | Description |
| AccountSettings | Returns account settings, including branding, ticket, and collaboration preference details. |
| ArticleAttachments | Returns file attachments associated with help center articles, including file metadata and content details. |
| ArticleComments | Returns article comments, including comment body, author, locale, and vote details. |
| ArticleLabels | Returns article labels used to categorize and organize help center articles. |
| Articles | Returns knowledge base articles, including content, locale, section, and permission details. |
| ArticleTranslations | Returns article translations, including title, body, locale, and draft status details. |
| Attributes | Returns attribute records used for skill-based routing. An attribute refers to a skill type, and skill types are categories of skills. |
| AttributeValues | Returns attribute values, where each value represents a skill associated with an agent that determines the agent's suitability to solve a ticket. |
| Automations | Represents automations that trigger actions on tickets based on time-based conditions. |
| Bookmarks | Returns bookmarks associated with tickets. |
| Brands | Returns brands, including name, subdomain, Help Center state, and logo details. |
| Categories | Represents categories used to organize sections and articles in the Help Center. |
| CategoryTranslations | Returns translations for help center categories, including title, body, locale, and status details. |
| ContentSubscriptions | Returns content subscriptions, including subscriptions to sections, articles, community posts, and community topics. |
| ContentTags | Represents content tags used for organizing and categorizing help center content. |
| CustomAgentRoles | Returns custom agent roles, including role configuration and permission details. |
| CustomObjectFields | Returns the fields available for a custom object, including field type, validation, and relationship details. |
| CustomObjects | Represents the custom objects available in the account. |
| CustomTicketStatuses | Represents the custom ticket statuses available in the account. |
| GroupMemberships | Represents the group memberships that define which agents belong to which groups. |
| Groups | Returns groups, including name, membership, and status details. |
| GroupSlaPolicies | Returns group SLA policies, including filter conditions, position, and policy metric details. |
| Holidays | Returns holidays configured for schedules, including name and date range details. |
| JiraLinks | Returns links between Jira issues and Zendesk tickets. |
| LegacyCustomObjects | Returns legacy custom objects, including creation, update, and identifier details. |
| Macros | Returns macros used to automate ticket updates, including action, access, and restriction details. |
| ManagementPermissionGroups | Returns management permission groups, which define which agents can create, update, archive, and publish articles. Each group consists of a set of privileges mapped to user segments, and agents receive the privileges associated with their user segments. |
| OrganizationFields | Returns organization fields, including key, type, title, and custom field option details. |
| OrganizationMemberships | Returns organization memberships, including user and organization association details. |
| Organizations | Returns organizations, including group assignments, domain names, and tag details. |
| OrganizationSubscriptions | Returns organization subscriptions, including user and organization association details. |
| PostComments | Retrieves, creates, updates, and deletes comments on community posts. |
| Posts | Represents community posts, including authoring, status, and topic details. |
| SatisfactionRatings | Returns satisfaction ratings submitted for resolved tickets. |
| Schedules | Returns business hour schedules, including name, time zone, and interval details. |
| Sections | Returns Help Center sections, including category, locale, and sorting details. |
| SectionTranslations | Returns translations for Help Center sections, including locale, title, body, and draft status details. |
| Sessions | Returns active user sessions, including session authentication and last activity details. |
| SharingAgreements | Represents sharing agreements with other Zendesk accounts. |
| SideConversations | Returns side conversations on a ticket, including subject, state, participant, and timeline details. |
| SlaPolicies | Returns SLA policies, including filter conditions and policy metric details. |
| SupportAddresses | Returns support addresses used for receiving and sending email in Zendesk Support. |
| SuspendedTickets | Returns tickets that have been suspended and are pending review or deletion. |
| Targets | Returns targets, including type, title, activation status, and contact details. |
| TicketAudits | Returns ticket audits, including audit events, metadata, and channel source details. |
| TicketComments | Returns comments belonging to a specified ticket, including comment body, author, channel, and metadata details. |
| TicketEvents | Returns ticket events, including child events, updater, and metadata details. |
| TicketFields | Returns ticket fields, including field type, display, and configuration details. |
| TicketForms | Provides ticket form definitions used to structure and organize ticket fields for agents and end users. |
| TicketMetricEvents | Provides ticket metric events that track timing milestones and SLA activity for tickets. |
| TicketMetrics | Provides performance metrics for tickets, including timing, assignment, and resolution details. |
| Tickets | Returns tickets, including status, priority, assignee, requester, and tag details. |
| TicketSkips | Returns ticket skips, which are records of when an agent skips over a ticket without responding to the end user. Skips are typically recorded while a play-only agent is in Guided mode. |
| Tickets_Collaborators | Returns the collaborator Ids of users currently copied (CC'd) on a ticket. |
| Tickets_Followers | Returns the Ids of agents currently following a ticket. |
| Tickets_Followups | Returns the Ids of followup tickets created from a closed ticket. |
| Tickets_SatisfactionRatings | Returns the satisfaction rating or satisfaction state of a ticket. |
| Tickets_SharingAgreements | Returns the sharing agreements associated with a ticket. |
| Tickets_Tags | Returns the tags applied to a ticket. |
| Tickets_Viasources | Returns the via source details for a ticket. |
| Topics | Provides topics used for categorizing and grouping content in the community. |
| Translations | Returns translations for Help Center content. This table is deprecated and is being replaced by the ArticleTranslations, CategoryTranslations, and SectionTranslations tables. |
| TriggerCategories | Returns trigger categories used to organize and group triggers. |
| Triggers | Returns triggers used to automatically perform actions when specified conditions are met. |
| UserFields | Returns user fields, including custom field type, validation, and relationship filter details. |
| UserIdentities | Represents the identities associated with users, such as email addresses, phone numbers, and social accounts. |
| Users | Represents the users in the account, including agents, admins, and end users. |
| UserSegments | Represents user segments that define who can view the content of a section or topic. |
| Views | Represents the views used to organize and display tickets based on defined conditions. |
| Votes | Represents the positive and negative votes cast by users on articles, article comments, posts, and post comments. |