Reference

Endpoint Get playlist items

Name

get_playlist_items

Description

No description available [API reference]

Parameters

Parameter Required Options
Name: part

Label: part

 YES
Option Value
contentDetails contentDetails
id id
snippet snippet
status status
Name: id

Label: id
Name: playlistId

Label: playlistId
Name: maxResults

Label: maxResults
Name: onBehalfOfContentOwner

Label: onBehalfOfContentOwner
Name: videoId

Label: videoId

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
id DT_WSTR nvarchar(272) 272
kind DT_WSTR nvarchar(80) 80
publishedAt DT_DBTIMESTAMP datetime
channelId DT_WSTR nvarchar(200) 200
title DT_WSTR nvarchar(500) 500
description DT_NTEXT nvarchar(MAX)
thumbnails_default_url DT_WSTR nvarchar(1000) 1000
thumbnails_default_width DT_I8 bigint
thumbnails_default_height DT_I8 bigint
thumbnails_medium_url DT_WSTR nvarchar(1000) 1000
thumbnails_medium_width DT_I8 bigint
thumbnails_medium_height DT_I8 bigint
thumbnails_high_url DT_WSTR nvarchar(1000) 1000
thumbnails_high_width DT_I8 bigint
thumbnails_high_height DT_I8 bigint
channelTitle DT_WSTR nvarchar(200) 200
playlistId DT_WSTR nvarchar(136) 136
position DT_I8 bigint
resourceId_kind DT_WSTR nvarchar(52) 52
resourceId_videoId DT_WSTR nvarchar(50) 50
videoOwnerChannelTitle DT_WSTR nvarchar(200) 200
videoOwnerChannelId DT_WSTR nvarchar(96) 96
contentDetails_videoId DT_WSTR nvarchar(50) 50
contentDetails_videoPublishedAt DT_DBTIMESTAMP datetime
status_privacyStatus DT_WSTR nvarchar(100) 100
etag DT_WSTR nvarchar(108) 108
If the column you are looking for is missing, consider customizing YouTube Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use YouTube Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - YouTube
Read / write YouTube data inside your app, perform many Youtube operations without coding using easy to use high performance API Connector for YouTube
YouTube
Get playlist items
Required Parameters
part Fill-in the parameter...
Optional Parameters
id
playlistId
maxResults 50
onBehalfOfContentOwner
videoId
SSIS API Source - Read from table or endpoint

API Destination

API Destination - YouTube
Read / write YouTube data inside your app, perform many Youtube operations without coding using easy to use high performance API Connector for YouTube
YouTube
Get playlist items
Required Parameters
part Fill-in the parameter...
Optional Parameters
id
playlistId
maxResults 50
onBehalfOfContentOwner
videoId
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get playlist items 

SELECT * FROM get_playlist_items
WITH
(
    "part" = 'contentDetails~id~snippet~status'
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get playlist items 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_playlist_items
WITH
(
    "part" = ''contentDetails~id~snippet~status''
)';

EXEC (@MyQuery) AT [LS_TO_YOUTUBE_IN_GATEWAY];