YouTube Connectors

ZappySys YouTube Connector provide read / write capability inside your app (see list below), using these drag and drop , high performance connectors 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

Video Tutorial - YouTube - Connectors REST API Integration

Click on your App below to get started with YouTube Integration

Choose your App / Scenario for which you like to integrate YouTube
YouTube Connector for SSIS
SSIS
YouTube Connector for SQL Server
SQL Server
YouTube Connector for Power BI
Power BI
YouTube Connector for SSRS
SSRS
YouTube Connector for Informatica
Informatica
YouTube Connector for MS Access
MS Access
YouTube Connector for MS Excel
MS Excel
YouTube Connector for SSAS
SSAS
YouTube Connector for C#
C#
YouTube Connector for Python
Python
YouTube Connector for JAVA
JAVA
YouTube Connector for Tableau
Tableau
YouTube Connector for SAP Crystal Reports
SAP Crystal Reports
YouTube Connector for Azure Data Factory (ADF)
Azure Data Factory (ADF)
YouTube Connector for ODBC
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)
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
Parameter Description
id
onBehalfOfContentOwner
 Get playlists
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
Parameter Description
part
Option Value
contentDetails contentDetails
id id
snippet snippet
status status
id
playlistId
maxResults
onBehalfOfContentOwner
videoId
 Get comments
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
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
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
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
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.
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 Check 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