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. |