更新下拉列表设置
PUT
/open-apis/sheets/v2/spreadsheets/{spreadsheetToken}/dataValidation/{sheetId}/{dataValidationId}
自建应用商店应用
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request PUT 'https://open.feishu.cn/open-apis/sheets/v2/spreadsheets//dataValidation//' \
--header 'Authorization;' \
--header 'Content-Type: application/json' \
--data-raw '{
"dataValidationType":"list",
"dataValidation":{
"conditionValues":["1", "2", "4","2"],
"options":{
"multipleValues":false,
"highlightValidData":true,
"colors":["#1FB6C1", "#1006C2", "#FB16C3","#FFB6C1"]
}
}
}'
响应示例响应示例
{
"code": 0,
"data": {
"dataValidation": {
"conditionValues": [
"1",
"2",
"4"
],
"dataValidationId": 2,
"dataValidationType": "list",
"options": {
"colorValueMap": {
"1": "#1FB6C1",
"2": "#1006C2",
"4": "#FB16C3"
},
"highlightValidData": true,
"multipleValues": false
}
},
"sheetId": "yuNGtr",
"spreadsheetToken": "shtbckBcolBlRfkcMVZbolMdADe"
},
"msg": "Success"
}
请求参数
Path 参数
spreadsheetToken
string
必需
sheetId
string
必需
dataValidationId
string
必需
Header 参数
Authorization
string
必需
默认值:
Bearer {{access_token}}
Content-Type
string
必需
默认值:
application/json; charset=utf-8
Body 参数application/json
返回响应
修改于 2023-01-18 06:32:54