GUIDs, Social, and Me

YQL includes a set of pre-defined tables that call the Yahoo Social APIs. The social.profile table, for example, contains information about a Yahoo user, and the social.connections table is a list of the user's friends. The Global User Identifier (GUID) is a string that uniquely identifies a Yahoo user. In YQL, the me keyword is the GUID value of the user currently logged in to Yahoo. For example, if you are logged in to Yahoo, and you run the following statement, YQL returns your profile information:

select * from social.profile where guid=me

Because me is a keyword, it is not enclosed in quotes. To specify a GUID value, enclose the string in quotes, for example:

select * from social.updates where guid='7WQ7JILMQKTSTTURDDAF3NT35A'

Table of Contents