(SQL Server) WordPress Create Post

See more WordPress Examples

Demonstrates how to create a WordPress post.

For more information, see https://wordpress.org/plugins/application-passwords/

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- This example assumes the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @http int
    -- Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    -- Use your WordPress login, such as "admin", not the application name.
    EXEC sp_OASetProperty @http, 'Login', 'wp_username'
    -- Use the application password, such as "Nths RwVH eDJ4 weNZ orMN jabq"
    -- See WordPress Application Passwords Plugin
    EXEC sp_OASetProperty @http, 'Password', 'app_password'
    EXEC sp_OASetProperty @http, 'BasicAuth', 1

    -- Note: For this to work, you'll likely need to update your .htaccess file on your WordPress server.
    -- Otherwise you'll get this error:
    -- 
    -- 401 : Sorry, you are not allowed to create posts as this user
    -- 
    -- Your default .htaccess file probably looks like this:
    -- 
    -- <IfModule mod_rewrite.c>
    -- RewriteEngine On
    -- RewriteBase /
    -- RewriteRule ^index\.php$ - 
    -- RewriteCond %{REQUEST_FILENAME} !-f
    -- RewriteCond %{REQUEST_FILENAME} !-d
    -- RewriteRule . /index.php 
    -- </IfModule>
    -- # END WordPress
    -- 
    -- Add the following line immediately after the "RewriteEngine On" line:    RewriteRule .* - [E=REMOTE_USER:%{HTTP:Authorization}]
    -- Your .htaccess file should look like this after the edit:
    -- 
    -- <IfModule mod_rewrite.c>
    -- RewriteEngine On
    -- RewriteRule .* - [E=REMOTE_USER:%{HTTP:Authorization}]
    -- RewriteBase /
    -- RewriteRule ^index\.php$ - 
    -- RewriteCond %{REQUEST_FILENAME} !-f
    -- RewriteCond %{REQUEST_FILENAME} !-d
    -- RewriteRule . /index.php 
    -- </IfModule>
    -- # END WordPress

    DECLARE @json int
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT

    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'title', 'This is a test post'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'content', '<p>This is the HTML body of my post</p>'
    -- The status can be "draft" or "publish"
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'status', 'draft'

    -- Add tags -- but you need to know the ID of an existing tag.
    -- See Chilkat's other WordPress example for creating a tag, or getting the ID of an existing tag.
    DECLARE @tagIdx int
    SELECT @tagIdx = 0
    EXEC sp_OASetProperty @json, 'I', @tagIdx
    -- When Chilkat sees the literal string "[i]" in the JSON path, it replaces the "i" with the value of the "I" property.
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'tags[i]', 56
    SELECT @tagIdx = @tagIdx + 1
    EXEC sp_OASetProperty @json, 'I', @tagIdx
    EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'tags[i]', 75
    -- ..

    DECLARE @resp int
    EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://cknotes.com/wp-json/wp/v2/posts', 'application/json', @json
    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @json
        RETURN
      END

    EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
    IF @iTmp0 <> 201
      BEGIN
        EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
        PRINT @sTmp0

        EXEC sp_OAGetProperty @resp, 'StatusCode', @iTmp0 OUT
        PRINT 'status code = ' + @iTmp0
        EXEC @hr = sp_OADestroy @resp

        EXEC @hr = sp_OADestroy @http
        EXEC @hr = sp_OADestroy @json
        RETURN
      END

    DECLARE @jResp int
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jResp OUT

    EXEC sp_OAGetProperty @resp, 'BodyStr', @sTmp0 OUT
    EXEC sp_OAMethod @jResp, 'Load', @success OUT, @sTmp0

    EXEC sp_OAMethod @jResp, 'IntOf', @iTmp0 OUT, 'id'
    PRINT 'Post ID = ' + @iTmp0

    EXEC sp_OAMethod @jResp, 'StringOf', @sTmp0 OUT, 'link'
    PRINT 'Post URL = ' + @sTmp0

    EXEC @hr = sp_OADestroy @resp


    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @json
    EXEC @hr = sp_OADestroy @jResp


END
GO