Query Side Conversations events message 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 SideConversationEventsMessage 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
SideConversationEventsId	String	SideConversationEvents.Id	Side Conversation Events Id.
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.
Subject	String		The subject of the message.
PreviewText	String		A plain text string describing the message.
Body	String		The plain text version of the body of the message.
HtmlBody	String		The HTML version of the body of the message.
FromUserId	Long		If the participant is an agent, the agent's user id.
FromEmail	String		The name of the participant.
FromName	String		The email address of the participant.
To	String		The list of participants the message was sent to.
ExternalIds	String		A key-value object where all values are strings. Used for metadata.