RestorePosts
Restore multiple posts
Stored Procedure Specific Information
Execute
Call this procedure to restore mulitple posts.
To restore a post, you must specify the following column: PostId. A successful authentication is also required.
For example:
EXECUTE RestorePosts PostId='6'
Input
| Name | Type | Description |
| PostIds | String | A comma-separated list of post IDs to restore from the trash. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether the request to restore the specified post or posts was completed successfully. |
| Id | Integer | The unique identifier of the restored post. |
| SiteId | Integer | The unique identifier of the WordPress site the restored post belongs to. |
| AuthorId | Integer | The unique identifier of the user who authored the restored post. |
| AuthorLogin | String | The login name of the post author. |
| AuthorEmail | String | The email address of the post author. |
| AuthorName | String | The display name of the post author. |
| 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. |
| AuthorURL | String | The author's website URL associated with the post. |
| AuthorAvatarURL | String | The URL to the author's avatar image. |
| AuthorProfileURL | String | The profile or Gravatar URL of the post author. |
| Date | Date | The date and time when the post was originally created, in the site's timezone. |
| Modified | Datetime | The date and time when the post was last modified after restoration. |
| Title | String | The title of the restored post. |
| URL | String | The permalink URL of the restored post. |
| ShortURL | String | The WordPress shortlink (wp.me) for the restored post. |
| Content | String | The full HTML content of the restored post. |
| Excerpt | String | The excerpt or summary text of the restored post. |
| Slug | String | The URL-friendly name (slug) for the restored post. |
| Guid | String | The globally unique identifier (GUID) for the restored post. |
| Status | String | The current publication status of the restored post, such as publish, draft, or private. |
| Sticky | String | Indicates whether the restored post is marked as sticky on the site. |
| Password | String | The password protecting the post, if applicable. |
| Parent | String | The ID of the parent post, if this post is a child page or revision. |
| Type | String | The post type, such as post, page, or custom type. |
| DiscussionCommentsOpen | String | Indicates whether comments are open for the restored post. |
| DiscussionCommentStatus | String | The moderation status of comments on the post, such as open or closed. |
| DiscussionPingsOpen | String | Indicates whether pingbacks and trackbacks are open for the post. |
| DiscussionPingStatus | String | The current pingback status of the post. |
| LikesEnabled | String | Indicates whether likes are enabled for the post. |
| SharingEnabled | String | Indicates whether sharing options are enabled for the post. |
| LikeCount | String | The number of likes the restored post currently has. |
| ILike | String | Indicates whether the authenticated user has liked the post. |
| IsReblogged | String | Indicates whether the authenticated user has reblogged this post. |
| IsFollowing | String | Indicates whether the authenticated user follows the site hosting this post. |
| GlobalId | String | A unique WordPress.com-wide identifier for the restored post. |
| FeaturedImage | String | The URL of the featured image for the post, if one is assigned. |
| PostThumbnail | String | Metadata or attachment object representing the post's featured image. |
| Format | String | The post format, such as standard, video, gallery, or quote. |
| Geo | String | Geolocation data associated with the post, if available. |
| MenuOrder | String | The order of the post relative to others of the same type. |
| PageTemplate | String | The page template applied to the post, if it is a page. |
| PublicizeURLs | String | A list of URLs where the post has been shared through Publicize integrations. |
| Terms | String | A collection of taxonomy terms associated with the post. |
| Tags | String | The tags assigned to the restored post. |
| Categories | String | The categories assigned to the restored post. |
| Attachments | String | A list of media attachments associated with the post. |
| AttachmentCount | String | The total number of attachments linked to the restored post. |
| Metadata | String | Custom metadata fields and values for the restored post. |
| Meta | String | Additional metadata returned from the WordPress API. |
| Capabilities | String | Permissions or capabilities associated with the post, such as edit or delete rights. |
| Revisions | String | A list of previous revisions available for the restored post. |
| OtherURLs | String | Additional URLs related to the post, such as alternate views or API endpoints. |