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.

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
OnBehalfOfContentOwner	String	This parameter is intended exclusively for YouTube content partners.