ImportSideConversation
Imports a side conversation on a ticket.
Stored Procedure-Specific Information
Zendesk allows only a small subset of columns to be used in the EXEC query. These columns can typically only be used with the = comparison. This operation is allowed for logged-in users with the "agent" role.
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 | The subject of the side conversation. |
| SideConversationState | String | False | The state of the side conversation. |
| SideConversationExternalIds | String | False | The external Ids associated with the side conversation. |
| SideConversationEvents | String | True | The array of events associated with the side conversation. |
Result Set Columns
| Name | Type | Description |
| Success | String | Returns true if the side conversation is imported on the ticket successfully. |