ImportSideConversation
Imports a side conversation on the ticket.
Stored Procedure Specific Information
Zendesk allows only a small subset of columns to be used in the Exec query. These columns can typically be used with only = comparison. Allowed for Agents.
For example:
INSERT INTO SideConversationEventsMessageTo#temp(Email) VALUES('[email protected]') INSERT INTO SideConversationEventsMessage#temp(Subject, Body, FromEmail, To) VALUES('Sub', 'xyz', '[email protected]', 'SideConversationEventsMessageTo#temp') INSERT INTO SideConversationEvents#temp(CreatedAt, Message) Values('2023-09-25', SideConversationEventsMessage#temp) EXECUTE ImportSideConversation TicketId = 2, SideConversationSubject = 'SubTest', SideConversationState = 'open', SideConversationEvents = 'SideConversationEvents#temp'
This can also be executed by specifying the SideConversationEvents as a JSON array. For example:
EXECUTE ImportSideConversation TicketId = 2, SideConversationSubject = 'SubTest', SideConversationState = 'open', SideConversationEvents = '[{\"created_at\": \"2023-09-25\", \"message\": {\"from\": {\"email\": \"[email protected]\"}, \"subject\": \"sub\", \"to\": [{\"email\": \"[email protected]\"}], \"body\": \"xyz\"}}]'
Input
Name | Type | Required | Description |
TicketId | Integer | True | The Id of the ticket. |
SideConversationSubject | String | True | Side Conversation Subject. |
SideConversationState | String | False | Side Conversation State. |
SideConversationExternalIds | String | False | Side Conversation ExternalIds. |
SideConversationEvents | String | True | Array of Side Conversation Events. |
Result Set Columns
Name | Type | Description |
Success | String | True if side conversation imported on the ticket successfully. |