JDBC Driver for Zendesk

Build 22.0.8462

Tables

The driver 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.

CData JDBC Driver for Zendesk 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462