CData ODBC Driver for YouTube 2016 - Online Help
CData ODBC Driver for YouTube 2016 - Build 16.0.6375
Questions / Feedback?

Videos

Query YouTube Videos.

Table Specific Information

Select

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)

Columns

Name Type FilterType Description
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-Columns

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.

Name Type Description
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.

 
 
Copyright (c) 2017 CData Software, Inc. - All rights reserved.
Build 16.0.6375.0