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