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