replies

Creates, updates, deletes, gets or lists a replies resource.

Overview

Name	replies
Type	Resource
Id	googleworkspace.drivev2.replies

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
author	object	Information about a Drive user. (id: User)
content	string	The plain text content used to create this reply. This is not HTML safe and should only be used as a starting point to make edits to a reply's content. This field is required on inserts if no verb is specified (resolve/reopen).
createdDate	string (date-time)	The date when this reply was first created.
deleted	boolean	Whether this reply has been deleted. If a reply has been deleted the content will be cleared and this will only represent a reply that once existed.
genoaAuthor	object	The user who wrote this reply as a GenoaUser. (id: GenoaUser)
htmlContent	string	HTML formatted content for this reply.
kind	string	This is always drive#commentReply. (default: drive#commentReply)
modifiedDate	string (date-time)	The date when this reply was last modified.
replyId	string	The ID of the reply.
verb	string	The action this reply performed to the parent comment. When creating a new reply this is the action to be perform tSo the parent comment. Possible values are: * resolve - To resolve a comment. * reopen - To reopen (un-resolve) a comment.

list

Name	Datatype	Description
author	object	Information about a Drive user. (id: User)
content	string	The plain text content used to create this reply. This is not HTML safe and should only be used as a starting point to make edits to a reply's content. This field is required on inserts if no verb is specified (resolve/reopen).
createdDate	string (date-time)	The date when this reply was first created.
deleted	boolean	Whether this reply has been deleted. If a reply has been deleted the content will be cleared and this will only represent a reply that once existed.
genoaAuthor	object	The user who wrote this reply as a GenoaUser. (id: GenoaUser)
htmlContent	string	HTML formatted content for this reply.
kind	string	This is always drive#commentReply. (default: drive#commentReply)
modifiedDate	string (date-time)	The date when this reply was last modified.
replyId	string	The ID of the reply.
verb	string	The action this reply performed to the parent comment. When creating a new reply this is the action to be perform tSo the parent comment. Possible values are: * resolve - To resolve a comment. * reopen - To reopen (un-resolve) a comment.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	fileId, commentId, replyId	includeDeleted	Gets a reply.
list	select	fileId, commentId	includeDeleted, maxResults, pageToken	Lists all of the replies to a comment.
insert	insert	fileId, commentId		Creates a new reply to the given comment.
patch	update	fileId, commentId, replyId		Updates an existing reply.
update	replace	fileId, commentId, replyId		Updates an existing reply.
delete	delete	fileId, commentId, replyId		Deletes a reply.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
commentId	string
fileId	string
replyId	string
includeDeleted	boolean
maxResults	integer (int32)
pageToken	string

SELECT examples

get

Gets a reply.

SELECT
author,
content,
createdDate,
deleted,
genoaAuthor,
htmlContent,
kind,
modifiedDate,
replyId,
verb
FROM googleworkspace.drivev2.replies
WHERE fileId = '{{ fileId }}' -- required
AND commentId = '{{ commentId }}' -- required
AND replyId = '{{ replyId }}' -- required
AND includeDeleted = '{{ includeDeleted }}'
;

list

Lists all of the replies to a comment.

SELECT
author,
content,
createdDate,
deleted,
genoaAuthor,
htmlContent,
kind,
modifiedDate,
replyId,
verb
FROM googleworkspace.drivev2.replies
WHERE fileId = '{{ fileId }}' -- required
AND commentId = '{{ commentId }}' -- required
AND includeDeleted = '{{ includeDeleted }}'
AND maxResults = '{{ maxResults }}'
AND pageToken = '{{ pageToken }}'
;

INSERT examples

insert

Creates a new reply to the given comment.

INSERT INTO googleworkspace.drivev2.replies (
data__replyId,
data__kind,
data__createdDate,
data__modifiedDate,
data__verb,
data__author,
data__deleted,
data__htmlContent,
data__content,
data__genoaAuthor,
fileId,
commentId
)
SELECT 
'{{ replyId }}',
'{{ kind }}',
'{{ createdDate }}',
'{{ modifiedDate }}',
'{{ verb }}',
'{{ author }}',
{{ deleted }},
'{{ htmlContent }}',
'{{ content }}',
'{{ genoaAuthor }}',
'{{ fileId }}',
'{{ commentId }}'
RETURNING
author,
content,
createdDate,
deleted,
genoaAuthor,
htmlContent,
kind,
modifiedDate,
replyId,
verb
;

Manifest

# Description fields are for documentation purposes
- name: replies
  props:
    - name: fileId
      value: string
      description: Required parameter for the replies resource.
    - name: commentId
      value: string
      description: Required parameter for the replies resource.
    - name: replyId
      value: string
      description: >
        The ID of the reply.
        
    - name: kind
      value: string
      description: >
        This is always drive#commentReply.
        
      default: drive#commentReply
    - name: createdDate
      value: string
      description: >
        The date when this reply was first created.
        
    - name: modifiedDate
      value: string
      description: >
        The date when this reply was last modified.
        
    - name: verb
      value: string
      description: >
        The action this reply performed to the parent comment. When creating a new reply this is the action to be perform tSo the parent comment. Possible values are: * `resolve` - To resolve a comment. * `reopen` - To reopen (un-resolve) a comment.
        
    - name: author
      value: object
      description: >
        Information about a Drive user.
        
    - name: deleted
      value: boolean
      description: >
        Whether this reply has been deleted. If a reply has been deleted the content will be cleared and this will only represent a reply that once existed.
        
    - name: htmlContent
      value: string
      description: >
        HTML formatted content for this reply.
        
    - name: content
      value: string
      description: >
        The plain text content used to create this reply. This is not HTML safe and should only be used as a starting point to make edits to a reply's content. This field is required on inserts if no verb is specified (resolve/reopen).
        
    - name: genoaAuthor
      value: object
      description: >
        The user who wrote this reply as a GenoaUser.
        

UPDATE examples

patch

Updates an existing reply.

UPDATE googleworkspace.drivev2.replies
SET 
data__replyId = '{{ replyId }}',
data__kind = '{{ kind }}',
data__createdDate = '{{ createdDate }}',
data__modifiedDate = '{{ modifiedDate }}',
data__verb = '{{ verb }}',
data__author = '{{ author }}',
data__deleted = {{ deleted }},
data__htmlContent = '{{ htmlContent }}',
data__content = '{{ content }}',
data__genoaAuthor = '{{ genoaAuthor }}'
WHERE 
fileId = '{{ fileId }}' --required
AND commentId = '{{ commentId }}' --required
AND replyId = '{{ replyId }}' --required
RETURNING
author,
content,
createdDate,
deleted,
genoaAuthor,
htmlContent,
kind,
modifiedDate,
replyId,
verb;

REPLACE examples

update

Updates an existing reply.

REPLACE googleworkspace.drivev2.replies
SET 
data__replyId = '{{ replyId }}',
data__kind = '{{ kind }}',
data__createdDate = '{{ createdDate }}',
data__modifiedDate = '{{ modifiedDate }}',
data__verb = '{{ verb }}',
data__author = '{{ author }}',
data__deleted = {{ deleted }},
data__htmlContent = '{{ htmlContent }}',
data__content = '{{ content }}',
data__genoaAuthor = '{{ genoaAuthor }}'
WHERE 
fileId = '{{ fileId }}' --required
AND commentId = '{{ commentId }}' --required
AND replyId = '{{ replyId }}' --required
RETURNING
author,
content,
createdDate,
deleted,
genoaAuthor,
htmlContent,
kind,
modifiedDate,
replyId,
verb;

DELETE examples

delete

Deletes a reply.

DELETE FROM googleworkspace.drivev2.replies
WHERE fileId = '{{ fileId }}' --required
AND commentId = '{{ commentId }}' --required
AND replyId = '{{ replyId }}' --required
;