Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with WordPress.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from WordPress, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for WordPress Stored Procedures
| Name | Description |
| ActivateWidgets | Activates widgets on a WordPress site by updating their configuration and status. |
| CreateMedia | Creates a new media item, such as an image, video, or document, and uploads it to the WordPress.com Media Library for use in posts or pages. |
| DeleteTracks | Deletes tracking or activity records from WordPress. |
| FollowSpecifiedBlog | Allows the user to follow a specific WordPress blog by providing its blog Id or URL. |
| GetOAuthAccessToken | Gets the OAuth access token from Wordpress. |
| GetOAuthAuthorizationURL | Gets the Wordpress authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to Wordpress. |
| LikeAComment | Adds a like to a specific WordPress comment and updates the like count accordingly. |
| LikeAPost | Adds a like to a specific WordPress post and updates the post's like count accordingly. |
| MarkNotificationAsRead | Mark the user's notifications as read, updating their status in WordPress.com so they no longer appear as new or unread. |
| PostCounts | Get number of posts in the post type groups by post status. |
| ReblogPost | Reblog a post. |
| RecentNotificationSeenTimestamp | Set the timestamp of the most recently seen notification. |
| RemoveLikeFromComment | Remove like from a comment. |
| ReplytoAnotherComment | Create a comment as a reply to another comment. |
| ReportReferrerAsSpam | Report a referrer as spam. |
| RestorePosts | Restore multiple posts |
| RestorePoststoPreviousStatus | Restore a post or page from the trash to its previous status. |
| SendTwoStepCode | Sends a two-step code via SMS to the current user. |
| SiteEmbeds | Sends a two-step code via SMS to the current user. |
| SiteRenderedEmbeds | Like a comment. |
| SiteShortCodes | Get a list of shortcodes available on a site. Note: The current user must have publishing access. |
| SubscribeNewTag | Subscribe to a new tag. |
| UnFollowSpecifiedBlog | Follow the specified blog. |
| UnLikeAPost | UnLike a post. |
| UnReportReferrerAsSpam | Unreport a referrer as spam. |
| UnsubscribeTag | Unsubscribe to a tag. |
| UploadTracks | Upload a subtitle/caption track for a specified VideoPress video. |
| WordAdsApproved | Request streamlined approval to join the WordAds program. |