JDBC Driver for Zendesk

Build 24.0.8963

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('[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 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\": \"[email protected]\"}, \"subject\": \"Sub\", \"to\": [{\"email\":\"[email protected]\"}], \"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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963