Tables
The adapter models the data in Zendesk into a list of tables that can be queried using standard SQL statements.
Generally, querying Zendesk tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Zendesk Adapter Tables
| Name | Description |
| AccountSettings | Query and update Account Settings in Zendesk. |
| Automations | Create, update, delete, and query Automations in Zendesk. |
| Brands | Create, delete, update, and query Brands in Zendesk. |
| CustomObjects | Create, delete, update, and query Custom Objects in Zendesk. |
| GroupMemberships | Create, delete, and query Group Memberships in Zendesk. |
| Groups | Create, update, delete, and query Groups 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. |
| 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. |
| Sessions | Query and delete Sessions in Zendesk. |
| SharingAgreements | Create, update, delete, and query SharingAgreements in Zendesk. |
| SupportAddresses | Create, update, delete, and query Support Addresses in Zendesk. |
| SuspendedTickets | Query and delete Suspended Tickets in Zendesk. |
| TicketFields | Create, update, delete, and query TicketFields in Zendesk. |
| TicketForms | Create, update, delete, and query Ticket Forms in Zendesk. |
| Tickets | Create, update, delete, and query Tickets. |
| Topics | Query, Insert, Update and Delete Topics 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. |
| Views | Query and delete Views in Zendesk. |