Chapter 5. Profile Tables
A profile is a collection of user provided information that is descriptive of the user, such as the user's name, gender, location, photo, and relationship status.
The Profiles Tables consist of two tables. The Profile Table allows you to get the extended usercard of a profile owner.
The Profile Table also allows you to get public user profiles based on a search term with the key text. The Profile Images Table allows you to get a user's profile images.
Profile Table
Description
The Profile Table supports SELECT statements to get the extended usercard of the profile owner.
Table
social.profile
Allowed Statements
SELECT
Keys
| Key Name | Data Type | Allowed in Statements | Required in Statements | Default Value | Description |
|---|---|---|---|---|---|
guid
|
string |
SELECT
|
SELECT
|
None | The GUID of the profile owner. |
email
|
string |
SELECT
|
SELECT
|
None | The email address of the profile owner. |
name
|
string |
SELECT
|
SELECT
|
None | The name of the profile owner. |
Example Statements
SELECT
Getting a Single Profile
This example statement returns the extended usercard of the signed-in profile owner. Run the query in the YQL Console.
SELECT * FROM social.profile WHERE guid=me
This example statement returns the extended usercard of the profile owner whose email address is "johndoe@yahoo.com".
SELECT * FROM social.profile WHERE email="johndoe@yahoo.com"
Getting Multiple Profiles
This example statement returns the extended usercards for those Yahoo! users that have the string "engineer" in their profile information. Run the query in the YQL Console.
SELECT * FROM social.profile WHERE text="engineer"
This example statement returns the extended usercards for the signed-in user's connections.
SELECT * FROM social.profile WHERE guid IN (SELECT fields.value FROM social.contacts.connections WHERE guid=me AND fields.type="guid")