Subscriptions
Query YouTube User Subscriptions. A Subscription notifies a User when new Videos are added to a Channel, or when another user takes one of several actions on YouTube, such as uploading a Video, rating a Video, or commenting on a Video.
Table Specific Information
Select
You can specify exactly one of the following columns: ChannelId, Id, MyRecentSubscribers, or MySubscribers.
Extra optional columns supported are ForChannelId, OnBehalfOfContentOwner, and OnBehalfOfContentOwnerChannel. All columns support the '=' operator.
Order is supported for Subscriptions. 'Alphabetical', 'Relevance', and 'Unread' are the supported order columns.
By default, if no filters are specified, the driver will return a list of channels subscribed by authenticated user.
SELECT Title FROM Subscriptions WHERE ChannelId = 'abc123' ORDER BY Unread DESC
The default value is SUBSCRIPTION_ORDER_RELEVANCE.
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
Id [KEY] | String | The Id that YouTube uses to uniquely identify the subscription. | |||
PublishedAt | Datetime | The date and time that the subscription was created. The value is specified in ISO 8601 (YYYY-MM-DDThh:mm:ss.sZ) format. | |||
ChannelTitle | String | The title of the channel that the subscription belongs to. | |||
Title | String | The title of the subscription. | |||
Description | String | The details of the subscription. | |||
ResourceIdKind | String | The type of the API resource. | |||
ResourceIdChannelId | String | The value that YouTube uses to uniquely identify the channel that the user subscribed to. | |||
ChannelId | String | The Id that YouTube uses to uniquely identify the channel of the subscriber. | |||
ThumbnailsDefaultUrl | String | The URL of the default image. | |||
TotalItemCount | Integer | The approximate number of items that the subscription points to. | |||
NewItemCount | Integer | The number of new items in the subscription since its content was last read. | |||
ActivityType | String | The type of activity this subscription is for. Valid values: all, uploads. | |||
SubscriberTitle | String | The title of the channel of the subscriber. | |||
SubscriberDescription | String | The description of the channel of the subscriber. | |||
SubscriberChannelId | String | The Id that YouTube assigns to uniquely identify the channel of the subscriber. | |||
SubscriberThumbnailsDefaultUrl | String | The URL of the default image. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
MySubscribers | String | Set this value of this parameter to true to retrieve a feed of the subscribers of the authenticated user. |
ForChannelId | String | The ForChannelId column specifies a comma-separated list of channel Ids. |
OnBehalfOfContentOwner | String | This column is intended exclusively for YouTube content partners. |
OnBehalfOfContentOwnerChannel | String | Specifies the YouTube ChannelId of the channel to which a video is being added. |
Alphabetical | String | Sort alphabetically |
Relevance | String | Sort by relevance. |
Unread | String | Sort by order of activity. |