ChannelSections
Query YouTube ChannelSections. A ChannelSection contains information about a set of Videos that a Channel has chosen to feature.
Table Specific Information
Select
YouTube Analytics allows only a subset of columns to be used as filter criteria. You can specify exactly one of the following columns: ChannelId or Id. Extra optional columns supported are Language and OnBehalfOfContentOwner.
All columns support the '=' operator.
By default, if no channel id is specified, the driver will return channel sections for the channel owned by authenticated user.
SELECT * FROM ChannelSections WHERE ChannelId = '123456789'
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
Id [KEY] | String | The Id that YouTube uses to uniquely identify the channel section. | |||
Type | String | The type of the channel section. | |||
ChannelId | String | The Id that YouTube uses to uniquely identify the channel. | |||
Title | String | The title of the section. | |||
Position | Integer | The position of the section on the channel page. | |||
PlaylistsAggregate | String | A list of one or more playlist Ids that are featured in a channel section. You must specify a list of playlist Ids if the type of the ChannelSection is either singlePlaylist or multiplePlaylists, and this column should not be specified for other types of sections. If the type is singlePlaylist, this list must specify exactly one playlist Id. | |||
ChannelsAggregate | String | A list of one or more channel Ids that are featured in a channel section. You must specify a list of channel Ids if the Type of the ChannelSection is multipleChannels, and this column should not be specified for other types of sections. You cannot include your own channel in the list. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Language | String | Retrieve localized resource metadata for a specific application language that the YouTube website supports. |
OnBehalfOfContentOwner | String | This parameter is intended exclusively for YouTube content partners. |