Query YouTube Videos.
Table Specific Information
By default, SupportEnhancedSQL is set to true, and the following will be passed to YouTube if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.
By default, if no filters are specified, the driver will return all videos owned by the authenticated user.
Only one of the following columns may be filtered by at a time: Id, MyRating, ChannelId, or Chart. Extra columns supported are ForMine, Language, ForContentOwner, OnBehalfOfContentOwner.
A search against all videos on Youtube may be executed by specifying SearchTerms, RelatedToVideoId, VideoDuration, VideoCategoryId, or Region.
All columns support the '=' operator. PublishedAt also supports these additional operators: '>', '>=', '<', and '<='. Id and ChannelId supports IN.
Order by is supported for the Date, Rating, Relevance and Title columns.
SELECT * FROM Videos WHERE Id = '12345679' SELECT * FROM Videos WHERE PublishedAt >= '2016-01-01T20:30:00Z' LIMIT 10 SELECT Description FROM Videos WHERE ForMine = True ORDER BY Date
Note: Ordering is not supported when specifying one of the colums used for searching channels such as SearchTerms.
The IN operator can be used to specify a list of channels. This call returns a list of videos for each specified channel.
SELECT * FROM Videos WHERE ChannelId IN (a, b, c) SELECT * FROM Videos WHERE ChannelId IN (SELECT Id FROM Channels)
IN operator can also be used for getting data for miltiple videos.
SELECT * FROM Videos WHERE Id IN (a, b, c)
|Id [KEY]||String||single||The Id that YouTube uses to uniquely identify the video.|
|ChannelId||String||single||The Id that YouTube uses to uniquely identify the channel that the video was uploaded to.|
|CategoryId||String||unsupported||The YouTube video category associated with the video.|
|Title||String||unsupported||The title of the video.|
|ChannelTitle||String||unsupported||Channel title for the channel that the video belongs to.|
|PublishedAt||Datetime||searchspecific||The date and time that the video was published. Note that this time might be different than the time that the video was uploaded. The value is specified in ISO 8601 (YYYY-MM-DDThh:mm:ss.sZ) format.|
|Description||String||unsupported||The description of the video.|
|Duration||String||unsupported||The length of the video. The property value is an ISO 8601 duration.|
|ViewCount||Long||unsupported||The number of times the video has been viewed.|
|LikeCount||Long||unsupported||The number of users who have indicated that they liked the video.|
|DislikeCount||Long||unsupported||The number of users who have indicated that they disliked the video.|
|CommentCount||Long||unsupported||The number of comments for the video.|
|EmbedHtml||String||unsupported||An iframe tag that embeds a player that will play the video.|
|PublicStatsViewable||Boolean||unsupported||This value indicates whether the extended video statistics on the watch page are publicly viewable. By default, those statistics are viewable, and statistics like the viewcount and ratings will still be publicly visible even if this value is set to false.|
|TagsAggregate||String||unsupported||A list of keyword tags associated with the video.|
|LiveBroadcastContent||String||unsupported||Indicates if the video is an upcoming/active live broadcast. A value of none indicates the video is not an upcoming/active live broadcast. Valid values for this column: live, none, upcoming.|
|Dimension||String||unsupported||Indicates whether the video is available in 3D or in 2D.|
|Definition||String||unsupported||Indicates whether the video is available in high definition HD or only in standard definition. Valid values for this column: hd,sd.|
|Caption||String||unsupported||Indicates whether captions are available for the video. Valid values for this column: false, true.|
|LicensedContent||Boolean||unsupported||Indicates whether the video represents licensed content, which means that the content was uploaded to a channel linked to a YouTube content partner and then claimed by that partner.|
|PrivacyStatus||String||unsupported||The privacy status of the playlist. Valid values: private, public, unlisted.|
|License||String||unsupported||The license. Valid values: creativeCommon, youtube.|
|Embeddable||Boolean||unsupported||This value indicates whether the video can be embedded on another website.|
|ThumbnailsDefaultUrl||String||unsupported||The URL of the default image.|
|DefaultLanguage||String||unsupported||This column is confidential to trusted testers. The language of the text in the Title and Description columns.|
|DefaultAudioLanguage||String||unsupported||The default_audio_language column specifies the language spoken in the default audio track of the video.|
|UploadStatus||String||unsupported||The status of the uploaded video. Valid values for this column: deleted, failed, processed, rejected, uploaded.|
|FailureReason||String||unsupported||This value explains why a video failed to upload. This column only has a value if the UploadStatus column indicates that the upload failed. Valid values for this column: codec, conversion, emptyFile, invalidFile, tooSmall, uploadAborted.|
|RejectionReason||String||unsupported||This value explains why YouTube rejected an uploaded video. This column only has a value if the UploadStatus column indicates that the upload was rejected. Valid values for this column: claim, copyright, duplicate, inappropriate, length, termsOfUse, trademark, uploaderAccountClosed, uploaderAccountSuspended.|
|LocationDescription||String||unsupported||The text description of the location where the video was recorded.|
|RecordingDate||Datetime||unsupported||The date and time when the video was recorded. The value is specified in ISO 8601 (YYYY-MM-DDThh:mm:ss.sssZ) format.|
|SearchTerms||String||searchspecific||The query term to search for.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|SafeSearch||String||Indicates whether the search results should include restricted content as well as standard content. Acceptable values: moderate, none, or strict.|
|RelatedToVideoId||String||Retrieves a list of videos that are related to the video that the column value identifies.|
|VideoDuration||String||Filters video search results based on their duration. Acceptable values: any, long, medium or short.|
|VideoCategoryId||String||The videoCategoryId parameter identifies the video category for which the chart should be retrieved.|
|Region||String||Instructs the API to select a video chart available in the specified region. This column can only be used in conjunction with the chart column. The parameter value is an ISO 3166-1 alpha-2 country code.|
|ForMine||String||Restricts the search to only retrieve videos owned by the authenticated user. It is false by default.|
|Chart||String||This parameter can only be used in a properly authorized request. Set this parameter's value to like or dislike to instruct the API to only return videos liked or disliked by the authenticated user.|
|MyRating||String||The rating of the authenticated user. Acceptable values: like or dislike.|
|Language||String||Retrieve localized resource metadata for a specific application language that the YouTube website supports.|
|ForContentOwner||String||Restricts the search to only retrieve videos owned by the content owner specified by the OnBehalfOfContentOwner parameter.|
|OnBehalfOfContentOwner||String||This parameter is intended exclusively for YouTube content partners.|
|Rows@Next||String||This is used to page through multiple pages of results and should not be set manually.|