more vba and wordpress xml rpc

Basic Example II, vba wordpress remote control, demo.ayHello is fun but quite useless, so let’s proceed to wp.getUsersBlogs.

I make a table in access (id, isAdmin, blogid, url, blogName, xmlrpc) and then query wordpress, parse the xml response in store it in the database.

So here we go query WordPress :

    methodname = "wp.getUsersBlogs"

'xmlrpc url
    txtURL = ""

    txtUserName = "user"
    txtPassword = "pass"

'XML http request  
    Dim objSvrHTTP As ServerXMLHTTP
    Dim strT As String
    Set objSvrHTTP = New ServerXMLHTTP
    objSvrHTTP.Open "POST", txtURL, False, CStr(txtUserName), _
    objSvrHTTP.setRequestHeader "Accept", "application/xml"
    objSvrHTTP.setRequestHeader "Content-Type", "application/xml"

'here is the bit with the wp.getUserBlogs methodname, 
'and the username and password    
    strT = ""
    strT = strT & ""
    strT = strT & "" & methodname & ""
    strT = strT & ""
    strT = strT & "" & txtUserName & ""
    strT = strT & "" & txtPassword & ""
    strT = strT & ""
    strT = strT & ""
    objSvrHTTP.send strT

that’s pretty straight forward.

I get an xml message back with the data stored in an array of STRUCT types.

'Create the DomDocument Object
Dim oDoc As MSXML2.DOMDocument
Set oDoc = CreateObject("MSXML2.DOMDocument")
oDoc.async = False
oDoc.validateOnParse = False

'Load the response in the DomDocument Object
Dim fSuccess As Boolean
fSuccess = oDoc.loadXML(objSvrHTTP.responseText)
If Not fSuccess Then
    MsgBox "failed"
    Exit Function
End If
ct = 1
cs = 1

'array to story the field values
Dim SArray(1 To 5) As String

'open the table as recordset 
Dim d As DAO.Recordset
Set d = CurrentDb.OpenRecordset("blogs", dbOpenTable)

'lets get the structs
Set oChildren = oDoc.selectNodes("//struct")
For Each oStruct In oChildren

'the struct has members, 

   Set Members = oStruct.childNodes
   For Each Member In Members

'each member has a param pair (field, value)
'skip the first param, and store the field value
'in an array

       Set Params = Member.childNodes
       For Each Param In Params
            ct = ct + 1
            If ct / 2 <> Int(ct / 2) Then
                SArray(ct / 2) = Param.Text
                cs = cs + 1
            End If


    'we got the struct data, 
    'now add the array to the database
     With d
        !isAdmin = SArray(1)
        !url = SArray(2)
        !blogid = SArray(3)
        !blogName = SArray(4)
        !xmlrpc = SArray(5)
    End With


'close up shop
Set d = Nothing

End Function

The other worpdress api calls work quite the same.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top