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 |
| CreateMedia | Uploads a new media file, such as an image or video, to the WordPress site's media library and attaches it to a specified post or page. |
| 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. |
| RefreshOAuthAccessToken | 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. |
| UpdateSettings | Updates the settings of the website. |