Endpoint Get channels
Name
get_channels
Description
No description available [API reference]
Related Tables
Parameters
Parameter | Required | Options | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Name:
Label: part |
YES |
|
||||||||||||||||||||||
Name:
Label: mine |
|
|||||||||||||||||||||||
Name:
Label: forUsername |
||||||||||||||||||||||||
Name:
Label: id |
||||||||||||||||||||||||
Name:
Label: managedByMe |
|
|||||||||||||||||||||||
Name:
Label: hl |
||||||||||||||||||||||||
Name:
Label: maxResults |
||||||||||||||||||||||||
Name:
Label: onBehalfOfContentOwner |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
---|---|---|---|---|
id |
DT_WSTR
|
nvarchar(96)
|
96 | |
title |
DT_WSTR
|
nvarchar(72)
|
72 | |
description |
DT_WSTR
|
nvarchar(80)
|
80 | |
publishedAt |
DT_DBTIMESTAMP
|
datetime
|
||
thumbnails_default_url |
DT_WSTR
|
nvarchar(480)
|
480 | |
thumbnails_default_width |
DT_I8
|
bigint
|
||
thumbnails_default_height |
DT_I8
|
bigint
|
||
thumbnails_medium_url |
DT_WSTR
|
nvarchar(484)
|
484 | |
thumbnails_medium_width |
DT_I8
|
bigint
|
||
thumbnails_medium_height |
DT_I8
|
bigint
|
||
thumbnails_high_url |
DT_WSTR
|
nvarchar(484)
|
484 | |
thumbnails_high_width |
DT_I8
|
bigint
|
||
thumbnails_high_height |
DT_I8
|
bigint
|
||
localized_title |
DT_WSTR
|
nvarchar(72)
|
72 | |
localized_description |
DT_WSTR
|
nvarchar(80)
|
80 | |
contentDetails_relatedPlaylists_likes |
DT_WSTR
|
nvarchar(8)
|
8 | |
contentDetails_relatedPlaylists_uploads |
DT_WSTR
|
nvarchar(96)
|
96 | |
statistics_viewCount |
DT_WSTR
|
nvarchar(8)
|
8 | |
statistics_subscriberCount |
DT_WSTR
|
nvarchar(4)
|
4 | |
statistics_hiddenSubscriberCount |
DT_BOOL
|
bit
|
||
statistics_videoCount |
DT_WSTR
|
nvarchar(4)
|
4 | |
status_privacyStatus |
DT_WSTR
|
nvarchar(24)
|
24 | |
status_isLinked |
DT_BOOL
|
bit
|
||
status_longUploadsStatus |
DT_WSTR
|
nvarchar(32)
|
32 | |
brandingSettings_channel_title |
DT_WSTR
|
nvarchar(72)
|
72 | |
auditDetails_overallGoodStanding |
DT_BOOL
|
bit
|
||
auditDetails_communityGuidelinesGoodStanding |
DT_BOOL
|
bit
|
||
auditDetails_copyrightStrikesGoodStanding |
DT_BOOL
|
bit
|
||
auditDetails_contentIdClaimsGoodStanding |
DT_BOOL
|
bit
|
||
etag |
DT_WSTR
|
nvarchar(108)
|
108 | |
kind |
DT_WSTR
|
nvarchar(60)
|
60 |
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 MyChannels table, therefore it is better to use it, instead of accessing the endpoint directly:
Required Parameters | |
---|---|
part | Fill-in the parameter... |
Optional Parameters | |
mine | |
forUsername | |
id | |
managedByMe | |
hl | |
maxResults | 50 |
onBehalfOfContentOwner |

API Destination
This Endpoint belongs to the MyChannels table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get channels:
Required Parameters | |
---|---|
part | Fill-in the parameter... |
Optional Parameters | |
mine | |
forUsername | |
id | |
managedByMe | |
hl | |
maxResults | 50 |
onBehalfOfContentOwner |

ODBC application
Use these SQL queries in your ODBC application data source:
Get channels by ids
SELECT *
FROM get_channels
WITH(
id='UC2d5diIOoCEa47p4PjpIHya,AC2d5diIOoCEa47p4PjpIHyQ,TC2d5diIOoCEa47p4PjpIHyI'
)
Get channels of my account
SELECT * FROM MyChannels
get_channels
endpoint belongs to
MyChannels
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 channels by ids
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM get_channels
WITH(
id=''UC2d5diIOoCEa47p4PjpIHya,AC2d5diIOoCEa47p4PjpIHyQ,TC2d5diIOoCEa47p4PjpIHyI''
)';
EXEC (@MyQuery) AT [LS_TO_YOUTUBE_IN_GATEWAY];
Get channels of my account
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM MyChannels';
EXEC (@MyQuery) AT [LS_TO_YOUTUBE_IN_GATEWAY];
get_channels
endpoint belongs to
MyChannels
table(s), and can therefore be used via those table(s).