JDBC Driver for Zendesk

Build 24.0.8963

SideConversationEvents

Query Side Conversations events in Zendesk. The messages that make up a side conversation are recorded as events.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the 本製品.
SELECT * FROM SideConversationEvents WHERE TicketId = 2 AND SideConversationId = '5d133b65-576c-11ee-bcb2-bdce8f618e59'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name Type References Description
Id [KEY] String Automatically assigned when the event is created.
TicketId Integer

Tickets.Id

The parent ticket id of the side conversation.
SideConversationId String

SideConversations.Id

The id of the side conversation the event belongs to.
ActorEmail String The email address of the participant.
ActorName String The name of the participant.
ActorUserId Long If the participant is an agent, the agent's user id.
ActorSlackWorkspaceId String If the participant is a Slack user or channel, the Slack workspace id.
ActorSlackChannelId String If the participant is a Slack channel, the Slack channel id.
ActorSupportGroupId String If the participant is a Support ticket, the support group id.
ActorSupportAgentId String If the participant is a Support ticket, the support agent id.
ActorMSTeamsChannelId String If the participant is a Microsoft teams channel, the Teams channel id.
Message String Events of type create and reply have a message.
CreatedAt Datetime The time the side conversation event was created.
Type String The type of event.
Updates String Events of type update have fields here.
via String The channel used when creating the event.
Url String The API url of the side conversation.

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