TDV Adapter for Zendesk

Build 21.0.8137


Query TicketComments belonging to a specified ticket in Zendesk.

Table Specific Information


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.


Name Type References 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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137