YouTube Connector
Documentation
Version: 3
Documentation

EndPoint Get playlists


Parameters

Parameter Label Required Options Description
part part YES
Option Value
contentDetails contentDetails
id id
localizations localizations
player player
snippet snippet
status status
id id NO Get playlist with this Id. If you pass this, don't set 'channelId' nor 'mine'.
channelId channelId NO Set this parameter to show playlists from the specified channel. If you pass this, don't set 'id' nor 'mine'.
mine mine NO
Option Value
true true
false false
Set this parameter to show playlists for my account. If you pass this, don't set 'id' nor 'channelId'.
hl hl NO
maxResults maxResults NO
onBehalfOfContentOwner onBehalfOfContentOwner NO
onBehalfOfContentOwnerChannel onBehalfOfContentOwnerChannel NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
id DT_WSTR nvarchar(136) 136 False
publishedAt DT_DBTIMESTAMP datetime False
channelId DT_WSTR nvarchar(96) 96 False
title DT_WSTR nvarchar(36) 36 False
description DT_NTEXT nvarchar(MAX) False
thumbnails_default_url DT_WSTR nvarchar(1000) 1000 False
thumbnails_default_width DT_I8 bigint False
thumbnails_default_height DT_I8 bigint False
thumbnails_medium_url DT_WSTR nvarchar(1000) 1000 False
thumbnails_medium_width DT_I8 bigint False
thumbnails_medium_height DT_I8 bigint False
thumbnails_high_url DT_WSTR nvarchar(1000) 1000 False
thumbnails_high_width DT_I8 bigint False
thumbnails_high_height DT_I8 bigint False
channelTitle DT_WSTR nvarchar(200) 200 False
localized_title DT_WSTR nvarchar(200) 200 False
localized_description DT_NTEXT nvarchar(MAX) False
thumbnails_standard_url DT_WSTR nvarchar(1000) 1000 False
thumbnails_standard_width DT_I8 bigint False
thumbnails_standard_height DT_I8 bigint False
status_privacyStatus DT_WSTR nvarchar(100) 100 False
contentDetails_itemCount DT_I8 bigint False
player_embedHtml DT_WSTR nvarchar(4000) 4000 False
kind DT_WSTR nvarchar(64) 64 False
etag DT_WSTR nvarchar(108) 108 False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw 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 component to read data or in API Destination component to read/write data:

Get playlists using API Source

YouTube
Get playlists
SSIS API Source - Read from table or endpoint

Get playlists using API Destination

YouTube
Get playlists
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get my playlists of specific channel

SELECT * FROM get_playlists WITH (channelId='UCVGOyzms_XJNk_DHqrffXCw')

SQL Server

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

Get my playlists of specific channel

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_playlists WITH (channelId=''UCVGOyzms_XJNk_DHqrffXCw'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_YOUTUBE_IN_DATA_GATEWAY];