BizTalk Adapter for Zendesk

Build 20.0.7587

TicketComments

Query TicketComments belonging to a specified ticket in Zendesk.

Table Specific Information

Select

The Ticket Id is required to query this view. The following queries are processed server side.

SELECT * FROM TicketComments

SELECT * FROM TicketComments WHERE TicketId='123'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type Description
Id [KEY] Long Automatically assigned when the ticket is created.
TicketId Integer The id of the ticket the comment belongs to.
AuthorId Long The id of the comment author.
Type String Comment or VoiceComment.
Body String The comment string.
CreatedAt Datetime The time the comment was created.
HtmlBody String The comment formatted as HTML.
PlainBody String The comment as plain text.
IsPublic Boolean True if a public comment; false if an internal note. The initial value set on ticket creation persists for any additional comment unless you change it.
ViaChannel String This tells you how the ticket or event was created. Examples: 'web', 'mobile', 'rule', 'system'.
ViaSource String .
MetadataCustom String .
MetadataSystemClient String .
MetadataSystemIpAddres String .
MetadataSystemLatitude String .
MetadataSystemLongitude String .
MetadataSystemLocation String .

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587