YouTube Connector
Documentation
Version: 3
Documentation

EndPoint Get comments


Parameters

Parameter Label Required Options Description
part part YES
Option Value
id id
replies replies
snippet snippet
allThreadsRelatedToChannelId allThreadsRelatedToChannelId NO
channelId channelId NO
id id NO
videoId videoId NO
maxResults maxResults NO
moderationStatus moderationStatus NO
Option Value
heldForReview heldForReview
likelySpam likelySpam
published published
order order NO
Option Value
time time
relevance relevance
searchTerms searchTerms NO
textFormat textFormat NO
Option Value
html html
plainText plainText

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
id DT_WSTR nvarchar(104) 104 False
videoId DT_WSTR nvarchar(44) 44 False
topLevelComment_kind DT_WSTR nvarchar(60) 60 False
topLevelComment_etag DT_WSTR nvarchar(108) 108 False
topLevelComment_id DT_WSTR nvarchar(104) 104 False
topLevelComment_videoId DT_WSTR nvarchar(44) 44 False
topLevelComment_textDisplay DT_WSTR nvarchar(96) 96 False
topLevelComment_textOriginal DT_WSTR nvarchar(96) 96 False
topLevelComment_authorDisplayName DT_WSTR nvarchar(72) 72 False
topLevelComment_authorProfileImageUrl DT_WSTR nvarchar(480) 480 False
topLevelComment_authorChannelUrl DT_WSTR nvarchar(220) 220 False
topLevelComment_authorChannelId_value DT_WSTR nvarchar(96) 96 False
topLevelComment_canRate DT_BOOL bit False
topLevelComment_viewerRating DT_WSTR nvarchar(16) 16 False
topLevelComment_likeCount DT_I8 bigint False
topLevelComment_publishedAt DT_DBTIMESTAMP datetime False
topLevelComment_updatedAt DT_DBTIMESTAMP datetime False
canReply DT_BOOL bit False
totalReplyCount DT_I8 bigint False
isPublic DT_BOOL bit False
kind DT_WSTR nvarchar(84) 84 False
etag DT_WSTR nvarchar(108) 108 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:

Get comments using API Source

YouTube
Get comments
SSIS API Source - Read from table or endpoint

Get comments using API Destination

YouTube
Get comments
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get comments of a video

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

Get comments of a channel

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

SQL Server

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

Get comments of a video

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_comments WITH (videoId=''INPUT_YOUR_VIDEO_ID'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_YOUTUBE_IN_DATA_GATEWAY];

Get comments of a channel

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_comments WITH (channelId=''INPUT_YOUR_CHANNEL_ID'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_YOUTUBE_IN_DATA_GATEWAY];