YouTube Connector

ZappySys YouTube Connector provide read / write capability inside your app (see list below), using these drag and drop, high performance connector you can perform many YouTube operations without any coding. You can use this connector to integrate YouTube data inside apps like SSIS, SQL Server or popular ETL Platforms / BI Tools/ Reporting Apps / Programming languages (i.e. Informatica, Power BI, SSRS, Excel, C#, JAVA, Python).

Download for SSIS Download for Other Apps Documentation

Integrate YouTube with these apps

SSIS

SQL Server

Power BI

SSRS

Informatica

MS Access

MS Excel

SSAS

Python

JAVA

Tableau

SAP Crystal Reports

Azure Data Factory (Pipeline)

Azure Data Factory (SSIS)

Talend Studio

UiPath

PowerShell

ODBC

Actions supported by YouTube Connector

YouTube Connector support following actions for REST API integration. If some actions are not listed below then you can easily edit Connector file and enhance out of the box functionality.

Get video details

Read videos details by IDs or chart or myRating (pass one of them) [ Read more... ]

Parameter

Description

Ids (up to 25 comma-separated)

Comma-separated IDs of YouTube videos (max 25 IDs)

chart

The chart parameter identifies the chart that you want to retrieve.

Option	Value
mostPopular	mostPopular

myRating

Option	Value
like	like
dislike	dislike

part

Option	Value
contentDetails	contentDetails
fileDetails	fileDetails
id	id
liveStreamingDetails	liveStreamingDetails
localizations	localizations
player	player
processingDetails	processingDetails
recordingDetails	recordingDetails
snippet	snippet
statistics	statistics
status	status
suggestions	suggestions
topicDetails	topicDetails

maxHeight

Acceptable values are 72 to 8192, inclusive.

maxResults

Acceptable values are 1 to 50, inclusive. Default value is 5.

maxWidth

Acceptable values are 72 to 8192, inclusive.

onBehalfOfContentOwner

regionCode

videoCategoryId

Get videos rating

[ Read more... ]

Parameter	Description
id
onBehalfOfContentOwner

Get playlists

[ Read more... ]

Parameter

Description

part

Option	Value
contentDetails	contentDetails
id	id
localizations	localizations
player	player
snippet	snippet
status	status

Get playlist with this Id. If you pass this, don't set 'channelId' nor 'mine'.

channelId

Set this parameter to show playlists from the specified channel. If you pass this, don't set 'id' nor 'mine'.

mine

Set this parameter to show playlists for my account. If you pass this, don't set 'id' nor 'channelId'.

Option	Value
true	true
false	false

maxResults

onBehalfOfContentOwner

onBehalfOfContentOwnerChannel

Get playlist items

[ Read more... ]

Parameter

Description

part

Option	Value
contentDetails	contentDetails
id	id
snippet	snippet
status	status

playlistId

maxResults

onBehalfOfContentOwner

videoId

Get comments

[ Read more... ]

Parameter

Description

part

Option	Value
id	id
replies	replies
snippet	snippet

allThreadsRelatedToChannelId

channelId

videoId

maxResults

moderationStatus

Option	Value
heldForReview	heldForReview
likelySpam	likelySpam
published	published

order

Option	Value
time	time
relevance	relevance

searchTerms

textFormat

Option	Value
html	html
plainText	plainText

Get channels

[ Read more... ]

Parameter

Description

part

Option	Value
auditDetails	auditDetails
brandingSettings	brandingSettings
contentDetails	contentDetails
contentOwnerDetails	contentOwnerDetails
id	id
localizations	localizations
snippet	snippet
statistics	statistics
status	status
topicDetails	topicDetails

mine

Option	Value
true	true
false	false

forUsername

managedByMe

Option	Value
true	true
false	false

maxResults

onBehalfOfContentOwner

Get videos

[ Read more... ]

Parameter

Description

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

[ Read more... ]

Parameter

Description

part

forMine (search in my account only)

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

Option	Value
true	true
false	false

query (search term)

type

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

Option	Value
channel	channel
playlist	playlist
video	video

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

Get report

[ Read more... ]

Parameter

Description

ids

Option	Value
Filter1	channel==MINE
Filter2	channel==ENTER_CHANNEL_ID
Filter3	contentOwner==ENTER_OWNER_NAME

metrics

Option	Value
adEarnings	adEarnings
annotationImpressions	annotationImpressions
annotationClickableImpressions	annotationClickableImpressions
annotationClicks	annotationClicks
annotationClickThroughRate	annotationClickThroughRate
annotationClosableImpressions	annotationClosableImpressions
annotationCloses	annotationCloses
annotationCloseRate	annotationCloseRate
audienceWatchRatio	audienceWatchRatio
averageViewDuration	averageViewDuration
averageViewPercentage	averageViewPercentage
cardClickRate	cardClickRate
cardClicks	cardClicks
cardImpressions	cardImpressions
cardTeaserClickRate	cardTeaserClickRate
cardTeaserClicks	cardTeaserClicks
cardTeaserImpressions	cardTeaserImpressions
comments	comments
dislikes	dislikes
earnings	earnings
estimatedMinutesWatched	estimatedMinutesWatched
estimatedPartnerAdSenseRevenue	estimatedPartnerAdSenseRevenue
estimatedPartnerDoubleClickRevenue	estimatedPartnerDoubleClickRevenue
grossRevenue	grossRevenue
impressionBasedCpm	impressionBasedCpm
impressions	impressions
likes	likes
monetizedPlaybacks	monetizedPlaybacks
playbackBasedCpm	playbackBasedCpm
playlistStarts	playlistStarts
savesAdded	savesAdded
savesRemoved	savesRemoved
shares	shares
subscribersGained	subscribersGained
subscribersLost	subscribersLost
videosAddedToPlaylists	videosAddedToPlaylists
videosRemovedFromPlaylists	videosRemovedFromPlaylists
viewerPercentage	viewerPercentage
views	views

Start Date (yyyy-MM-dd)

The date for which to retrieve the report in YYYYMMDD format. Supported functions now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

End Date (yyyy-MM-dd)

Option	Value
today	today
yesterday	yesterday
monthstart	monthstart
monthend	monthend
yearstart	yearstart
yearend	yearend
weekstart	weekstart
weekend	weekend
yearstart-1y	yearstart-1y
yearend-1y	yearend-1y
monthstart-1d	monthstart-1d
monthend+1d	monthend+1d

currency

dimensions

Option	Value
adType	adType
ageGroup	ageGroup
asset	asset
audienceType	audienceType
channel	channel
claimedStatus	claimedStatus
contentOwner	contentOwner
country	country
day	day
deviceType	deviceType
elapsedVideoTimeRatio	elapsedVideoTimeRatio
gender	gender
insightPlaybackLocationDetail	insightPlaybackLocationDetail
insightPlaybackLocationType	insightPlaybackLocationType
insightTrafficSourceDetail	insightTrafficSourceDetail
insightTrafficSourceType	insightTrafficSourceType
liveOrOnDemand	liveOrOnDemand
operatingSystem	operatingSystem
playlist	playlist
province	province
sharingService	sharingService
subscribedStatus	subscribedStatus
subtitleLanguage	subtitleLanguage
uploaderType	uploaderType
video	video

filters

A list of filters that should be applied when retrieving YouTube Analytics data. The documentation for channel reports and content owner reports identifies the dimensions that can be used to filter each report, and the Dimensions document defines those dimensions.

Option	Value
Example1	country==IT
Example2	video==dMH0bHeiRNg
Example3	gender==FEMALE
Example4	dimension==some_value

includeHistoricalChannelData

Option	Value
true	true
false	false

maxResults

sort

A comma-separated list of dimensions or metrics that determine the sort order for YouTube Analytics data. By default the sort order is ascending. The - prefix causes descending sort order.

Option	Value
adType	adType
ageGroup	ageGroup
asset	asset
audienceType	audienceType
channel	channel
claimedStatus	claimedStatus
contentOwner	contentOwner
country	country
day	day
deviceType	deviceType
elapsedVideoTimeRatio	elapsedVideoTimeRatio
gender	gender
insightPlaybackLocationDetail	insightPlaybackLocationDetail
insightPlaybackLocationType	insightPlaybackLocationType
insightTrafficSourceDetail	insightTrafficSourceDetail
insightTrafficSourceType	insightTrafficSourceType
liveOrOnDemand	liveOrOnDemand
operatingSystem	operatingSystem
playlist	playlist
province	province
sharingService	sharingService
subscribedStatus	subscribedStatus
subtitleLanguage	subtitleLanguage
uploaderType	uploaderType
video	video

Generic Request

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL. [ Read more... ]

Parameter

Description

Url

API URL goes here. You can enter full URL or Partial URL relative to Base URL. If it is full URL then domain name must be part of ServiceURL or part of TrustedDomains

Body

Request Body content goes here

IsMultiPart

Set this option if you want to upload file(s) (i.e. POST RAW file data) or send data using Multi-Part encoding method (i.e. Content-Type: multipart/form-data). Multi-Part request allows you to mix key/value and upload files in same request. On the other hand raw upload allows only single file upload (without any key/value) ==== Raw Upload (Content-Type: application/octet-stream) ===== To upload single file in raw mode check this option and specify full file path starting with @ sign in the Body (e.g. @c:\data\myfile.zip ) ==== Form-Data / Multipart Upload (Content-Type: multipart/form-data) ===== To treat your Request data as multi part fields you must specify key/value pairs separated by new lines into RequestData field (i.e. Body). Each key value pair is entered on new-line and key/value are separated using equal sign (=). Preceding and trailing spaces are ignored also blank lines are ignored. If field value has some any special character(s) then use escape sequence (e.g. For NewLine: \r\n, For Tab: \t, For at (@): \@). When value of any field starts with at sign (@) its automatically treated as File you want to upload. By default file content type is determined based on extension however you can supply content type manually for any field using this way [ YourFileFieldName.Content-Type=some-content-type ]. By default File Upload Field always includes Content-Type in the request (non file fields do not have content-type by default unless you supply manually). For some reason if you dont want to use Content-Type header in your request then supply blank Content-Type to exclude this header altogather [e.g. SomeFieldName.Content-Type= ]. In below example we have supplied Content-Type for file2 and SomeField1, all other fields are using default content-type. See below Example of uploading multiple files along with additional fields. If some API requires you to pass Content-Type: multipart/form-data rather than multipart/form-data then manually set Request Header => Content-Type: multipart/mixed (it must starts with multipart/ else will be ignored). file1=@c:\data\Myfile1.txt file2=@c:\data\Myfile2.json file2.Content-Type=application/json SomeField1=aaaaaaa SomeField1.Content-Type=text/plain SomeField2=12345 SomeFieldWithNewLineAndTab=This is line1\r\nThis is line2\r\nThis is \ttab \ttab \ttab SomeFieldStartingWithAtSign=\@MyTwitterHandle

Filter

Enter filter to extract array from response. Example: $.rows[*] --OR-- $.customers[*].orders[*]. Check your response document and find out hierarchy you like to extract

Option	Value
No filter
Example1	$.store.books[*]
Example2 (Sections Under Books)	$.store.books[].sections[]
Example3 (Equals)	$.store.books[?(@author=='sam')]
Example4 (Equals - Any Section)	$..[?(@author=='sam')]
Example5 (Not Equals - Any Section)	$..[?(@author!='sam')]
Example6 (Number less than)	$.store.books[?(@.price<10)] Example7 (Regular Expression - Contains Pattern)=$.store.books[?(@author=~ /sam\|bob/ )]
Example8 (Regular Expression - Does Not Contain Pattern)	$.store.books[?(@author=~ /^((?!sam\|bob).)*$/ )]
Example9 (Regular Expression - Exact Pattern Match)	$.store.books[?(@author=~ /^sam\|bob$/ )]
Example10 (Regular Expression - Starts With)	$.store.books[?(@author=~ /^sam/ )]
Example11 (Regular Expression - Ends With)	$.store.books[?(@author=~ /sam$/ )]
Example12 (Between)	$.store.employees[?( @.hiredate>'2015-01-01' && @.hiredate<'2015-01-04' )]

Headers

Headers for Request. To enter multiple headers use double pipe or new line after each {header-name}:{value} pair

Generic Request (Bulk Write)

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL. [ Read more... ]

Parameter	Description
Url	API URL goes here. You can enter full URL or Partial URL relative to Base URL. If it is full URL then domain name must be part of ServiceURL or part of TrustedDomains
IsMultiPart	Set this option if you want to upload file(s) (i.e. POST RAW file data) or send data using Multi-Part encoding method (i.e. Content-Type: multipart/form-data). Multi-Part request allows you to mix key/value and upload files in same request. On the other hand raw upload allows only single file upload (without any key/value) ==== Raw Upload (Content-Type: application/octet-stream) ===== To upload single file in raw mode check this option and specify full file path starting with @ sign in the Body (e.g. @c:\data\myfile.zip ) ==== Form-Data / Multipart Upload (Content-Type: multipart/form-data) ===== To treat your Request data as multi part fields you must specify key/value pairs separated by new lines into RequestData field (i.e. Body). Each key value pair is entered on new-line and key/value are separated using equal sign (=). Preceding and trailing spaces are ignored also blank lines are ignored. If field value has some any special character(s) then use escape sequence (e.g. For NewLine: \r\n, For Tab: \t, For at (@): \@). When value of any field starts with at sign (@) its automatically treated as File you want to upload. By default file content type is determined based on extension however you can supply content type manually for any field using this way [ YourFileFieldName.Content-Type=some-content-type ]. By default File Upload Field always includes Content-Type in the request (non file fields do not have content-type by default unless you supply manually). For some reason if you dont want to use Content-Type header in your request then supply blank Content-Type to exclude this header altogather [e.g. SomeFieldName.Content-Type= ]. In below example we have supplied Content-Type for file2 and SomeField1, all other fields are using default content-type. See below Example of uploading multiple files along with additional fields. If some API requires you to pass Content-Type: multipart/form-data rather than multipart/form-data then manually set Request Header => Content-Type: multipart/mixed (it must starts with multipart/ else will be ignored). file1=@c:\data\Myfile1.txt file2=@c:\data\Myfile2.json file2.Content-Type=application/json SomeField1=aaaaaaa SomeField1.Content-Type=text/plain SomeField2=12345 SomeFieldWithNewLineAndTab=This is line1\r\nThis is line2\r\nThis is \ttab \ttab \ttab SomeFieldStartingWithAtSign=\@MyTwitterHandle
Filter	Enter filter to extract array from response. Example: $.rows[] --OR-- $.customers[].orders[*]. Check your response document and find out hierarchy you like to extract
Headers	Headers for Request. To enter multiple headers use double pipe (\|\|) or new line after each {header-name}:{value} pair

SQL examples for YouTube Connector

Use these example YouTube SQL queries in any ODBC-compatible application:

Get videos of my account [ Read more... ]

SELECT * FROM MyVideos

Get channels of my account [ Read more... ]

SELECT * FROM MyChannels

Get playlists of my account [ Read more... ]

SELECT * FROM MyPlaylists

Get comments of a video [ Read more... ]

SELECT * FROM get_comments WITH (videoId='INPUT_YOUR_VIDEO_ID')

Get comments of a channel [ Read more... ]

SELECT * FROM get_comments WITH (channelId='INPUT_YOUR_CHANNEL_ID')

Get my playlists of my account [ Read more... ]

SELECT * FROM MyPlaylists

Get my playlists of specific channel [ Read more... ]

SELECT * FROM get_playlists WITH (channelId='UCVGOyzms_XJNk_DHqrffXCw')

Search for videos in whole YouTube [ Read more... ]

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

Search for videos in a channel [ Read more... ]

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

Get channels by ids [ Read more... ]

SELECT *
FROM get_channels
WITH(
	  id='UC2d5diIOoCEa47p4PjpIHya,AC2d5diIOoCEa47p4PjpIHyQ,TC2d5diIOoCEa47p4PjpIHyI'
)

Gets a report of specific channel [ Read more... ]

SELECT *
FROM get_report
WITH(
	  ids='channel==ENTER_CHANNEL_ID'
	, metrics='likes~shares~views'
	, startDate='2022-08-01'
	, endDate='2022-08-30'
)

Gets a report of my channel with relative date [ Read more... ]

SELECT *
FROM get_report
WITH(
      ids='channel==MINE'
    , metrics='likes~shares~views'
    , startDate='yearstart' --OR put date like '2022-08-01'
    , endDate='today' --OR put date like '2022-08-01'
    , dimensions='country'
)

Download for SSIS Download for Other Apps