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
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'
|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.|
|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.|
|PrivacyStatus||String||The privacy status of the playlist item.|
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
|OnBehalfOfContentOwner||String||This parameter is intended exclusively for YouTube content partners.|