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