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")

Elements of the Profile Object

See the Elements of the Profile and Update Profile Object.

Example Responses

JSON Example Response Body for SELECT Profile
XML Example Response Body for SELECT Profile

Table of Contents