Comments

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

TextFormat

String

This parameter indicates whether the API should return comments formatted as HTML or as plaintext.

Last updated