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 |