Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData ADO.NET Provider for Zendesk Views
| Name | Description |
| AccessLogs | Returns access logs, including request, response, and user details. |
| ActivityStream | Returns activity stream records, including ticket assignments, comments, and priority changes. |
| AllCustomers | Returns customer user records, including profile, role, and account preference details. |
| AppLocations | Returns app location records, including location name, product, and host application details. |
| Apps | Returns apps available in the Zendesk Marketplace, including rating, pricing, and organization details. |
| Attachments | Returns ticket attachment records, including file details, content type, and download URL information. |
| AuditLogs | Returns audit log entries, including actor, source, and action details. |
| Calls | Returns inbound and outbound call records from a Zendesk Talk instance, including agent, timing, and call quality details. |
| Collaborators | Returns collaborators associated with tickets, including user profile, role, and contact details. |
| DeletedTickets | Returns deleted tickets that are pending permanent deletion. |
| JobStatus | Returns job status records for background jobs, such as bulk ticket updates. Job status data is available for one hour after a job is created. |
| LegacyCustomObjectField | Returns the attributes of a legacy custom object property. |
| Locales | Returns available locales, including identifier, name, and URL details. |
| MonitoredTwitterHandles | Returns monitored Twitter handles, including screen name, profile, and reply permission details. |
| NegativelyRatedTicketsThisWeek | Returns tickets that received negative satisfaction ratings in the current week. |
| OpenTicketsAssignedToMe | Returns open tickets assigned to the authenticated account. |
| OrganizationFieldsRelationshipFilterAll | Returns the relationship filter entries using a logical AND condition for organization fields. |
| OrganizationFieldsRelationshipFilterAny | Returns the relationship filter entries using a logical OR condition for organization fields. |
| PositivelyRatedTicketsThisWeek | Returns tickets that received positive satisfaction ratings during the current week. |
| Requests | Returns end-user requests submitted as tickets, including subject, status, priority, and assignment details. |
| Requests_Collaborators | Returns the Ids of collaborators who are currently CC'd on a request. |
| ResourceCollections | Returns resource collections, including resource metadata details. |
| SatisfactionReasons | Returns reasons for bad satisfaction ratings submitted by ticket requesters. |
| SideConversationEvents | Returns side conversation events for tickets, where the messages that make up a side conversation are recorded as events. |
| SideConversationEventsMessage | Returns the message details for side conversation events. |
| SideConversationEventsMessageTo | Returns the list of participants the message was sent to. |
| SideConversationParticipants | Returns side conversation participants, including user, email, and messaging platform details. |
| SlaPoliciesFilterAll | Returns SLA policy filter conditions where all conditions must be met (logical AND). |
| SlaPoliciesFilterAny | Returns SLA policy filter conditions where at least one condition must be met (logical OR). |
| SlaPoliciesMetrics | Returns SLA policy metric targets for each priority level, describing the time-based targets measured in business or calendar hours. |
| SuspendedUsers | Returns users who have been suspended and are unable to sign in or submit tickets. |
| TargetFailures | Returns target failures, including HTTP status codes, failure counts, and raw request and response details. |
| TicketEmailCCs | Returns users CC'd on a specified ticket, including user Id and name details. |
| TicketFieldsRelationshipFilterAll | Returns ticket field relationship filter conditions joined with logical AND. |
| TicketFieldsRelationshipFilterAny | Returns ticket field relationship filter conditions joined with logical OR. |
| TicketRelatedInformation | Returns related information for a ticket, including linked issues, follow-up sources, and incident details. |
| UserEvents | Returns events for a given user. |
| UserFieldsRelationshipFilterAll | Returns the relationship filter conditions (AND logic) for user fields. |
| UserFieldsRelationshipFilterAny | Returns the relationship filter conditions (OR logic) for user fields. |
| UserRelatedInformation | Returns counts of tickets, subscriptions, and other items associated with a user. |
| UserSubscriptions | Returns the follow subscriptions between users. |
| ViewsConditionsAll | Returns the AND conditions defined for views. |
| ViewsConditionsAny | Returns the OR conditions defined for views. |
| YourSolvedTicketsThisWeek | Returns the current user's solved tickets for the current week. |