Power BI Connector for YouTube Analytics

Build 22.0.8479

PlayListItems

Query YouTube PlayListItems. A PlayListItem resource identifies another YouTube entity, such as a Video, that is included in a PlayList. In addition, the PlayListItem record contains details about how that entity is used in that PlayList.

Table Specific Information

Select

You must specify exactly one of the following columns in the WHERE clause: Id or PlayListId. Extra optional columns supported are OnBehalfOfContentOwner and VideoId.

All columns support the '=' operator.

SELECT * FROM PlaylistItems WHERE PlaylistId = 'abcdef123456'

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
Id [KEY] String The Id that YouTube uses to uniquely identify the playlist item.
PublishedAt Datetime The date and time that the item was added to the playlist. The value is specified in ISO 8601 (YYYY-MM-DDThh:mm:ss.sZ) format.
ChannelId String The Id that YouTube uses to uniquely identify the user that added the item to the playlist.
Title String The title of the item.
Description String The description of the item.
ThumbnailsDefaultUrl String The URL of the item.
ChannelTitle String The channel title of the channel that the playlist item belongs to.
VideoOwnerChannelTitle String The channel title of the channel that uploaded this video.
VideoOwnerChannelId String The channel ID of the channel that uploaded this video.
PlaylistId String The Id that YouTube uses to uniquely identify the playlist that the playlist item is in.
Position String The order in which the item appears in the playlist. The value uses a zero-based index, so the first item has a position of 0, the second item has a position of 1, and so forth.
ResourceIdKind String The kind, or type, of the referred resource.
ResourceIdVideoId String If the ResourceIdKind value of the column is youtube#video, then this column will be present and its value will contain the Id that YouTube uses to uniquely identify the video in the playlist.
VideoId String The Id that YouTube uses to uniquely identify a video. To retrieve the video resource, set the Id column to this value.
Note String A user-generated note for this item.
VideoOwnerPublishedAt Datetime The date and time that the video was published to YouTube. The value is specified in ISO 8601 (YYYY-MM-DDThh:mm:ss.sZ) format.
PrivacyStatus String The privacy status of the playlist item.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
OnBehalfOfContentOwner String This parameter is intended exclusively for YouTube content partners.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479