ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData Excel Add-In for Zendesk ビュー
| Name | Description |
| AccessLogs | Query access logs in Zendesk. |
| ActivityStream | Query ActivityStreams in Zendesk. |
| AppLocations | Query AppLocations in Zendesk. |
| Apps | Query Apps in Zendesk. |
| Attachments | Show ticket attachments in Zendesk. |
| AuditLogs | Query audit logs in Zendesk. |
| Calls | A complete list of information on inbound and outbound calls from your Zendesk Talk instance. |
| Collaborators | Query Collaborators 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. |
| OrganizationFieldsRelationshipFilterAll | Query OrganizationFields RelationshipFilterAll Filter with Logical AND. |
| OrganizationFieldsRelationshipFilterAny | Query OrganizationFields RelationshipFilterAny Filter with Logical OR. |
| Requests | Query Requests in Zendesk. |
| Requests_Collaborators | The Collaborator ids of users currently CC'ed on the ticket. |
| ResourceCollections | Query Resource Collections in Zendesk. |
| SatisfactionReasons | Query the Satisfaction Reasons in Zendesk. |
| SideConversationEvents | Query Side Conversations events in Zendesk. The messages that make up a side conversation are recorded as events. |
| SideConversationEventsMessage | Query Side Conversations events message in Zendesk. |
| SideConversationEventsMessageTo | Query the list of participants, the message was sent to. |
| SideConversationParticipants | Query Side Conversation Participants in Zendesk. |
| SlaPoliciesFilterAll | Query SlaPolicies Filter with Logical AND. |
| SlaPoliciesFilterAny | Query SlaPolicies Filter with Logical OR. |
| SlaPoliciesMetrics | Query SlaPoliciesMetrics that describes the metric targets for each value of the priority field. |
| TargetFailures | Query Target failures in Zendesk. |
| TicketEmailCCs | Query any users cc'd on the ticket in Zendesk. |
| TicketFieldsRelationshipFilterAll | Query TicketFields RelationshipFilterAll Filter with Logical AND. |
| TicketFieldsRelationshipFilterAny | Query TicketFields RelationshipFilterAny Filter with Logical OR. |
| TicketRelatedInformation | Query Ticket related information in Zendesk. |
| UserEvents | Query events for a given Zendesk user. |
| UserFieldsRelationshipFilterAll | Query UserFields RelationshipFilterAll Filter with Logical AND. |
| UserFieldsRelationshipFilterAny | Query UserFields RelationshipFilterAny Filter with Logical OR. |
| UserRelatedInformation | Query UserRelatedInformation in Zendesk. |
| UserSubscriptions | Query the user subscriptions in Zendesk. |
| ViewsConditionsAll | Query views conditions with logical AND. |
| ViewsConditionsAny | Query views conditions with logical OR. |