Batch Clear Values

POST {{baseUrl}}/v4/spreadsheets/:spreadsheetId/values:batchClear

Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. Only values are cleared -- all other properties of the cell (such as formatting and data validation) are kept.

Request Params

Key	Datatype	Description
`access_token`	string	OAuth access token.
`alt`	string	Data format for response.
`callback`	string	JSONP
`fields`	string	Selector specifying which fields to include in a partial response.
`key`	string	API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.
`oauth_token`	string	OAuth 2.0 token for the current user.
`prettyPrint`	string	Returns response with indentations and line breaks.
`quotaUser`	string	Available to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters.
`upload_protocol`	string	Upload protocol for media (e.g. "raw", "multipart").
`uploadType`	string	Legacy upload protocol for media (e.g. "media", "multipart").
`$.xgafv`	string	V1 error format.

Request Body

{"ranges"=>["nostrud sunt reprehenderit proident cillum", "laborum eiusmod dolor ali"]}

HEADERS

Key	Datatype	Required	Description
`Content-Type`	string
`Accept`	string

RESPONSES

status: OK

{&quot;clearedRanges&quot;:[&quot;laboris in mollit&quot;,&quot;magna adipisicing&quot;],&quot;spreadsheetId&quot;:&quot;cupidatat eiusmod commodo ad&quot;}