EndPoint Get comments
Name
get_comments
Description
No description available [API reference]
Parameters
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

Get comments using API Destination
YouTube
Get comments

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];