YouTube Connector
Documentation
Version: 3
Documentation

EndPoint Search


Parameters

Parameter Label Required Options Description
part part YES
forMine forMine (search in my account only) NO
Option Value
true true
false false
If set to 'true', parameter 'type' must be set to 'video'.
q query (search term) NO
type type NO
Option Value
channel channel
playlist playlist
video video
Must be set to 'video' if 'forMine' is set to 'true'.
channelId channelId NO
channelType channelType NO
Option Value
any any
show show
eventType eventType NO
Option Value
completed completed
live live
upcoming upcoming
location location NO
locationRadius locationRadius NO
maxResults maxResults NO
onehalfOfContentOwner onehalfOfContentOwner NO
order order NO
Option Value
date date
rating rating
relevance relevance
title title
videoCount videoCount
viewCount viewCount
publishedAfter publishedAfter NO
publishedBefore publishedBefore NO
regionCode regionCode NO
relevanceLanguage relevanceLanguage NO
safeSearch safeSearch NO
Option Value
moderate moderate
none none
strict strict
topicId topicId NO
videoCaption videoCaption NO
Option Value
any any
closedCaption closedCaption
none none
videoCategoryId videoCategoryId NO
videoDefinition videoDefinition NO
Option Value
any any
high high
standard standard
videoDimension videoDimension NO
Option Value
2d 2d
3d 3d
any any
videoDuration videoDuration NO
Option Value
any any
long long
medium medium
short short
videoEmbeddable videoEmbeddable NO
Option Value
any any
true true
videoLicense videoLicense NO
Option Value
any any
creativeCommon creativeCommon
youtube youtube
videoSyndicated videoSyndicated NO
Option Value
any any
true true
videoType videoType NO
Option Value
any any
episode episode
movie movie
forContentOwner forContentOwner NO
Option Value
true true
false false
forDeveloper forDeveloper NO
Option Value
true true
false false
relatedToVideoId relatedToVideoId NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
id_kind DT_WSTR nvarchar(200) 200 False
videoId DT_WSTR nvarchar(100) 100 False
publishedAt DT_DBTIMESTAMP datetime False
title DT_WSTR nvarchar(1200) 1200 False
description DT_NTEXT nvarchar(MAX) False
channelId DT_WSTR nvarchar(300) 300 False
thumbnails_default_url DT_WSTR nvarchar(400) 400 False
thumbnails_default_width DT_I8 bigint False
thumbnails_default_height DT_I8 bigint False
thumbnails_medium_url DT_WSTR nvarchar(400) 400 False
thumbnails_medium_width DT_I8 bigint False
thumbnails_medium_height DT_I8 bigint False
thumbnails_high_url DT_WSTR nvarchar(400) 400 False
thumbnails_high_width DT_I8 bigint False
thumbnails_high_height DT_I8 bigint False
channelTitle DT_WSTR nvarchar(200) 200 False
liveBroadcastContent DT_WSTR nvarchar(200) 200 False
publishTime DT_DBTIMESTAMP datetime False
etag DT_WSTR nvarchar(300) 300 False
kind DT_WSTR nvarchar(150) 150 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:

Search using API Source

YouTube
Search
SSIS API Source - Read from table or endpoint

Search using API Destination

YouTube
Search
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Search for videos in whole YouTube

SELECT * FROM search WITH (q='ZappySys Tutorials', maxResults='50')

Search for videos in a channel

SELECT * FROM search WITH (q='GPU', maxResults='50', channelId='UCXuqSBlHAE6Xw-yeJA0Tunw')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Search for videos in whole YouTube

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM search WITH (q=''ZappySys Tutorials'', maxResults=''50'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_YOUTUBE_IN_DATA_GATEWAY];

Search for videos in a channel

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM search WITH (q=''GPU'', maxResults=''50'', channelId=''UCXuqSBlHAE6Xw-yeJA0Tunw'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_YOUTUBE_IN_DATA_GATEWAY];