Videos
Query Videos from a Target. Normally requires the user_videos permission.
Table Specific Information
Videos in Facebook are videos that have been uploaded by a user or to a page on Facebook.
Select
When selecting videos, specify a target. The target represents the user or page who uploaded the video. If no target is specified, the currently authenticated user will be used as the target. For example:
SELECT * FROM Videos WHERE Target = 'facebook'
If you know the Id, you can specify the Id to obtain information about the specific video. For example:
SELECT * FROM Videos WHERE Id = 'VideoId'
When querying videos, retrieve elements by specifying either the CreatedTime or the UpdatedTime. For example:
SELECT * FROM Videos WHERE Target='thesimpsons' AND CreatedTime >= '1/1/2012' AND CreatedTime <= '10/1/2012'
Columns
Name | Type | Description |
ID [KEY] | String | The Id of the video. |
Target | String | The Id or username of the target you are retrieving videos for. |
FromId | String | Id of the user who uploaded the video. |
FromName | String | Name of the user who uploaded the video. |
FromPicture | String | Picture of the user who uploaded the video. |
FromCategory | String | Category of the user who uploaded the video. FromCategory may only be retrieved if the other From* fields are not selected. |
Description | String | A description of the video. |
Picture | String | URL for the thumbnail of the video. |
Source | String | A URL to the raw, playable video file. |
EmbedHtml | String | The HTML element that may be embedded in an Web page to play the video. |
Icon | String | The icon that Facebook displays when videos are published to the Feed. |
Format | String | An aggregate of four different formats for the video. |
TagsData | String | An aggregate of users tagged in the video, if any. |
CommentsCount | Integer | The number of comments for the video. |
LikesCount | Integer | The number of times the video has been liked. |
CommentsData | String | An aggregate of comments for the video. |
CreatedTime | Datetime | When the video was uploaded. |
UpdatedTime | Datetime | When the video was last updated. |