Reference

Endpoint Get videos

Name

get_videos

Description

No description available

Related Tables

MyVideos

Parameters

Parameter Required Options
Name: forMine

Label: forMine (search in my account only)
Option Value
true true
false false
Name: q

Label: query (search term)
Name: channelId

Label: channelId
Name: channelType

Label: channelType
Option Value
any any
show show
Name: eventType

Label: eventType
Option Value
completed completed
live live
upcoming upcoming
Name: location

Label: location
Name: locationRadius

Label: locationRadius
Name: maxResults

Label: maxResults
Name: onehalfOfContentOwner

Label: onehalfOfContentOwner
Name: order

Label: order
Option Value
date date
rating rating
relevance relevance
title title
videoCount videoCount
viewCount viewCount
Name: publishedAfter

Label: publishedAfter
Name: publishedBefore

Label: publishedBefore
Name: regionCode

Label: regionCode
Name: relevanceLanguage

Label: relevanceLanguage
Name: safeSearch

Label: safeSearch
Option Value
moderate moderate
none none
strict strict
Name: topicId

Label: topicId
Name: videoCaption

Label: videoCaption
Option Value
any any
closedCaption closedCaption
none none
Name: videoCategoryId

Label: videoCategoryId
Name: videoDefinition

Label: videoDefinition
Option Value
any any
high high
standard standard
Name: videoDimension

Label: videoDimension
Option Value
2d 2d
3d 3d
any any
Name: videoDuration

Label: videoDuration
Option Value
any any
long long
medium medium
short short
Name: videoEmbeddable

Label: videoEmbeddable
Option Value
any any
true true
Name: videoLicense

Label: videoLicense
Option Value
any any
creativeCommon creativeCommon
youtube youtube
Name: videoSyndicated

Label: videoSyndicated
Option Value
any any
true true
Name: videoType

Label: videoType
Option Value
any any
episode episode
movie movie
Name: forContentOwner

Label: forContentOwner
Option Value
true true
false false
Name: forDeveloper

Label: forDeveloper
Option Value
true true
false false
Name: relatedToVideoId

Label: relatedToVideoId

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
id DT_WSTR nvarchar(44) 44
publishedAt DT_DBTIMESTAMP datetime
channelId DT_WSTR nvarchar(96) 96
title DT_WSTR nvarchar(255) 255
description DT_NTEXT nvarchar(MAX)
thumbnails_default_url DT_WSTR nvarchar(500) 500
thumbnails_default_width DT_I8 bigint
thumbnails_default_height DT_I8 bigint
thumbnails_medium_url DT_WSTR nvarchar(500) 500
thumbnails_medium_width DT_I8 bigint
thumbnails_medium_height DT_I8 bigint
thumbnails_high_url DT_WSTR nvarchar(500) 500
thumbnails_high_width DT_I8 bigint
thumbnails_high_height DT_I8 bigint
channelTitle DT_WSTR nvarchar(72) 72
liveBroadcastContent DT_WSTR nvarchar(500) 500
categoryId DT_WSTR nvarchar(500) 500
localized_title DT_WSTR nvarchar(500) 500
localized_description DT_NTEXT nvarchar(MAX)
contentDetails_duration DT_WSTR nvarchar(500) 500
contentDetails_dimension DT_WSTR nvarchar(500) 500
contentDetails_definition DT_WSTR nvarchar(500) 500
contentDetails_caption DT_WSTR nvarchar(500) 500
contentDetails_licensedContent DT_BOOL bit
contentDetails_projection DT_WSTR nvarchar(44) 44
contentDetails_hasCustomThumbnail DT_BOOL bit
status_uploadStatus DT_WSTR nvarchar(500) 500
status_privacyStatus DT_WSTR nvarchar(500) 500
status_license DT_WSTR nvarchar(100) 100
status_embeddable DT_BOOL bit
status_publicStatsViewable DT_BOOL bit
status_madeForKids DT_BOOL bit
status_selfDeclaredMadeForKids DT_BOOL bit
viewCount DT_WSTR nvarchar(20) 20
likeCount DT_WSTR nvarchar(20) 20
dislikeCount DT_WSTR nvarchar(20) 20
favoriteCount DT_WSTR nvarchar(20) 20
commentCount DT_WSTR nvarchar(20) 20
player_embedHtml DT_WSTR nvarchar(4000) 4000
topicDetails_topicCategories DT_WSTR nvarchar(4000) 4000
fileDetails_fileName DT_WSTR nvarchar(500) 500
processingDetails_processingStatus DT_WSTR nvarchar(150) 150
processingDetails_fileDetailsAvailability DT_WSTR nvarchar(150) 150
processingDetails_processingIssuesAvailability DT_WSTR nvarchar(150) 150
processingDetails_tagSuggestionsAvailability DT_WSTR nvarchar(150) 150
processingDetails_editorSuggestionsAvailability DT_WSTR nvarchar(150) 150
processingDetails_thumbnailsAvailability DT_WSTR nvarchar(150) 150
kind DT_WSTR nvarchar(60) 60
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 MyVideos 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
MyVideos
Optional Parameters
forMine (search in my account only) true
query (search term)
channelId
channelType
eventType
location
locationRadius
maxResults 50
onehalfOfContentOwner
order
publishedAfter
publishedBefore
regionCode
relevanceLanguage
safeSearch
topicId
videoCaption
videoCategoryId
videoDefinition
videoDimension
videoDuration
videoEmbeddable
videoLicense
videoSyndicated
videoType
forContentOwner
forDeveloper
relatedToVideoId
SSIS API Source - Read from table or endpoint

API Destination

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

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
MyVideos
Select
Optional Parameters
forMine (search in my account only) true
query (search term)
channelId
channelType
eventType
location
locationRadius
maxResults 50
onehalfOfContentOwner
order
publishedAfter
publishedBefore
regionCode
relevanceLanguage
safeSearch
topicId
videoCaption
videoCategoryId
videoDefinition
videoDimension
videoDuration
videoEmbeddable
videoLicense
videoSyndicated
videoType
forContentOwner
forDeveloper
relatedToVideoId
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

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