Photos
Query Photos associated with a Target. Accessing Photo information typically requires the user_photos permission.
Table Specific Information
Photos in Facebook are photos that are uploaded by a user (for example, to a page) and are part of a photo album.
Note: Due to a deprecation in the Facebook API, queries to the Comments, Photos, Posts, and Videos views where a user profile is either the defined or default target, no longer return data for the following fields:
- comments
- message_tags
- reactions
- sharedposts
- story
- story_tags
- to
- via
Select
When querying photos, specify a target. The target represents the user, page, album, or event that photos are being retrieved for. For example:
SELECT * FROM Photos WHERE Target = 'facebook'
If no target is specified, the currently authenticated user will be used as the target.
When querying photos, elements may be retrieved by specifying either the CreatedTime or the UpdatedTime. For example:
SELECT * FROM Photos WHERE Target = 'mytarget' AND CreatedTime >= '1/1/2012' AND CreatedTime <= '10/1/2012'
Columns
| Name | Type | Description |
| ID [KEY] | String | The Id of the photo. |
| Target | String | The Id or username of the target you are retrieving posts for or are posting to. This may be an album, event, page, or user. |
| FromId | String | Id of the user who uploaded the photo. |
| FromName | String | Name of the user who uploaded the photo. |
| FromPicture | String | Photo of the user who uploaded the photo. |
| FromCategory | String | Category of the user who uploaded the photo. FromCategory may only be retrieved if the other From* fields are not selected. |
| Link | String | A link to the photo on Facebook. |
| Name | String | The name of the photo. |
| Picture | String | A link a thumbnail of the photo. |
| Source | String | The source image of the photo. |
| Height | Integer | The height of the photo. |
| Width | Integer | The width of the photo. |
| Position | Integer | The position of the photo in the album. |
| Icon | String | A link to the icon Facebook displays when photos are published to the stream. |
| PlaceId | String | The Id of the location associated with the post, if any. |
| PlaceName | String | The name of the location associated with the post, if any. |
| Images | String | An aggregate of four different images for the photo. |
| CommentsCount | Integer | The number of comments for the photo. |
| LikesCount | Integer | The number of times the photo has been liked. |
| CommentsData | String | An aggregate of comments for this photo. |
| LikesData | String | An aggregate of likes data. |
| CreatedTime | Datetime | When the photo was uploaded. |
| UpdatedTime | Datetime | When the photo was last updated. |