v1

latestOpenAPI 3.0.32026-08-061874701.5 MB

rows

Copy rows to another sheet

Copies rows from the sheet specified in the URL to (the bottom of) another sheet.

post/sheets/{sheetId}/rows/copy

Query parameters

include'all' | 'attachments' | 'children' | 'discussions'

A comma-separated list of row elements to copy in addition to the cell data:

all - specify a value of all to include everything (attachments, children, and discussions).
attachments
children - if specified, any child rows of the rows specified in the request are also copied to the destination sheet, and parent-child relationships amongst rows are preserved within the destination sheet; if not specified, only the rows specified in the request are copied.
discussions

ignoreRowsNotFoundboolean

true or false: default is false. If set to true, specifying row Ids that do not exist within the source sheet does not cause an error response. If omitted or set to false, specifying row Ids that do not exist within the source sheet causes an error response (and no rows are copied).

Headers

Content-Typestring

Required for POST and PUT requests. Defines the structure for the request body.

Request body

rowIdsnumber[]

The Ids of the rows to move or copy from the source sheet.

Response

CopyOrMoveRowResult object

destinationSheetIdnumber

The ID of the destination sheet.