TDV Adapter for Facebook

Build 21.0.8137

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137