JDBC Driver for Zendesk

Build 20.0.7587


Query, Insert, Update and Delete Posts in Zendesk.


Name Type ReadOnly Description
Id [KEY] Long True

Automatically assigned when the post is created.

Url String True

The API url of the post.

HtmlUrl String True

The community url of the post.

Title String False

The title of the post.

Details String False

The details of the post.

AuthorId Integer True

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

Pinned Boolean False

When true, pins the post to the top of its topic.

Featured Boolean False

Whether the post is featured.

Closed Boolean False

Whether further comments are allowed.

Status String False

The status of the post. Possible values:

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.

CommentCount Integer True

The number of comments on the post.

FollowerCount Integer True

The number of followers of the post.

TopicId Long False

The id of the topic that the post belongs to.

CreatedAt Datetime True

The time the post was created.

UpdatedAt Datetime True

The time of the last update of the post.


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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587