テーブル
本製品 はZendesk のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。
CData Cmdlets PowerShell Module for Zendesk テーブル
| Name | Description |
| AccountSettings | Query and update Account Settings in Zendesk. |
| ArticleAttachments | Query and Delete Acticle Attachment in Zendesk. |
| ArticleComments | Create, Update, Delete and Query the Article Comments in Zendesk. |
| ArticleLabels | Create, delete, and query Article Labels in Zendesk. |
| Articles | Create, Update, Archive and query Acticles in Zendesk. |
| ArticleTranslations | Create, Update, Delete and Query the Translations for Articles in Zendesk. |
| Attributes | Create, Update, Delete and Query the Attributes in Zendesk. An attribute in Zendesk refers to a skill type. Skill types are categories of skills. |
| AttributeValues | Create, Update, Delete and Query the Attribute Values in Zendesk. An attribute value in this API refers to a skill. Skills are associated with an agent and determine the agent's suitability to solve a ticket. |
| Automations | Create, update, delete, and query Automations in Zendesk. |
| Bookmarks | Create, Delete and Query the Bookmarks in Zendesk. |
| Brands | Create, delete, update, and query Brands in Zendesk. |
| Categories | Create, update, delete, and query Categories in Zendesk. |
| CategoryTranslations | Create, Update, Delete and Query the Translations for Categories in Zendesk. |
| ContentSubscriptions | Create, Update, Delete and Query the Content Subscriptions in Zendesk. Users can subscribe to sections, articles, community posts, and community topics. |
| ContentTags | Create, Update, Delete and Query the Content Tags in Zendesk. |
| CustomAgentRoles | Create, Update, Delete and Query CustomAgentRoles in Zendesk. |
| CustomObjects | Create, delete, update, and query Custom Objects in Zendesk. |
| CustomTicketStatuses | Create, update, and query custom ticket statuses in zendesk. |
| GroupMemberships | Create, delete, and query Group Memberships in Zendesk. |
| Groups | Create, update, delete, and query Groups in Zendesk. |
| GroupSlaPolicies | Create, Update, Delete and Query Group SLA Policies in Zendesk. |
| Holidays | Create, update, delete, and query Schedules in Zendesk. |
| JiraLinks | View and create links between your Jira and Zendesk instances. |
| Macros | Create, update, delete, and query Macros in Zendesk. |
| ManagementPermissionGroups | Create, Update, Delete and Query the Management Permission Groups in Zendesk. A management permission group defines which agents can create, update, archive, and publish articles. It consists of a set of privileges, each of which is mapped to a user segment. Agents receive whichever privileges are associated with the user segments they belong to. |
| OrganizationFields | Create, update, delete, and query Organization Fields in Zendesk. |
| OrganizationMemberships | Create, delete, and query Organization Memberships in Zendesk. |
| Organizations | Create, delete, update, and query Organizations in Zendesk. |
| OrganizationSubscriptions | Create, delete, and query Organization Subscriptions in Zendesk. |
| PostComments | Query, Insert, Update and Delete PostComments in Zendesk. |
| Posts | Query, Insert, Update and Delete Posts in Zendesk. |
| SatisfactionRatings | Create and query Requests in Zendesk. |
| Schedules | Create, update, delete and query Schedules in Zendesk. |
| Sections | Create, update, delete, and query Sections in Zendesk. |
| SectionTranslations | Create, Update, Delete and Query the Translations for Sections in Zendesk. |
| Sessions | Query and delete Sessions in Zendesk. |
| SharingAgreements | Create, update, delete, and query SharingAgreements in Zendesk. |
| SideConversations | Create, update and query Side Conversations in Zendesk. |
| SlaPolicies | Create, update, delete, and query SlaPolicies in Zendesk. |
| SupportAddresses | Create, update, delete, and query Support Addresses in Zendesk. |
| SuspendedTickets | Query and delete Suspended Tickets in Zendesk. |
| Targets | Create, Update, Delete and Query Targets in Zendesk. |
| TicketAudits | Query TicketAudits in Zendesk. |
| TicketComments | Query TicketComments belonging to a specified ticket in Zendesk. |
| TicketEvents | Query TicketEvents in Zendesk. |
| TicketFields | Create, update, delete, and query TicketFields in Zendesk. |
| TicketForms | Create, update, delete, and query Ticket Forms in Zendesk. |
| TicketMetricEvents | Queries TicketMetricEvents in Zendesk. |
| TicketMetrics | Query TicketMetrics in Zendesk. |
| Tickets | Create, update, delete, and query Tickets. |
| TicketSkips | Create and Query the TicketSkips in Zendesk. A skip is a record 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 | 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. |
| Topics | Query, Insert, Update and Delete Topics in Zendesk. |
| Translations | Create, Update, Delete and Query the Translations in Zendesk. This table is deprecated, and is being replaced by the ArticleTranslations, CategoryTranslations, and SectionTranslations tables. |
| TriggerCategories | Create, update, delete, and query Trigger Categories in Zendesk. |
| Triggers | Create, update, delete, and query Triggers in Zendesk. |
| UserFields | Create, update, delete, and query User Fields. |
| UserIdentities | Create, update, delete, and query User Identities. |
| Users | Create, update, delete, and query Users in Zendesk. |
| UserSegments | Create, Update, Delete and Query the User Segments in Zendesk. A user segment defines who can view the content of a section or topic. |
| Views | Create, update, delete and query views in Zendesk. |
| Votes | Create, Delete and Query the Votes in Zendesk. Votes represents positive and negative opinions of users about articles, article comments, posts or post comments. |