Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for Zendesk Views
| Name | Description |
| ActivityStream | Query ActivityStreams in Zendesk. |
| AppLocations | Query AppLocations in Zendesk. |
| ArticleAttachments | Show Acticle Attachment in Zendesk. |
| Articles | Show Acticles in Zendesk. |
| Attachments | Show ticket attachments in Zendesk. |
| Calls | A complete list of information on inbound and outbound calls from your Zendesk Talk instance |
| Collaborators | Query Collaborators in Zendesk. |
| CustomAgentRoles | Query CustomAgentRoles in Zendesk. |
| CustomObjectField | The view specifies all the attributes of a custom object property. |
| JobStatus | A status record is created when somebody kicks off a job such as updating multiple tickets. You can access the job status data for an hour after a particular job is created, after which the data is no longer available. |
| Locales | Query Locales in Zendesk. |
| MonitoredTwitterHandles | Query Monitored Twitter handles in Zendesk. |
| Requests | Query Requests in Zendesk. |
| Requests_Collaborators | The Collaborator ids of users currently CC'ed on the ticket. |
| SlaPolicies | Query SlaPolicies in Zendesk. |
| TicketAudits | Query TicketAudits in Zendesk. |
| TicketComments | Query TicketComments belonging to a specified ticket in Zendesk. |
| TicketMetricEvents | Query TicketMetricEvents in Zendesk. |
| TicketMetrics | Query TicketMetrics in Zendesk. |
| Tickets_Collaborators | The Collaborator id of users currently CC'ed on the ticket. |
| Tickets_Followers | The ids of agents currently following the ticket |
| Tickets_Followups | The ids of the followups created from ticket. |
| Tickets_Macros | List of macros to be recorded in the ticket audit. |
| Tickets_SatisfactionRatings | The satisfaction rating of the ticket, if it exists, or the state of satisfaction. |
| Tickets_SharingAgreements | The sharing agreements used for ticket. |
| Tickets_Tags | The tags applied to the ticket |
| Tickets_Viasources | List ViaSources for the Ticket. |
| UserRelatedInformation | Query UserRelatedInformation in Zendesk. |