查询下拉列表设置

GET {{base_url}}/sheets/v2/spreadsheets/:spreadsheetToken/dataValidation?dataValidationType=list&range=1QXD0s!A1:A100

该接口根据 spreadsheetToken 、range 查询range内的下拉列表设置信息;单次查询范围不超过5000行,100列。

参考接口文档:查询下拉列表设置

Request Params

KeyDatatypeRequiredDescription
dataValidationTypestring
rangestring

RESPONSES

status: OK

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