EndPoint Get playlists
Name
get_playlists
Description
No description available [API reference]
Parameters
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

Get playlists using API Destination
YouTube
Get playlists

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