删除下拉列表设置
DELETE {{base_url}}/sheets/v2/spreadsheets/:spreadsheetToken/dataValidation
该接口根据 spreadsheetToken 、range 移除选定数据范围单元格的下拉列表设置,但保留选项文本。单个删除范围不超过5000单元格。单次请求range最大数量100个。
参考接口文档:删除下拉列表设置
Request Body
{"dataValidationRanges"=>[{"range"=>"1QXD0s!A1:A100", "dataValidationIds"=>[1]}]}
RESPONSES
status: OK
{"code":0,"data":{"rangeResults":[{"msg":"","range":"1QXD0s!A1:A100","success":true,"updatedCells":100}]},"msg":"success"}