Endpoint

Get video details

Name

get_video_details

Description

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

Parameters

Parameter

Label

Required

Options

Description

part

YES

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

Ids (up to 25 comma-separated)

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

chart

Option	Value
mostPopular	mostPopular

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

myRating

Option	Value
like	like
dislike	dislike

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

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
id	`DT_WSTR`	`nvarchar(44)`	44	`False`
publishedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
channelId	`DT_WSTR`	`nvarchar(96)`	96	`False`
title	`DT_WSTR`	`nvarchar(255)`	255	`False`
description	`DT_NTEXT`	`nvarchar(MAX)`		`False`
thumbnails_default_url	`DT_WSTR`	`nvarchar(500)`	500	`False`
thumbnails_default_width	`DT_I8`	`bigint`		`False`
thumbnails_default_height	`DT_I8`	`bigint`		`False`
thumbnails_medium_url	`DT_WSTR`	`nvarchar(500)`	500	`False`
thumbnails_medium_width	`DT_I8`	`bigint`		`False`
thumbnails_medium_height	`DT_I8`	`bigint`		`False`
thumbnails_high_url	`DT_WSTR`	`nvarchar(500)`	500	`False`
thumbnails_high_width	`DT_I8`	`bigint`		`False`
thumbnails_high_height	`DT_I8`	`bigint`		`False`
channelTitle	`DT_WSTR`	`nvarchar(72)`	72	`False`
liveBroadcastContent	`DT_WSTR`	`nvarchar(500)`	500	`False`
categoryId	`DT_WSTR`	`nvarchar(500)`	500	`False`
localized_title	`DT_WSTR`	`nvarchar(500)`	500	`False`
localized_description	`DT_NTEXT`	`nvarchar(MAX)`		`False`
contentDetails_duration	`DT_WSTR`	`nvarchar(500)`	500	`False`
contentDetails_dimension	`DT_WSTR`	`nvarchar(500)`	500	`False`
contentDetails_definition	`DT_WSTR`	`nvarchar(500)`	500	`False`
contentDetails_caption	`DT_WSTR`	`nvarchar(500)`	500	`False`
contentDetails_licensedContent	`DT_BOOL`	`bit`		`False`
contentDetails_projection	`DT_WSTR`	`nvarchar(44)`	44	`False`
contentDetails_hasCustomThumbnail	`DT_BOOL`	`bit`		`False`
status_uploadStatus	`DT_WSTR`	`nvarchar(500)`	500	`False`
status_privacyStatus	`DT_WSTR`	`nvarchar(500)`	500	`False`
status_license	`DT_WSTR`	`nvarchar(100)`	100	`False`
status_embeddable	`DT_BOOL`	`bit`		`False`
status_publicStatsViewable	`DT_BOOL`	`bit`		`False`
status_madeForKids	`DT_BOOL`	`bit`		`False`
status_selfDeclaredMadeForKids	`DT_BOOL`	`bit`		`False`
viewCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
likeCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
dislikeCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
favoriteCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
commentCount	`DT_WSTR`	`nvarchar(20)`	20	`False`
player_embedHtml	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
topicDetails_topicCategories	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
fileDetails_fileName	`DT_WSTR`	`nvarchar(500)`	500	`False`
processingDetails_processingStatus	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_fileDetailsAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_processingIssuesAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_tagSuggestionsAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_editorSuggestionsAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
processingDetails_thumbnailsAvailability	`DT_WSTR`	`nvarchar(150)`	150	`False`
kind	`DT_WSTR`	`nvarchar(60)`	60	`False`
etag	`DT_WSTR`	`nvarchar(108)`	108	`False`

If the column you are looking for is missing, consider customizing YouTube Connector.

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:

Get video details using API Source

YouTube

Get video details

SSIS API Source - Read from table or endpoint

Get video details using API Destination

YouTube

Get video details

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get video details

SELECT * FROM get_video_details
WITH
(
    "part" = 'contentDetails~fileDetails~id~liveStreamingDetails~localizations~player~processingDetails~recordingDetails~snippet~statistics~status~suggestions~topicDetails'
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get video details

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_video_details
WITH
(
    "part" = ''contentDetails~fileDetails~id~liveStreamingDetails~localizations~player~processingDetails~recordingDetails~snippet~statistics~status~suggestions~topicDetails''
)';

EXEC (@MyQuery) AT [LS_TO_YOUTUBE_IN_GATEWAY];