Replies
Returns replies of a comment on a file.
Id Encoding
The Google Drive API uses case-sensitive IDs for replies, meaning IDs like "AAABpKTbnsw" and "AAABpKTbnSw" are considered unique. Since the connector is case-insensitive, the Id column contains an encoded numeric representation of the original API ID. This encoding converts the case-sensitive ID into a unique base-10 number string that can be safely used in queries while maintaining uniqueness.
The OriginalReplyId column contains the original, case-sensitive Google Drive API ID.
Select
The Replies table supports the following columns for filtering. The connector uses the Google Drive API to process WHERE clause conditions built with these columns, offering optimal performance.
| Column | Supported Operators |
| Id | = |
| FileId | = |
| CommentId | = |
When specifying FileId and CommentId, the filter is sent server-side for better performance:
SELECT * FROM Replies WHERE FileId = '19YFv8wmvKixCYaJJAeE8jN3ROt7x1ZicvXwflswVOrw' AND CommentId = '21454749864264944795'
You can also filter by Id to retrieve a specific reply:
SELECT * FROM Replies WHERE FileId = '1eCy_Fks57HytPuam-OiaHGY4_15Py16eVM5bNDCHYXQ' AND CommentId = '21454749864264944795' AND Id = '21454749864264944230'
To include deleted replies in the results, use the IncludeDeleted pseudo-column:
SELECT * FROM Replies WHERE FileId = '19YFv8wmvKixCYaJJAeE8jN3ROt7x1ZicvXwflswVOrw' AND CommentId = '21454749864264944795' AND IncludeDeleted = true
Insert
To insert a reply, you must specify at least the FileId, CommentId, and Content fields:
INSERT INTO Replies (FileId, CommentId, Content) VALUES ('19YFv8wmvKixCYaJJAeE8jN3ROt7x1ZicvXwflswVOrw', '21454749864264944795', 'This is a reply to the comment')
Update
To update a reply, specify the Id along with the fields to modify:
UPDATE Replies SET Content = 'Updated reply content' WHERE Id = '21454749864264944230' AND FileId = '19YFv8wmvKixCYaJJAeE8jN3ROt7x1ZicvXwflswVOrw' AND CommentId = '21454749864264944795'
Delete
To delete a reply, specify the Id:
DELETE FROM Replies WHERE Id = '21454749864264944230' AND FileId = '1eCy_Fks57HytPuam-OiaHGY4_15Py16eVM5bNDCHYXQ' AND CommentId = '21454749864264944795'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The unique identifier of the reply. |
| CommentId [KEY] | String | False |
The unique identifier of the comment. |
| FileId [KEY] | String | False |
The unique identifier of the file. |
| CreatedTime | Datetime | True |
The time at which the reply was created. |
| ModifiedTime | Datetime | True |
The last time the reply was modified. |
| Action | String | False |
The action the reply performed to the parent comment. Valid values are: resolve, reopen |
| Author | String | True |
The display name of the reply's author. |
| Deleted | Boolean | True |
Whether the reply has been deleted. A deleted comment has no content. |
| Content | String | False |
The plain text content of the reply. |
| HTMLContent | String | True |
The content of the reply with HTML formatting. |
| OriginalReplyId | String | True |
The original, case-sensitive Google Drive API Id of the reply. Used only for references. |
| Kind | String | True |
Identifies what kind of resource this is. Value: the fixed string 'drive#reply'. |
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 |
| IncludeDeleted | Boolean |
Whether to include deleted comments. Deleted comments will not include their original content. |