Represents community posts, including authoring, status, and topic details.

Table-Specific Information

Select

The provider uses the Zendesk API to process WHERE clause conditions built with the following columns and operators:

• Id supports the = operator.
• AuthorId supports the = operator.
• Status supports the = operator.
• TopicId supports the = operator.

For example, the following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM Posts WHERE Id = '20414795537308'

SELECT * FROM Posts WHERE AuthorId = '9634283960860'

SELECT * FROM Posts WHERE TopicId = '30235845457170'

SELECT * FROM Posts WHERE Status = 'Completed'

Insert

The following columns are required to insert: Title and TopicId.

INSERT INTO Posts (Title, TopicId) VALUES ('Testing Post', '31393270716957')

You can also optionally include the Status column:

INSERT INTO Posts (Title, TopicId, Status) VALUES ('Testing Post', '31393270716957', 'answered')

Update

The following is an example of how to update the Posts table:

UPDATE Posts SET Title = 'Update test' WHERE Id = 31499940221341

Delete

You must specify the Id of the post to delete it.

DELETE FROM Posts WHERE Id = 20414746040732

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The unique Id 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	Long	False		The Id of the author of the post. Writable on create by Help Center managers.
Pinned	Boolean	False		Indicates whether the post is pinned to the top of its topic.
Featured	Boolean	False		Indicates whether the post is featured.
Closed	Boolean	False		Indicates whether further comments are allowed on the post.
Status	String	False		The status of the post. Possible filter values include planned, not_planned, completed, answered or none.
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	Topics.Id	The Id of the topic that the post belongs to.
CreatedAt	Datetime	True		The date and time when the post was created.
UpdatedAt	Datetime	True		The date and time when the post was last updated.