JDBC Driver for Facebook

Build 22.0.8462

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.

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='thesimpsons' 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462