v1
latestOpenAPI 3.0.32026-08-061874701.5 MBUpdate rows
Updates cell values in the specified rows, expands/collapses the specified rows, or modifies the position of specified rows (including indenting/outdenting). For detailed information about changing row positions, see location-specifier attributes.
Note: This operation does not handle adding images to cells. However, you can upload an image to a cell by calling the operation described in the Add Image to Cell page.
Query parameters
Allows COMMENTER access for inputs and return values. For backwards-compatibility, VIEWER is the default. For example, to see whether a user has COMMENTER access for a sheet, use accessApiLevel=1.
When specified with a value of true, enables partial success for this bulk operation. See Bulk operations > Partial success for more information.
You may use the query string parameter overrideValidation with a value of true to allow a cell value outside of the validation limits. You must specify strict with a value of false to bypass value type checking.
Headers
Required for POST and PUT requests. Defines the structure for the request body.
Request body
Response
Returns Result object containing an array of the updated rows.
Example response
{
"message": "SUCCESS"
}