Posts

Create,Update,List and Delete the Posts for the WordPressOnline website.

Table Specific Information

SELECT

The provider uses the WordPress API to process some of the filters.

Id supports the '=' comparison.
AuthorId supports the '=' comparison.
Date supports the '<', '>' comparisons.
Modified supports the '<', '>' comparisons.
Slug supports the '=' comparison.
Status supports the '=' comparison.
Sticky supports the '=' comparison.
Type supports the '=' comparison.

The provider processes other filters client-side within the provider.

For example, the following queries are processed server side.

SELECT * FROM Posts
SELECT * FROM Posts WHERE ID=21

Insert

To insert a post :

INSERT INTO Posts (Title, Content, Excerpt) VALUES ('Post title', 'Post content', 'Post Excerpt')

Update

To update a post you must specify the following column: ID.

UPDATE Posts SET  Title= 'Modified post title', Content = 'Modified content', Excerpt = 'Modified excerpt' WHERE ID = 21

Delete

To delete a post you must specify the following column: ID.

DELETE FROM Posts WHERE ID = 21

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	Int	False		The unique identifier of the post.
SiteID	Int	False		The unique identifier of the WordPress site that the post belongs to.
AuthorAvatarURL	String	False		The URL of the author's profile avatar image.
IsAuthorEmailAvailable	Boolean	False		Indicates whether the author's email address is available.
AuthorFirstName	String	False		The first name of the post's author.
AuthorID	Int	False		The unique identifier of the author who created the post.
AuthorLastName	String	False		The last name of the post's author.
AuthorLogin	String	False		The author's WordPress username used to log in.
AuthorName	String	False		The display name of the post's author.
AuthorNiceName	String	False		The URL-friendly version of the author's username.
AuthorProfileURL	String	False		The URL of the author's public WordPress profile page.
AuthorSiteID	Int	False		The site ID associated with the author.
AuthorURL	String	False		The personal website URL provided by the author, if any.
Date	Datetime	False		The date and time when the post was created in the site's local timezone.
Modified	Datetime	False		The date and time when the post was last updated.
Title	String	False		The title of the post as displayed on the site.
ItemURL	String	False		The full permalink URL of the post.
ShortURL	String	False		The wp.me shortlink that provides a shortened version of the post URL.
Content	String	False		The full HTML content of the post.
Excerpt	String	False		A short excerpt or summary of the post content.
Slug	String	False		The URL-friendly slug used to identify the post.
Guid	String	False		The globally unique identifier (GUID) for the post, often representing its original permalink.
Status	String	False		The publication status of the post, such as publish, draft, pending, private, future, trash, or auto-draft. The allowed values are publish, private, draft, pending, future, trash, any.
IsSticky	Boolean	False		Indicates whether the post is marked as sticky and displayed at the top of the blog.
Password	String	False		The plaintext password used to protect the post, or an empty string if the post is not password-protected.
HasParent	Boolean	False		Indicates whether the post has a parent post (for example, a child page).
Type	String	False		The post type for this entry, such as post, page, or a custom post type allowed by the REST API.
DiscussionCommentCount	Int	False		The total number of comments associated with the post.
DiscussionCommentStatus	String	False		Indicates the current comment status for the post, such as open or closed.
HasDiscussionCommentsOpen	Boolean	False		Indicates whether new comments can be added to the post.
DiscussionPingStatus	String	False		Shows whether pingbacks and trackbacks are enabled for the post.
HasDiscussionPingsOpen	Boolean	False		Indicates whether the post accepts pingbacks.
HasLikesEnabled	Boolean	False		Indicates whether likes are enabled for the post.
HasSharingEnabled	Boolean	False		Indicates whether sharing buttons are enabled for the post.
LikeCount	Int	False		The total number of likes that the post has received.
ILike	Boolean	False		Indicates whether the authenticated user has liked the post.
IsFollowing	Boolean	False		Indicates whether the authenticated user is following the site where the post appears.
IsReblogged	Boolean	False		Indicates whether the authenticated user has reblogged this post.
GlobalID	String	False		A globally unique identifier representing the post across the entire WordPress.com network.
FeaturedImage	String	False		The URL of the post's featured image, if one is set.
PostThumbnail	String	False		The attachment object representing the featured image, if available.
Format	String	False		The display format of the post, such as standard, aside, gallery, image, quote, status, video, or audio.
HasGeo	Boolean	False		Indicates whether the post includes geolocation data.
MenuOrder	Int	False		Defines the order of pages or hierarchical posts in navigation menus.
PageTemplate	String	False		The page template assigned to this post or page.
PublicizeURLsAggreagtes	String	False		A list of URLs where the post was automatically shared via Publicize connections, such as Facebook or Twitter.
CategoriesAggregates	String	False		A set of categories, organized by name, that are assigned to the post.
TermsCategoryAggregates	String	False		A collection of taxonomy terms grouped by category name and keyed by term name.
TermsPostTagAggregates	String	False		A collection of taxonomy terms grouped by post tags and keyed by tag name.
TermsPostFormatAggregates	String	False		A collection of taxonomy terms grouped by post format and keyed by format name.
TermsMentionsAggregates	String	False		A collection of taxonomy terms related to user or site mentions in the post.
TagsAggregates	String	False		A set of tags, organized by tag name, that are applied to the post.
Attachments	String	False		A collection of post attachments organized by attachment ID. It returns up to 20 of the most recent attachments.
AttachmentCount	Int	False		The total number of attachments associated with the post.
MetadataAggregates	String	False		An array of key-value pairs representing the post's custom metadata fields.
HasCapabilitiesDeletePost	Boolean	False		Indicates whether the authenticated user has permission to delete the post.
HasCapabilitiesEditPost	Boolean	False		Indicates whether the authenticated user has permission to edit the post.
HasCapabilitiesPublishPost	Boolean	False		Indicates whether the authenticated user has permission to publish the post.