获取条件格式
标签：【智能表格】
请求说明
| 字段 | 值 |
|---|---|
请求地址 | 配置域名+/openapi+/v7/airsheet/{file_id}/worksheets/{worksheet_id}/cf_rules |
HTTP 方法 | GET |
接口描述 | 无 |
签名方式 | KSO-1（配置域名+/openapi不参与签名） |
限频策略 | 无 |
权限要求 | 查询和管理智能表格(应用授权) kso.airsheet.readwrite查询智能表格(应用授权) kso.airsheet.read查询和管理智能表格(用户授权) kso.airsheet.readwrite查询智能表格(用户授权) kso.airsheet.read |
请求头 (Headers)
| 属性名 | 类型 | 是否必填 | 描述 | 可选值 |
|---|---|---|---|---|
X-Kso-Date | string | 是 | RFC1123 格式的日期，例: Wed, 23 Jan 2013 06:43:08 GMT | - |
X-Kso-Authorization | string | 是 | KSO-1 签名值，详见《签名方法》 | - |
Authorization | string | 是 | 授权凭证，格式为：Bearer {access_token} | - |
路径参数 (Path)
| 属性名 | 类型 | 是否必填 | 描述 | 可选值 |
|---|---|---|---|---|
file_id | string | 是 | 文件ID | - |
worksheet_id | integer | 是 | 工作表ID | - |
响应体(Response)
HTTP状态码: 200
响应体格式: application/json
没有可用的数据
响应体示例
json
{
"code": 0,
"msg": "string",
"data": {
"rules": [
{
"cf_rule_type": "cf_rule_type_value_range",
"formula1": "string",
"formula2": "string",
"id": 0,
"lastone": true,
"operator": "cf_rule_operator_greater",
"priority": 0,
"ranges": [
{
"col_from": 0,
"col_to": 0,
"row_from": 0,
"row_to": 0
}
],
"rank": "string",
"xf": {
"alc_h": 0,
"alc_v": 0,
"clr_bottom": {
"tint": 0,
"type": 0,
"value": 0
},
"clr_diag_down": {
"tint": 0,
"type": 0,
"value": 0
},
"clr_diag_up": {
"tint": 0,
"type": 0,
"value": 0
},
"clr_inside_horz": {
"tint": 0,
"type": 0,
"value": 0
},
"clr_inside_vert": {
"tint": 0,
"type": 0,
"value": 0
},
"clr_left": {
"tint": 0,
"type": 0,
"value": 0
},
"clr_right": {
"tint": 0,
"type": 0,
"value": 0
},
"clr_top": {
"tint": 0,
"type": 0,
"value": 0
},
"dg_bottom": 0,
"dg_diag_down": 0,
"dg_diag_up": 0,
"dg_inside_horz": 0,
"dg_inside_vert": 0,
"dg_left": 0,
"dg_right": 0,
"dg_top": 0,
"fill": {
"back": {
"tint": 0,
"type": 0,
"value": 0
},
"fore": {
"tint": 0,
"type": 0,
"value": 0
},
"type": 0
},
"font": {
"bls": true,
"char_set": 0,
"color": {
"tint": 0,
"type": 0,
"value": 0
},
"dy_height": 0,
"italic": true,
"name": "string",
"sss": 0,
"strikeout": true,
"theme_font": 0,
"uls": 0
},
"hidden": true,
"indent": 0,
"locked": true,
"mask_cats": 0,
"mask_cats_font": 0,
"numfmt": "string",
"reading_order": 0,
"shrink_to_fit": true,
"trot": 0,
"wrap": true
}
}
]
}
}