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. |