ImportSideConversationEvents
Imports events to an existing side conversation.
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('ym@gmail.com')
INSERT INTO SideConversationEventsMessage#temp(Subject, Body, FromEmail, To) VALUES('Sub', 'xyz', 'someone@example.com', 'SideConversationEventsMessageTo#temp')
INSERT INTO SideConversationEvents#temp(CreatedAt, Message) Values('2023-09-25', SideConversationEventsMessage#temp)
EXECUTE ImportSideConversationEvents TicketId = 2, SideConversationId = 'e1607e37-5779-11ee-a0bc-b1395906e603', SideConversationEvents = 'SideConversationEvents#temp'
This can also be executed by specifying the SideConversationEvents as a JSON array. For example:
EXECUTE ImportSideConversationEvents TicketId = 2, SideConversationId = 'e1607e37-5779-11ee-a0bc-b1395906e603', SideConversationEvents = '[{\"created_at\": \"2023-09-25\", \"message\": {\"from\":{\"email\": \"someone@example.com\"}, \"subject\": \"Sub\", \"to\": [{\"email\":\"ym@gmail.com\"}], \"body\": \"xyz\"}}]'
Input
| Name | Type | Required | Description |
| TicketId | Integer | True | The Id of the ticket. |
| SideConversationId | String | True | Side Conversation Id. |
| 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. |