Pixelated Words

Archive for May, 2009

YQL OpenSocial Client

without comments

Here is a YQL open data table that allows developers to use SQL-like
SELECT syntax on top of the OpenSocial REST people API.

Note: This open data table only covers the people API and needs some
more work to be useful for developers. Also, it requires the HTTPS
protocol since private keys are being transmitted.

Example query: http://tinyurl.com/qnfnzn (Uses the guid, ck, and cks
from the sample code in the opensocial php client)

Source code for the opensocial.people open data table:

http://github.com/chirags/yql-tables/blob/d1f5d12d6e8d5e7d9424db5c869082abfcd469cd/opensocial/opensocial.people.xml

<?xml version="1.0" encoding="UTF-8" ?>
<table xmlns="http://query.yahooapis.com/v1/schema/table.xsd" https="true">
  <meta>
    <author>Chirag Shah</author>
  </meta>
  <bindings>
    <select itemPath="" produces="XML">
      <urls>
        <url>http://sandbox.orkut.com/social/rest/people/</url>
      </urls>
      <inputs>
        <key id='method' type='xs:string' paramType='variable' const="true" default="opensocial.people" />
        <key id='ck' type='xs:string' paramType='variable' required="true" />
        <key id='cks' type='xs:string' paramType='variable' required="true" />
        <key id='guid' type='xs:string' paramType='variable' required="true" />
        <key id='selector' type='xs:string' paramType='variable' required="true" />
        <key id='count' type='xs:string' paramType='variable' required="true" default="20" />
        <key id='container' type='xs:string' paramType='variable' required="true" />
      </inputs>
      <execute><![CDATA[
        // Include the signing library
        y.include("http://oauth.googlecode.com/svn/code/javascript/oauth.js");
        y.include("http://oauth.googlecode.com/svn/code/javascript/sha1.js");
 
        var base;
        if(container == 'orkut') 
            base = 'http://sandbox.orkut.com/social/rest/people/';
        else if(container == 'friendconnect')
            base = 'http://www.google.com/friendconnect/api/people/';
        else
            base =  '';
 
        var requestUrl = base + guid + '/@' + selector + '/';
        var accessor = {consumerSecret: cks};
        var message = {
            method: "GET",
            action: requestUrl,
            parameters: [
                ['oauth_signature_method', 'HMAC-SHA1'],
                ['oauth_consumer_key', ck],
                ['oauth_version', '1.0'],
                ['xoauth_requestor_id', guid],
                ['format', 'json']
            ]
        };
 
        OAuth.setTimestampAndNonce(message);
        OAuth.setParameter(message, "oauth_timestamp", OAuth.timestamp());
        OAuth.SignatureMethod.sign(message, accessor);
        var finalRequestUrl = OAuth.addToURL(message.action, message.parameters);
        response.object = y.rest(finalRequestUrl).get().response;
      ]]></execute>
    </select>
  </bindings>
</table>

Written by Chirag

May 31st, 2009 at 12:47 pm

Posted in Hacks

Tagged with , ,