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