JDBC Driver for Zendesk

Build 24.0.8963

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.

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