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.

ForChannelId, OnBehalfOfContentOwner, and OnBehalfOfContentOwnerChannel are also optional columns. All filter columns support the = operator.

Subscriptions supports ordering by Alphabetical, Relevance (default), and Unread.

By default, the driver returns a list of channels that the authenticated user subscribes to.

SELECT Title FROM Subscriptions WHERE ChannelId = 'abc123' ORDER BY Unread DESC

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.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

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.
MyRecentSubscribers	String	Set this parameter's value to true to retrieve a feed of the subscribers of the authenticated user in reverse chronological order (newest first). Note that the maximum number of subscribers returned through this API might be limited.