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 connector.

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.