ODBC Driver for Zendesk

Build 23.0.8839

SideConversationParticipants

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 本製品.
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.

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