EndPoint Search

Name

Description

No description available [API reference]

Parameters

Parameter

Label

Required

Options

Description

part

YES

forMine

forMine (search in my account only)

Option	Value
true	true
false	false

If set to 'true', parameter 'type' must be set to 'video'.

query (search term)

type

Option	Value
channel	channel
playlist	playlist
video	video

Must be set to 'video' if 'forMine' is set to 'true'.

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_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

SSIS API Source - Read from table or endpoint

Search using API Destination

YouTube

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];