We hope you are as excited as we are about the release of the INSERT/UPDATE/DELETE keywords for YQL. However, we didn't want to stop there. Cake is nice, but it sure is better with ice cream and sprinkles and maybe some of those chocolate wafers.
So what's the ice cream? First, we are giving you more INSERT/UPDATE/DELETE tables starting today with WordPress. That's right. You can now use YQL to post to any WordPress blog. So how does it work? Well we've been working on a library for YQL Execute that lets you interact with XML-RPC web services. It's not quite ready yet but this WordPress table is a tasty treat just to tickle your tastebuds.
Say I wanted to create a new blog post on a WordPress installation (including WordPress.com blogs) I would simply need to run:
insert into wordpress.post (title, description, blogurl, username, password) values ("Test Title", "This is a test body", "http://yqltest.wordpress.com", "yqltestuser", "password");. Try inserting into our test WordPress blog for yourself and view the results at yqltest.wordpress.com.
Tom Hughes-Croucher (@sh1mmer)
Yahoo! Developer Network