YouTube Connector

YouTube Connector

The high-performance YouTube Connector provides read/write capabilities within your application, allowing you to perform numerous YouTube operations with minimal coding or even no-coding at all. Integrate YouTube data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate YouTube with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

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
hl
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
id 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
hl
maxResults
onBehalfOfContentOwner
onBehalfOfContentOwnerChannel
 Get playlist items
   [ Read more... ]
Parameter Description
part
Option Value
contentDetails contentDetails
id id
snippet snippet
status status
id
playlistId
maxResults
onBehalfOfContentOwner
videoId
 Get comments
   [ Read more... ]
Parameter Description
part
Option Value
id id
replies replies
snippet snippet
allThreadsRelatedToChannelId
channelId
id
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
id
managedByMe
Option Value
true true
false false
hl
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
 Search
   [ 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) 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
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) using either raw file data (i.e., POST raw file data) or send data using the multi-part encoding method (i.e. Content-Type: multipart/form-data). A multi-part request allows you to mix key/value pairs and upload files in the same request. On the other hand, raw upload allows only a single file to be uploaded (without any key/value data). ==== Raw Upload (Content-Type: application/octet-stream) ===== To upload a single file in raw mode, check this option and specify the full file path starting with the @ 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 in the RequestData field (i.e., Body). Each key/value pair should be entered on a new line, and key/value are separated using an equal sign (=). Leading and trailing spaces are ignored, and blank lines are also ignored. If a field value contains any special character(s), use escape sequences (e.g., for NewLine: \r\n, for Tab: \t, for at (@): @). When the value of any field starts with the at sign (@), it is automatically treated as a file you want to upload. By default, the file content type is determined based on the file extension; however, you can supply a content type manually for any field using this format: [YourFileFieldName.Content-Type=some-content-type]. By default, file upload fields always include Content-Type in the request (non-file fields do not have Content-Type by default unless you supply it manually). If, for some reason, you don't want to use the Content-Type header in your request, then supply a blank Content-Type to exclude this header altogether (e.g., SomeFieldName.Content-Type=). In the example below, we have supplied Content-Type for file2 and SomeField1. All other fields are using the default content type. See the example below 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 start with multipart/ or it 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) using either raw file data (i.e., POST raw file data) or send data using the multi-part encoding method (i.e. Content-Type: multipart/form-data). A multi-part request allows you to mix key/value pairs and upload files in the same request. On the other hand, raw upload allows only a single file to be uploaded (without any key/value data). ==== Raw Upload (Content-Type: application/octet-stream) ===== To upload a single file in raw mode, check this option and specify the full file path starting with the @ 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 in the RequestData field (i.e., Body). Each key/value pair should be entered on a new line, and key/value are separated using an equal sign (=). Leading and trailing spaces are ignored, and blank lines are also ignored. If a field value contains any special character(s), use escape sequences (e.g., for NewLine: \r\n, for Tab: \t, for at (@): @). When the value of any field starts with the at sign (@), it is automatically treated as a file you want to upload. By default, the file content type is determined based on the file extension; however, you can supply a content type manually for any field using this format: [YourFileFieldName.Content-Type=some-content-type]. By default, file upload fields always include Content-Type in the request (non-file fields do not have Content-Type by default unless you supply it manually). If, for some reason, you don't want to use the Content-Type header in your request, then supply a blank Content-Type to exclude this header altogether (e.g., SomeFieldName.Content-Type=). In the example below, we have supplied Content-Type for file2 and SomeField1. All other fields are using the default content type. See the example below 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 start with multipart/ or it 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 within SQL Server or any other 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 SQL Server and ODBC