Profile (FQL)
From Facebook Developer Wiki
Description
The FQL profile table. Query this table to return certain (typically publicly) viewable information from a user's profile or Facebook Page that is displayed in a story. Think of this table as a parent class of the page and user tables.
To structure your query, use the table name (profile in this case) in the FROM clause. The items in the Name column correspond to columns in the table that can be referenced in the SELECT and WHERE clauses.
In order to make your query indexable, the WHERE in your query should contain an = or IN clause for one of the columns marked with a * in the Indexable column of the table.
Columns
| Indexable | Name | Type | Description | |
| * | id | int | A 64-bit int representing the user ID or Page ID. | |
|---|---|---|---|---|
| name | string | The full name of the user or Page being queried. | ||
| url | string | The URL to a user's profile or Page. If the user or Page has a username, url contains the username. | ||
| pic | string | The URL to the small-sized profile picture for the user or Page being queried. The image can have a maximum width of 50px and a maximum height of 150px. This URL may be blank. | ||
| pic_square | string | The URL to the square profile picture for the user or Page being queried. The image can have a maximum width and height of 50px. This URL may be blank. | ||
| pic_small | string | The URL to the small-sized profile picture for the user or Page being queried. The image can have a maximum width of 50px and a maximum height of 150px. This URL may be blank. | ||
| pic_big | string | The URL to the largest-sized profile picture for the user or Page being queried. The image can have a maximum width of 200px and a maximum height of 600px. This URL may be blank. | ||
| type | string | The type of profile, either user for a user profile or page for a Facebook Page. | ||
| * | username | string | The username of the user being queried. |
