esme-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ethan Jewett <>
Subject ESME API via YQL
Date Mon, 07 Sep 2009 22:06:24 GMT
Hi all,

This is a heads up that the YQL (
wrapper for the ESME API is starting to take shape. The structure of
the YQL abstraction mirrors the conceptual API design on the cwiki
wherever possible

The Open data tables definitions are available at under the "esme"

To quickly get it working, take the following steps:

1. Set up a token on the Stax deployment at
2. Go to the YQL console at
3. Paste the following into the console to set up a session where
"token_value" is your token:

use "";
insert into esme.sessions (esme_api_endpoint,token) VALUES

4. Copy the session cookie out of the result. It looks something like
the following and is between XML tags "<set-cookie>" and

JSESSIONID=BF04121669016B36B6FD9; Path=/

5. Paste the following into the console to grab a list of all
messages, replacing "cookie_value" with the session cookie you copied
in step 4:

use "";
select * from esme.messages WHERE
AND cookie="cookie_value"

Some notes:

1. This will work with any API endpoint.
2. The open data table files contain examples of all functions. It
supports setting and destroying sessions, listing and sending message,
listing all users, listing followers, listing followed, and following.
3. Unfollowing is mysteriously not working (it is timing out after
30000 ms). I'd love it if someone knew why this was happening, but
otherwise I'll investigate further myself.
4. I'll be adding other API functions as I am able.
5. This is more of a conceptual exercise than anything else. I don't
anticipate that it will significantly increase the usability of the
API for developers, but it does expose a sort of command-line access
to the API to more casual developers.



View raw message