photo
Description
Query this table to return information about a photo.
Columns
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
aid | The ID of the album containing the photo being queried. The aid cannot be longer than 50 characters. Note: Because the aid is a string, you should always wrap the aid in quotes when referenced in a query. | ||||||
aid_cursor string | A cursor used to paginated through a query that is indexed on the aid | ||||||
album_object_id | The object_id of the album the photo belongs to. | ||||||
album_object_id_cursor string | A cursor used to paginate through a query that is indexed on the album_object_id | ||||||
backdated_time timestamp | The time the photo was backdated to in Timeline | ||||||
backdated_time_granularity enum | A string representing the backdated granularity. Valid values are year, month, day, hour, or minute | ||||||
can_backdate bool | true if the viewer is able to backdate the photo | ||||||
can_delete bool | true if the viewer is able to delete the photo | ||||||
can_tag bool | true if the viewer is able to tag the photo | ||||||
caption string | The caption for the photo being queried. | ||||||
caption_tags array | An array indexed by offset of arrays of the tags in the caption of the photo, containing the id of the tagged object, the name of the tag, the offset of where the tag occurs in the message and the length of the tag. | ||||||
comment_info struct | The comment information of the photo being queried. This is an object containing can_comment and comment_count | ||||||
| |||||||
created timestamp | The date when the photo being queried was added. | ||||||
images array | An array of objects containing width, height, source each representing the various photo sizes. | ||||||
like_info struct | The like information of the photo being queried. This is an object containing can_like, like_count, and user_likes | ||||||
| |||||||
link string | The URL to the page containing the photo being queried. | ||||||
modified timestamp | The date when the photo being queried was last modified. | ||||||
object_id | The object_id of the photo. | ||||||
offline_id number | The offline_id is specificed when uploading a photo to track the upload status of it later | ||||||
owner | The user ID of the owner of the photo being queried. | ||||||
owner_cursor string | A cursor used to paginate through a query that is indexed on the owner | ||||||
page_story_id string | The ID of the feed story about this photo if itbelongs to a page | ||||||
pid | The ID of the photo being queried. The pid cannot be longer than 50 characters. Note: Because the pid is a string, you should always wrap the pid in quotes when referenced in a query. | ||||||
place_id id | Facebook ID of the place associated with the photo, if any. | ||||||
position number | The position of the photo in the album. | ||||||
src string | The URL to the album view version of the photo being queried. The image can have a maximum width or height of 130px. This URL may be blank. | ||||||
src_big string | The URL to the full-sized version of the photo being queried. The image can have a maximum width or height of 720px, increasing to 960px on 1st March 2012. This URL may be blank. | ||||||
src_big_height unsigned int32 | Height of the full-sized version, in px. This field may be blank. | ||||||
src_big_width unsigned int32 | Width of the full-sized version, in px. This field may be blank. | ||||||
src_height unsigned int32 | Height of the album view version, in px. This field may be blank. | ||||||
src_small string | The URL to the thumbnail version of the photo being queried. The image can have a maximum width of 75px and a maximum height of 225px. This URL may be blank. | ||||||
src_small_height unsigned int32 | Height of the thumbnail version, in px. This field may be blank. | ||||||
src_small_width unsigned int32 | Width of the thumbnail version, in px. This field may be blank. | ||||||
src_width unsigned int32 | Width of the album view version, in px. This field may be blank. | ||||||
target_id numeric string | The ID of the target the photo is posted to | ||||||
target_type string | The type of target the photo is posted to | ||||||
Examples
- SELECT ... FROM photo WHERE pid = A
- SELECT ... FROM photo WHERE aid = A
- SELECT ... FROM photo WHERE aid = A AND pid = B
- SELECT ... FROM photo WHERE album_object_id = A
- SELECT ... FROM photo WHERE object_id = A
- SELECT ... FROM photo WHERE owner = A
Note: Additional filters on other columns can be specified but they may make the query less efficient.
Permissions
To read the photo table you need
- any valid
access_tokenif it is public and owned by the Page. user_photospermissions to access photos and albums uploaded by the user, and photos in which the user has been tagged.friends_photospermissions to access friends' photos and photos in which the user's friends have been tagged.