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 |
|
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 |
|
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. |