Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the connector 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 Tableau Connector 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. |