v1

latestOpenAPI 3.0.32026-08-061874701.5 MB

rows

Delete rows

Deletes one or more rows from the sheet specified in the URL.

delete/sheets/{sheetId}/rows

Query parameters

idsstring required

A comma-separated list of row Ids.

ignoreRowsNotFoundboolean

true or false. If set to false and any of the specified row Ids are not found, no rows are deleted, and the "not found" error is returned.

Response

Returns Result object containing row Ids corresponding to all rows that were successfully deleted (including any child rows of rows specified in the URL).

message'PARTIAL_SUCCESS' | 'SUCCESS'

Message that indicates the outcome of the request. (One of SUCCESS or PARTIAL_SUCCESS.)

resultCode0 | 3

'0' Success
'3' Partial Success of Bulk Operation

resultnumber[]

Example response

{
  "message": "SUCCESS"
}