SitePosts
List the UserSitesPosts for the WordPressOnline website.
Table Specific Information
SELECT
The connector uses the WordPress API to process some filters. Other filters are processed client-side within the connector.
For example, the following query is processed server side:
SELECT * FROM SitePosts WHERE ID=1
Columns
| Name | Type | References | Description |
| ID [KEY] | Int |
Posts.Id | The unique identifier of the post. |
| SiteID | Int |
Sites.Id | The unique identifier of the site where the post is published. |
| AuthorID | Int | The unique identifier of the post author. | |
| IsAuthorEmailAvailable | Boolean | Indicates whether the author's email address is available. | |
| AuthorLogin | String | The author's WordPress.com login name. | |
| AuthorName | String | The full display name of the post author. | |
| AuthorAvatarURL | String | The URL of the author's avatar image. | |
| AuthorFirstName | String | The first name of the post author. | |
| AuthorLastName | String | The last name of the post author. | |
| AuthorNiceName | String | A URL-friendly version of the author's username. | |
| AuthorProfileURL | String | The URL of the author's WordPress.com profile page. | |
| AuthorSiteID | Int | The ID of the author's WordPress.com site. | |
| AuthorURL | String | The URL of the author's external or personal website. | |
| HasAuthoravatar | Boolean | Indicates whether the author has an avatar image. | |
| AuthorWpcomId | Int | The unique WordPress.com user ID of the author. | |
| AuthorWpcomLogin | String | The author's WordPress.com username. | |
| Date | Datetime | The date and time when the post was originally created. | |
| Modified | Datetime | The date and time when the post was last updated. | |
| Title | String | The title of the post. | |
| ItemURL | String | The full permalink URL to the post. | |
| ShortURL | String | The WordPress shortlink (wp.me) version of the post URL. | |
| Content | String | The complete content body of the post. | |
| Excerpt | String | A short excerpt or summary of the post content. | |
| Slug | String | The slug used to identify the post in URLs. | |
| Guid | String | The globally unique identifier for the post. | |
| Status | String | The current status of the post. Possible values include publish, draft, pending, private, future, trash, and auto-draft. | |
| IsSticky | Boolean | Indicates whether the post is pinned (sticky) on the site's front page. | |
| Password | String | The password protecting the post, if applicable; otherwise an empty string. | |
| ParentID | String | The ID of the parent post, if this post is part of a hierarchy. | |
| ParentLink | String | The permalink URL of the parent post, if applicable. | |
| ParentTitle | String | The title of the parent post, if applicable. | |
| ParentType | String | The type of the parent post, if applicable. | |
| Type | String | The post type. Common types include post, page, and revision. Custom post types must be whitelisted via the rest_api_allowed_post_types filter. | |
| DiscussionCommentCount | Int | The total number of comments associated with the post. | |
| DiscussionCommentStatus | String | Indicates the comment status for the post (open or closed). | |
| HasDiscussionCommentsOpen | Boolean | Specifies whether new comments are currently allowed. | |
| DiscussionPingStatus | String | Indicates the pingback or trackback status for the post. | |
| HasDiscussionPingsOpen | Boolean | Specifies whether pingbacks or trackbacks are allowed. | |
| HasLikesEnabled | Boolean | Indicates whether likes are enabled for the post. | |
| HasSharingEnabled | Boolean | Indicates whether sharing buttons are displayed on the post. | |
| LikeCount | Int | The total number of likes the post has received. | |
| ILike | Boolean | Indicates whether the current user has liked this post. | |
| IsFollowing | Boolean | Indicates whether the current user follows the site. | |
| IsReblogged | Boolean | Indicates whether the current user has reblogged this post. | |
| GlobalID | String | A globally unique WordPress.com-wide identifier for the post. | |
| FeaturedImage | String | The URL of the post's featured image, if one is set. | |
| PostThumbnail | String | The attachment object associated with the post's featured image. | |
| Format | String | The display format of the post, such as standard, aside, chat, gallery, link, image, quote, status, video, or audio. | |
| HasGeo | Boolean | Indicates whether geolocation data is attached to the post. | |
| MenuOrder | Int | Specifies the display order of pages relative to others. | |
| PageTemplate | String | The page template assigned to the post, if applicable. | |
| PublicizeURLsAggregates | String | A list of social media URLs where the post was published via WordPress.com Publicize. | |
| CategoriesAggregates | String | A collection of categories applied to the post, keyed by category name. | |
| TermsCategoryAggregates | String | A mapping of taxonomy names to term data for assigned categories. | |
| TagsAggregates | String | A collection of tags applied to the post, keyed by tag name. | |
| Attachments | String | A list of media attachments related to the post, keyed by attachment ID. Returns up to 20 attachments. | |
| AttachmentCount | Int | The total number of attachments associated with the post. | |
| MetadataAggregate | String | A collection of post metadata as key-value pairs. | |
| HasCapabilitiesDeletePost | Boolean | Indicates whether the current user has permission to delete the post. | |
| HasCapabilitiesEditPost | Boolean | Indicates whether the current user has permission to edit the post. | |
| HasCapabilitiesPublishPost | Boolean | Indicates whether the current user has permission to publish the post. | |
| PseudoID | String | A unique pseudo identifier for the post within the feed context. | |
| IsExternal | Boolean | Indicates whether the post originates from an external source. | |
| SiteName | String | The display name of the site the post belongs to. | |
| SiteURL | String | The base URL of the site the post belongs to. | |
| IsSitePrivate | Boolean | Indicates whether the site is private or public. | |
| FeaturedMedia | String | The media object featured in the post, if any. | |
| FeedID | Integer | The unique identifier of the feed associated with the post. | |
| FeedURL | String | The URL of the feed that contains the post. | |
| OtherURLs | String | Additional URLs related to the post or feed, if any. | |
| SiteIcon | String | The favicon or site icon representing the WordPress site. | |
| IsSubscribedComments | Boolean | Indicates whether the current user is subscribed to comment updates on this post. | |
| CanSubscribeComments | Boolean | Indicates whether the current user has permission to subscribe to comments on this post. | |
| HasSubscribedCommentsNotifications | Boolean | Indicates whether the user receives email notifications for subscribed comments. | |
| IsPublishDateChanged | Boolean | Indicates whether the post's publish date has been modified since its original creation. | |
| HasUseExcerpt | Boolean | Indicates whether the post should display only its excerpt instead of the full content. |