JDBC Driver for Zendesk

Build 22.0.8462

Articles

Show Acticles in Zendesk.

Columns

Name Type References Description
Id [KEY] Long Automatically assigned when the article is created
AuthorId Long The id of the user who wrote the article (set to the user who made the request on create by default)
Body String HTML body of the article. Unsafe tags and attributes may be removed before display. For a list of safe tags and attributes, see Allowing unsafe HTML in Help Center articles in Zendesk help
CommentsDisabled Boolean True if comments are disabled; false otherwise
CreatedAt String The time the article was created
Draft Boolean True if the translation for the current locale is a draft; false otherwise. false by default. Can be set when creating but not when updating. For updating, see Translations
EditedAt String The time the article was last edited in its displayed locale
HtmlUrl String The url of the article in Help Center
LabelNames String An array of label names associated with this article. By default no label names are used. Only available on certain plans
Locale String The locale that the article is being displayed in
Outdated Boolean Deprecated. Always false because the source translation is always the most up-to-date translation
OutdatedLocales String Locales in which the article was marked as outdated
PermissionGroupId Long The id of the permission group which defines who can edit and publish this article
Position Integer The position of this article in the article list. 0 by default
Promoted Boolean True if this article is promoted; false otherwise. false by default
SectionId Long The id of the section to which this article belongs
SourceLocale String The source (default) locale of the article
Title String The title of the article
UpdatedAt String The time the article was last updated
Url String The API url of the article
UserSegmentId Long The id of the user segment which defines who can see this article. Set to null to make it accessible to everyone
VoteCount Integer The total number of upvotes and downvotes
VoteSum Integer The sum of upvotes (+1) and downvotes (-1), which may be positive or negative

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
CategoryId Long Id of the categories
UserId Long Id of author
StartTime Long Start Time

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