ODBC Driver for YouTube Analytics

Build 23.0.8839

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839