Endpoint

Get videos

Name

get_videos

Description

No description available

Related Tables

MyVideos

Parameters

Parameter

Label

Required

Options

Description

forMine

forMine (search in my account only)

Option	Value
true	true
false	false

query (search term)

channelId

channelType

Option	Value
any	any
show	show

eventType

Option	Value
completed	completed
live	live
upcoming	upcoming

location

locationRadius

maxResults

onehalfOfContentOwner

order

Option	Value
date	date
rating	rating
relevance	relevance
title	title
videoCount	videoCount
viewCount	viewCount

publishedAfter

publishedBefore

regionCode

relevanceLanguage

safeSearch

Option	Value
moderate	moderate
none	none
strict	strict

topicId

videoCaption

Option	Value
any	any
closedCaption	closedCaption
none	none

videoCategoryId

videoDefinition

Option	Value
any	any
high	high
standard	standard

videoDimension

Option	Value
2d	2d
3d	3d
any	any

videoDuration

Option	Value
any	any
long	long
medium	medium
short	short

videoEmbeddable

Option	Value
any	any
true	true

videoLicense

Option	Value
any	any
creativeCommon	creativeCommon
youtube	youtube

videoSyndicated

Option	Value
any	any
true	true

videoType

Option	Value
any	any
episode	episode
movie	movie

forContentOwner

Option	Value
true	true
false	false

forDeveloper

Option	Value
true	true
false	false

relatedToVideoId

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(44)`	44	`False`
publishedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
channelId	`DT_WSTR`	`nvarchar(96)`	96	`False`
title	`DT_WSTR`	`nvarchar(255)`	255	`False`
description	`DT_NTEXT`	`nvarchar(MAX)`		`False`
thumbnails_default_url	`DT_WSTR`	`nvarchar(500)`	500	`False`
thumbnails_default_width	`DT_I8`	`bigint`		`False`
thumbnails_default_height	`DT_I8`	`bigint`		`False`
thumbnails_medium_url	`DT_WSTR`	`nvarchar(500)`	500	`False`
thumbnails_medium_width	`DT_I8`	`bigint`		`False`
thumbnails_medium_height	`DT_I8`	`bigint`		`False`
thumbnails_high_url	`DT_WSTR`	`nvarchar(500)`	500	`False`
thumbnails_high_width	`DT_I8`	`bigint`		`False`
thumbnails_high_height	`DT_I8`	`bigint`		`False`
channelTitle	`DT_WSTR`	`nvarchar(72)`	72	`False`
liveBroadcastContent	`DT_WSTR`	`nvarchar(500)`	500	`False`
categoryId	`DT_WSTR`	`nvarchar(500)`	500	`False`
localized_title	`DT_WSTR`	`nvarchar(500)`	500	`False`
localized_description	`DT_NTEXT`	`nvarchar(MAX)`		`False`
contentDetails_duration	`DT_WSTR`	`nvarchar(500)`	500	`False`
contentDetails_dimension	`DT_WSTR`	`nvarchar(500)`	500	`False`
contentDetails_definition	`DT_WSTR`	`nvarchar(500)`	500	`False`
contentDetails_caption	`DT_WSTR`	`nvarchar(500)`	500	`False`
contentDetails_licensedContent	`DT_BOOL`	`bit`		`False`
contentDetails_projection	`DT_WSTR`	`nvarchar(44)`	44	`False`
contentDetails_hasCustomThumbnail	`DT_BOOL`	`bit`		`False`
status_uploadStatus	`DT_WSTR`	`nvarchar(500)`	500	`False`
status_privacyStatus	`DT_WSTR`	`nvarchar(500)`	500	`False`
status_license	`DT_WSTR`	`nvarchar(100)`	100	`False`
status_embeddable	`DT_BOOL`	`bit`		`False`
status_publicStatsViewable	`DT_BOOL`	`bit`		`False`
status_madeForKids	`DT_BOOL`	`bit`		`False`
status_selfDeclaredMadeForKids	`DT_BOOL`	`bit`		`False`
viewCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
likeCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
dislikeCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
favoriteCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
commentCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
player_embedHtml	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
topicDetails_topicCategories	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
fileDetails_fileName	`DT_WSTR`	`nvarchar(500)`	500	`False`
processingDetails_processingStatus	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_fileDetailsAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_processingIssuesAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_tagSuggestionsAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_editorSuggestionsAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_thumbnailsAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
kind	`DT_WSTR`	`nvarchar(60)`	60	`False`
etag	`DT_WSTR`	`nvarchar(108)`	108	`False`

If the column you are looking for is missing, consider customizing YouTube Connector.

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:

Read from MyVideos table using API Destination

This Endpoint belongs to MyVideos table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

YouTube

MyVideos

Select

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get videos

SELECT * FROM get_videos

Get videos of my account

SELECT * FROM MyVideos

get_videos endpoint belongs to MyVideos 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 videos

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

EXEC (@MyQuery) AT [LS_TO_YOUTUBE_IN_GATEWAY];

Get videos of my account

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

EXEC (@MyQuery) AT [LS_TO_YOUTUBE_IN_GATEWAY];

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