v1

latestOpenAPI 3.0.32026-08-061874701.5 MB

rows

Move rows to another sheet

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

post/sheets/{sheetId}/rows/move

Query parameters

include'attachments' | 'discussions'

A comma-separate list of row elements to move in addition to the cell data.

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

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.