Reference

Endpoint Search

Name

search

Description

No description available [API reference]

Parameters

Parameter Required Options
Name: part

Label: part

 YES
Name: forMine

Label: forMine (search in my account only)

If set to 'true', parameter 'type' must be set to 'video'.
Option Value
true true
false false
Name: q

Label: query (search term)
Name: type

Label: type

Must be set to 'video' if 'forMine' is set to 'true'.
Option Value
channel channel
playlist playlist
video video
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_kind DT_WSTR nvarchar(200) 200
videoId DT_WSTR nvarchar(100) 100
publishedAt DT_DBTIMESTAMP datetime
title DT_WSTR nvarchar(1200) 1200
description DT_NTEXT nvarchar(MAX)
channelId DT_WSTR nvarchar(300) 300
thumbnails_default_url DT_WSTR nvarchar(400) 400
thumbnails_default_width DT_I8 bigint
thumbnails_default_height DT_I8 bigint
thumbnails_medium_url DT_WSTR nvarchar(400) 400
thumbnails_medium_width DT_I8 bigint
thumbnails_medium_height DT_I8 bigint
thumbnails_high_url DT_WSTR nvarchar(400) 400
thumbnails_high_width DT_I8 bigint
thumbnails_high_height DT_I8 bigint
channelTitle DT_WSTR nvarchar(200) 200
liveBroadcastContent DT_WSTR nvarchar(200) 200
publishTime DT_DBTIMESTAMP datetime
etag DT_WSTR nvarchar(300) 300
kind DT_WSTR nvarchar(150) 150
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

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
Search
Required Parameters
part Fill-in the parameter...
Optional Parameters
forMine (search in my account only) true
query (search term)
type video
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

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
Search
Required Parameters
part Fill-in the parameter...
Optional Parameters
forMine (search in my account only) true
query (search term)
type video
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 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 [LS_TO_YOUTUBE_IN_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 [LS_TO_YOUTUBE_IN_GATEWAY];