更新下拉列表设置

PUT {{base_url}}/sheets/v2/spreadsheets/:spreadsheetToken/dataValidation/:sheetId/:dataValidationId

该接口根据 spreadsheetToken 、sheetId、dataValidationId 更新下拉列表的属性。

参考接口文档:更新下拉列表设置

Request Body

{"dataValidationType"=>"list", "dataValidation"=>{"conditionValues"=>["1", "2", "4"], "options"=>{"multipleValues"=>false, "highlightValidData"=>true, "colors"=>["#1FB6C1", "#1006C2", "#FB16C3"]}}}

RESPONSES

status: OK

{"code":0,"data":{"dataValidation":{"conditionValues":["1","2","4"],"dataValidationId":1,"dataValidationType":"list","options":{"colorValueMap":{"1":"#1FB6C1","2":"#1006C2","4":"#FB16C3"},"highlightValidData":true,"multipleValues":false}},"sheetId":"1QXD0s","spreadsheetToken":"shtcnyAti49vOKImQyn4ZH8rzLg"},"msg":"success"}