Zendesk Tables

Tables

ZendeskBrands

Stores Zendesk brand configurations including help center state, subdomain, logo details, and associated ticket forms for multi-brand support accounts.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the brand.
URL	string	API URL of the brand resource.
Name	string	Display name of the brand.
BrandURL	string	Public-facing URL of the brand's help center or website.
HasHelpCenter	boolean	Indicates whether the brand has a Help Center enabled.
HelpCenterState	string	State of the brand's Help Center (e.g., `enabled`, `disabled`, `restricted`).
Active	boolean	Indicates whether the brand is currently active.
Default	boolean	Indicates whether this is the default brand for the Zendesk account.
IsDeleted	boolean	Indicates whether the brand has been deleted.
HostMapping	string	Custom host mapping for the brand's Help Center domain.
Subdomain	string	Zendesk subdomain associated with the brand.

ZendeskGroupMemberships

Records agent-to-group membership associations in Zendesk, indicating which groups each agent belongs to and which is their default group.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the group membership record.
URL	string	API URL of the group membership resource.
ZendeskUserID	integer	Identifier of the Zendesk user who is a member of the group.
ZendeskGroupID	integer	Identifier of the Zendesk group the user belongs to.
Default	boolean	Indicates whether this group is the user's default group for ticket assignment.
CreatedAt	datetime	Timestamp indicating when the group membership was created.
UpdatedAt	datetime	Timestamp indicating when the group membership was last updated.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZendeskGroups

Contains Zendesk group definitions used to organize agents and route ticket assignments, including public visibility and default group status.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the group.
URL	string	API URL of the group resource.
Name	string	Display name of the group.
Description	string	Description of the group's purpose or function.
Default	boolean	Indicates whether this is the default group for the Zendesk account.
Deleted	boolean	Indicates whether the group has been deleted.
IsPublic	boolean	Indicates whether the group is publicly visible to end-users.
CreatedAt	datetime	Timestamp indicating when the group was created.
UpdatedAt	datetime	Timestamp indicating when the group was last updated.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZendeskIntegrations

Integration summary table listing all Zendesk integration configurations with authentication credentials, subdomain, and enablement metadata.

Name	Type	Description
ID	integer	Auto-incremented primary key for the Zendesk integration configuration record.
Name	string	Display name of the Zendesk integration configuration.
CreatedDate	datetime	Timestamp indicating when the integration configuration was created.
ModifiedDate	datetime	Timestamp indicating when the integration configuration was last modified.
CreatedBy	string	Username or identifier of the user who created the integration configuration.
ModifiedBy	string	Username or identifier of the user who last modified the integration configuration.
IsEnabled	boolean	Indicates whether the integration configuration is currently active and enabled.
Email	string	Email address used to authenticate with the Zendesk API for this integration.
IntegrationID	integer	Numeric identifier linking this record to the associated Zendesk integration instance.
Subdomain	string	Zendesk subdomain used for API requests in this integration configuration.

ZendeskOrganizationMemberships

Records user-to-organization membership associations in Zendesk, indicating which organizations each user belongs to and their default organization.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the organization membership record.
URL	string	API URL of the organization membership resource.
ZendeskUserID	integer	Identifier of the Zendesk user who is a member of the organization.
ZendeskOrganizationID	integer	Identifier of the Zendesk organization the user belongs to.
Default	boolean	Indicates whether this is the user's default organization.
OrganizationName	string	Display name of the organization associated with the membership.
ViewTickets	boolean	Indicates whether the user can view all tickets belonging to the organization.
CreatedAt	datetime	Timestamp indicating when the organization membership was created.
UpdatedAt	datetime	Timestamp indicating when the organization membership was last updated.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZendeskOrganizations

Stores Zendesk organization records including shared ticket and comment settings, associated domain names, custom fields, and default group assignments.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the organization.
URL	string	API URL of the organization resource.
Name	string	Display name of the organization.
SharedTickets	boolean	Indicates whether users in the organization can view each other's tickets.
SharedComments	boolean	Indicates whether users in the organization can view each other's ticket comments.
ExternalID	string	External identifier for the organization, used for mapping to external systems.
DomainNamesSerialized	string	Serialized list of email domain names associated with the organization (e.g., `example.com`, `test.com`).
Details	string	Additional details or notes about the organization visible to agents.
Notes	string	Internal notes about the organization visible only to agents and admins.
GroupID	integer	Identifier of the default group to which tickets from this organization are assigned.
TagsSerialized	string	Serialized list of tags automatically applied to tickets submitted by users in this organization.

ZendeskSecuritySettings

Contains the Zendesk account-wide security configuration, including session timeouts, password policies, SSO settings, IP restrictions, and authentication options for both agents and end-users.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	uniqueidentifier	Unique identifier for the security settings record.
AdminsCanSetUserPasswords	boolean	Indicates whether administrators are permitted to set passwords on behalf of users.
AgentSessionTimeout	integer	Duration in minutes before an inactive agent session is automatically expired.
Assumable	boolean	Indicates whether account assumption (impersonation by Zendesk staff) is enabled for this account.
AssumableAccountType	boolean	Indicates the account type that is permitted to be assumed.
AssumptionDuration	string	Duration for which an account assumption session remains valid.
AssumptionExpiration	string	Timestamp or period after which the account assumption permission expires.
CSPBlockingEnabled	boolean	Indicates whether Content Security Policy (CSP) blocking is enabled for the account.
EmailAgentWhenSensitiveFieldsChanged	boolean	Indicates whether agents receive an email notification when sensitive ticket fields are changed.
EndUserSessionTimeout	integer	Duration in minutes before an inactive end-user session is automatically expired.
MaximumSessionDuration	integer	Maximum allowed session duration in minutes before forced re-authentication.

ZendeskTicketAuditEvents

Records individual events within Zendesk ticket audits, capturing comments, field changes, notifications, and satisfaction ratings with full before/after values and author context.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the ticket audit event.
ZendeskTicketAuditID	integer	Identifier of the parent ticket audit record this event belongs to.
Type	string	Type of audit event (e.g., `Comment`, `Change`, `Create`, `Notification`, `SatisfactionRating`).
AuthorID	integer	Identifier of the user who authored this audit event.
Body	string	Plain-text body of a comment audit event.
HTMLBody	string	HTML-formatted body of a comment audit event.
PlainBody	string	Stripped plain-text version of the comment body, without HTML markup.
IsPublic	boolean	Indicates whether the comment is public (visible to the requester) or an internal note.
FieldName	string	Name of the ticket field that was changed in a Change-type audit event.
ValueSerialized	string	Serialized new value of the field after the change was applied.
PreviousValueSerialized	string	Serialized previous value of the field before the change was applied.

ZendeskTicketAuditMetadata

Stores system metadata associated with Zendesk ticket audits, including the originating IP address, geographic location, and custom metadata fields.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ZendeskTicketAuditID	integer	Identifier of the ticket audit record this metadata is associated with.
SystemClient	string	HTTP client or user agent string of the system that performed the audited action.
SystemIPAddress	string	IP address of the system from which the audited action originated.
SystemLocation	string	Geographic location associated with the IP address of the audited action.
SystemLatitude	float	Latitude coordinate of the geographic location of the audited action.
SystemLongitude	float	Longitude coordinate of the geographic location of the audited action.
CustomSerialized	string	Serialized custom metadata key-value pairs associated with the ticket audit.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZendeskTicketAudits

Contains Zendesk ticket audit records representing each change or interaction on a ticket, linking the audit to its parent ticket, author, and originating channel.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the ticket audit.
ZendeskTicketID	integer	Identifier of the ticket this audit record belongs to.
AuthorID	integer	Identifier of the user who triggered or authored the ticket audit.
ViaChannel	string	Channel through which the audit was created (e.g., `web`, `email`, `api`, `chat`).
CreatedAt	datetime	Timestamp indicating when the ticket audit was created.
BatchDate	datetime	Timestamp indicating when the record was ingested or last refreshed by the integration.

ZendeskTickets

Primary table of Zendesk support tickets, capturing full ticket details including status, priority, type, requester, assignee, satisfaction rating, tags, custom fields, and channel information.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the ticket.
URL	string	API URL of the ticket resource.
ExternalID	string	External identifier for the ticket, used for mapping to external systems.
Type	string	Type of the ticket (e.g., `problem`, `incident`, `question`, `task`).
Subject	string	Subject line of the ticket.
RawSubject	string	Raw, unprocessed subject of the ticket, which may contain dynamic content placeholders.
Description	string	First comment or description of the ticket, provided by the requester.
Priority	string	Priority level of the ticket (e.g., `urgent`, `high`, `normal`, `low`).
Status	string	Current status of the ticket (e.g., `new`, `open`, `pending`, `hold`, `solved`, `closed`).
Recipient	string	Email address of the recipient to whom the ticket was originally sent.
RequesterID	integer	Identifier of the user who submitted or is associated with the ticket request.

ZendeskTriggers

Stores Zendesk trigger definitions including conditions and actions used to automatically update tickets when events occur, along with category, position, and brand scope.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the trigger.
URL	string	API URL of the trigger resource.
Title	string	Display title of the trigger.
Active	boolean	Indicates whether the trigger is currently active and will fire when conditions are met.
Default	boolean	Indicates whether this is a default system trigger provided by Zendesk.
Description	string	Description of the trigger's purpose and behavior.
Position	integer	Numeric position of the trigger in the ordered list of triggers, determining evaluation order.
ConditionsSerialized	string	Serialized set of conditions (all/any) that must be met for the trigger to fire.
ActionsSerialized	string	Serialized list of actions the trigger performs when its conditions are satisfied.
RawTitle	string	Raw, unprocessed title of the trigger, which may contain dynamic content placeholders.
CategoryID	string	Identifier of the trigger category used to organize triggers in the admin interface.

ZendeskUsers

Contains Zendesk user account records for agents, admins, and end-users, including role, contact details, authentication settings, organization membership, and custom field values.

Name	Type	Description
ConfigID	integer	Unique identifier linking the record to a specific Zendesk integration configuration.
ID	integer	Unique Zendesk-generated identifier for the user.
URL	string	API URL of the user resource.
Name	string	Full display name of the user.
Email	string	Primary email address of the user.
Role	string	Role of the user in Zendesk (e.g., `end-user`, `agent`, `admin`).
TicketRestriction	string	Scope of tickets the user can access (e.g., `organization`, `groups`, `assigned`, `requested`).
Active	boolean	Indicates whether the user account is currently active.
Alias	string	Alias displayed to end-users in place of the agent's real name.
ChatOnly	boolean	Indicates whether the user is a chat-only agent with no access to ticketing.
CustomRoleID	integer	Identifier of the custom agent role assigned to the user on Enterprise plans.
DefaultGroupID	integer	Identifier of the user's default group for ticket assignment.