JDBC Driver for Zendesk

Build 22.0.8462

PostComments

Query, Insert, Update and Delete PostComments in Zendesk.

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned when the comment is created.

Url String True

The API url of the comment.

HtmlUrl String True

The community url of the comment.

Body String False

The comment made by the author.

AuthorId Long True

The id of the author of the comment. *Writable on create by Help Center managers.

PostId Long True

Posts.Id

The id of the post on which the comment was made.

Official Boolean False

Whether the comment is marked as official.

VoteSum Integer True

The sum of upvotes (+1) and downvotes (-1), which may be positive or negative.

VoteCount Integer True

The total number of upvotes and downvotes.

CreatedAt Datetime True

The time the post was created.

UpdatedAt Datetime True

The time of the last update of the post.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
FilterBy String

May be planned, not_planned, completed, answered or none.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462