Summary of YQL Social Tables

The YQL Social Tables includes the following tables:

Yahoo Social Tables Allowed Statements Keys Example Statements Descriptions
social.connections SELECT owner_guid SELECT * FROM social.connections WHERE owner_guid=me Provides access to a profile owner's connections.
social.connections.updates SELECT guid, filter, transform SELECT * FROM social.connections.updates WHERE owner_guid=me Provides access to the updates of a profile owner's connections.
social.contacts DELETE, INSERT, SELECT contact, contact_guid, contact_id, email, familyName, filters, givenName, guid, nickname, out, owner_guid INSERT INTO social.contacts (owner_guid, givenName, familyName, email, nickname) VALUES ("GTB6FCEBZO3MDCUQQNNEFIBWM", 'John', 'Doe', 'johndoe@yahoo.com', 'Jodo') Provides access to the profile owner's contacts.
social.contacts.sync SELECT guid, rev SELECT * FROM social.contacts.sync WHERE guid=me AND rev=0 Returns sync data from Yahoo Address Book to a client.
social.contacts.updates SELECT filters, guid, transform SELECT * FROM social.contacts.updates WHERE guid=me Provides access to the updates of a profile owner's contacts.
social.profile SELECT guid, email, name SELECT * FROM social.profile WHERE guid=me Provides access to a Yahoo user's profile.
social.profile.image SELECT guid, size SELECT * FROM social.profile.images WHERE guid=me Provides access to the images of a Yahoo user's profile.
social.profile.status SELECT, UPDATE guid, status UPDATE social.profile.status SET status='Updated my status using YQL' WHERE guid=me Provides access to the profile owner's status message.
social.relationships SELECT owner_guid SELECT * FROM social.relationships WHERE owner_guid=me Provides access to the profile owner's relationships.
social.updates DELETE, INSERT, SELECT description, guid, imgHeight, imgURL, imgWidth, link, pubDate, source, suid, title, transform, type DELETE FROM social.updates WHERE guid=me AND suid="9.3341" AND source="y.presence" Provides access to the profile owner's updates.
social.updates.search SELECT dedupe, guid, intl, language, link, max_date, min_date, query, sorting, source, theme, type, woeid SELECT * FROM social.updates.search WHERE query="world cup" Allows you to perform query searches on public updates.

Table of Contents