ODBC Driver for YouTube Analytics

Build 23.0.8839

Comments

Query YouTube Comments.

Table Specific Information

Select

YouTube Analytics allows only a subset of columns to be used as filter criteria. You must specify exactly one of the following columns: Id or ParentId. Extra optional columns supported are TextFormat.

All columns support the '=' operator.

SELECT * FROM Comments WHERE Id = '123456789'

Columns

Name Type Dimension DefaultMetric DefaultDimension Description
Id [KEY] String The Id that YouTube uses to uniquely identify the comment.
ChannelId String The Id of the YouTube channel associated with the comment. If the comment is a video comment, then this column identifies the channel of the video, and the VideoId column identifies the video. If the comment is a channel comment, then this column identifies the channel that the comment is about.
VideoId String The Id of the video that the comment refers to.
TextDisplay String The text of the comment. The text can be retrieved in either plaintext or HTML. The TextFormat pseudo column specifies the desired text format.
TextOriginal String The original, raw text of the comment as it was initially posted or last updated. The original text is only returned if it is accessible to the authenticated user, which is only guaranteed if the user is the author of the comment.
ParentId String The unique Id of the parent comment. This column value is only set if the comment was submitted as a reply to another comment.
AuthorDisplayName String The display name of the user who posted the comment.
AuthorProfileImageUrl String The URL for the avatar of the user who posted the comment.
AuthorChannelUrl String The URL of the YouTube channel of the comment author, if available.
AuthorChannelIdValue String The Id of the YouTube channel of the comment author, if available.
AuthorGoogleplusProfileUrl String The URL of the Google+ profile of the comment author, if available.
CanRate Boolean This setting indicates whether the current viewer can rate the comment.
ViewerRating String The rating the viewer has given to this comment. Valid values for this column: like, none. Note that this column does not currently identify dislike ratings. The column value is like if the viewer has rated the comment positively. The value is none in all other cases, including the user having given the comment a negative rating or not having rated the comment.
LikeCount Integer The total number of likes (positive ratings) the comment has received.
ModerationStatus String The moderation status of the comment. This value is only returned if the API request was authorized by the owner of the channel or the video on which the requested comments were made. In addition, note that this value is not set if the query filtered on the Id column. Valid values: heldForReview, likelySpam, published, rejected.
PublishedAt Datetime The date and time when the comment was orignally published. The value is specified in ISO 8601 (YYYY-MM-DDThh:mm:ss.sZ) format.
UpdatedAt Datetime The date and time when the comment was last updated. The value is specified in ISO 8601 (YYYY-MM-DDThh:mm:ss.sZ) format.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
TextFormat String This parameter indicates whether the API should return comments formatted as HTML or as plaintext.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839