SSIS Components for YouTube Analytics

Build 21.0.7930


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'


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.
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.

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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930