JDBC Driver for Zendesk

Build 23.0.8839

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData JDBC Driver for Zendesk ビュー

Name Description
ActivityStream Query ActivityStreams in Zendesk.
AppLocations Query AppLocations 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.
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.
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.
TicketFieldsRelationshipFilterAll Query TicketFields RelationshipFilterAll Filter with Logical AND.
TicketFieldsRelationshipFilterAny Query TicketFields RelationshipFilterAny Filter with Logical OR.
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839