Reference

Endpoint Get playlists

Name

get_playlists

Description

No description available [API reference]

Related Tables

MyPlaylists

Parameters

Parameter Required Options
Name: part

Label: part

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

Label: id

Get playlist with this Id. If you pass this, don't set 'channelId' nor 'mine'.
Name: channelId

Label: channelId

Set this parameter to show playlists from the specified channel. If you pass this, don't set 'id' nor 'mine'.
Name: mine

Label: mine

Set this parameter to show playlists for my account. If you pass this, don't set 'id' nor 'channelId'.
Option Value
true true
false false
Name: hl

Label: hl
Name: maxResults

Label: maxResults
Name: onBehalfOfContentOwner

Label: onBehalfOfContentOwner
Name: onBehalfOfContentOwnerChannel

Label: onBehalfOfContentOwnerChannel

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
id DT_WSTR nvarchar(136) 136
publishedAt DT_DBTIMESTAMP datetime
channelId DT_WSTR nvarchar(96) 96
title DT_WSTR nvarchar(36) 36
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
localized_title DT_WSTR nvarchar(200) 200
localized_description DT_NTEXT nvarchar(MAX)
thumbnails_standard_url DT_WSTR nvarchar(1000) 1000
thumbnails_standard_width DT_I8 bigint
thumbnails_standard_height DT_I8 bigint
status_privacyStatus DT_WSTR nvarchar(100) 100
contentDetails_itemCount DT_I8 bigint
player_embedHtml DT_WSTR nvarchar(4000) 4000
kind DT_WSTR nvarchar(64) 64
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

This Endpoint belongs to the MyPlaylists table, therefore it is better to use it, instead of accessing the endpoint directly:

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
MyPlaylists
Required Parameters
part Fill-in the parameter...
Optional Parameters
id
channelId
mine true
hl
maxResults 50
onBehalfOfContentOwner
onBehalfOfContentOwnerChannel
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the MyPlaylists table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get playlists:

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
MyPlaylists
Select
Required Parameters
part Fill-in the parameter...
Optional Parameters
id
channelId
mine true
hl
maxResults 50
onBehalfOfContentOwner
onBehalfOfContentOwnerChannel
SSIS API Destination - Access table operation

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')

Get playlists of my account 

SELECT * FROM MyPlaylists

Get my playlists of my account 

SELECT * FROM MyPlaylists

get_playlists endpoint belongs to MyPlaylists table(s), and can therefore be used via those table(s).

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 [LS_TO_YOUTUBE_IN_GATEWAY];

Get playlists of my account 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyPlaylists';

EXEC (@MyQuery) AT [LS_TO_YOUTUBE_IN_GATEWAY];

Get my playlists of my account 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyPlaylists';

EXEC (@MyQuery) AT [LS_TO_YOUTUBE_IN_GATEWAY];

get_playlists endpoint belongs to MyPlaylists table(s), and can therefore be used via those table(s).