wordpress xmlrpc and microsoft access vba

juust | 19/10/2009

I was building a database in Wordpress but their table interface lacks completely and I dont want to spend 200 hours developing a backend for a once-off project.

I always used MsAccess for RAD blueprinting and I reckon you can build a better more flexible interface in 20 hours. With XHR MsAccess has some better internet capabilities these days, a nice simple XMLHttp library.

You can use it for any http rest api in the cloud.

Ajax for Access :) here’s the most basic wordpress xml-rpc call, sayHello.

  1. Sub PutXML()
  2.  
  3. txtURL = "http://www.blog.com/xmlrpc.php"
  4. txtUserName = "user"
  5. txtPassword = "pwd"
  6.  
  7.   Dim objSvrHTTP As ServerXMLHTTP
  8.   Dim strT As String
  9.   Set objSvrHTTP = New ServerXMLHTTP
  10.  
  11.   objSvrHTTP.Open "POST", txtURL, False, CStr(txtUserName), _
  12.    CStr(txtPassword)
  13.  
  14.   objSvrHTTP.setRequestHeader "Accept", "application/xml"
  15.   objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
  16.  
  17.   strT = ""
  18.   strT = strT & "<methodcall>"
  19.   strT = strT & "<methodname>demo.sayHello</methodname>"
  20.   strT = strT & "</methodcall>"
  21.  
  22.   objSvrHTTP.send strT
  23.  
  24.   MsgBox objSvrHTTP.responseText
  25.  
  26. End Sub

For pre-Vista you need the MSXML 6.0 library from microsoft, in Vista I already had it installed so you can add a reference to the library and off you go.

Categories
juust, xml-rpc
Tags
xhr
Comments rss
Comments rss
Trackback
Trackback

« add rss output to a wordpress page more vba and wordpress xml rpc »

5 Responses to “wordpress xmlrpc and microsoft access vba”

  1. Communibus Locis says:
    19/10/2009 at 4:01 pm

    Does 5ubliminal have anything that you can use? He’s built some pretty extensive Wordpress API’s.

    http://blog.5ubliminal.com/topics/wordpress/xmlrpc-api/

    Reply
  2. juust says:
    19/10/2009 at 5:39 pm

    Yeah, I know. He uses PHP, afaik, but since he moved the blog I haven’t seen what he’s been doing, I keep getting blank pages :)

    Reply
    • jabawoki says:
      25/10/2009 at 11:29 pm

      I wouldn’t trust 5ubliminal’s coding too much.
      Try adding a comment on his website using Firefox and you’ll see what I mean!

      Reply
  3. ael says:
    25/10/2009 at 11:58 pm

    Juust, very informative site, thank dude!

    I have a question regarding your postings on xmlrpc via vba:

    I used your code from this post and from http://www.juust.org/index.php/more-vba-and-wordpress-xml-rpc/2009/10/ as the basis of a vba function to make posts to my wordpress blog from MS Office applications (using blogger_newpost), however I keep getting errors back from wp xlmrpc.

    faultCode
    -32700

    faultString
    parse error. not well formed

    I assume the error relates to the formatting of my xml params structure.
    Would you be able to do a post on a generic function to make a post from any office app to a wordpress blog.

    Thanks

    Ael

    Reply

Leave a Reply