Query Side Conversation Participants in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the connector.

SELECT * FROM SideConversationParticipants WHERE TicketId = 1
SELECT * FROM SideConversationParticipants WHERE TicketId = 1 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
SideConversationId	String	SideConversations.Id	Side Conversation Id.
TicketId	Integer	Tickets.Id	The parent ticket id of the side conversation.
UserId	Long		If the participant is an agent, the agent's user id.
Email	String		The email address of the participant.
Name	String		The name of the participant.
SlackWorkspaceId	String		If the participant is a Slack user or channel, the Slack workspace id.
SlackChannelId	String		If the participant is a Slack channel, the Slack channel id.
SupportGroupId	String		If the participant is a Support ticket, the support group id.
SupportAgentId	String		If the participant is a Support ticket, the support group id.
MSTeamsChannelId	String		If the participant is a Microsoft teams channel, the Teams channel id.