Profile Images Table
Description
The Profile Images Table supports SELECT statements to get the profile images of a profile owner. The table can also be used to get a single profile image by specifying an image size.
Table
social.profile.images
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. |
size
|
string |
SELECT
|
SELECT
|
None | The image size. The default size is following are the allowed sizes: 16x16, 24x24, 32x32, 48x48, 64x64, 96x96, 128x128, 192x192 |
Example Statements
SELECT
Getting All of the Profile Images
This example statement returns all of the profile images for the signed-in user. Run the query in the YQL Console.
SELECT * FROM social.profile.images WHERE guid=me
Getting a Single Profile Image
This example statement returns the 32x32 profile images for each of the signed-in user's connections. Run the query in the YQL Console.
SELECT * FROM social.profile.image WHERE guid IN (SELECT guid FROM social.connections WHERE owner_guid=me)AND size='32x32'
Elements of the Image Object
See Elements of the Image Object in the Profiles API chapter.