获取筛选
GET
/sheets/v3/spreadsheets/{spreadsheet_token}/sheets/{sheet_id}/filter
错误码
| HTTP状态码 | 错误码 | 描述 | 排查建议 |
|---|---|---|---|
| 500 | 1315201 | Server Error | 服务内部错误，详询客服 |
| 500 | 1315203 | Server Error | 服务内部错误，详询客服 |
| 400 | 1310213 | Permission Fail | 没有文档相应权限 |
| 400 | 1310215 | Sheet Id Not Found | 检查 sheet_id |
| 400 | 1310229 | Wrong URL Param | 检查 url 参数 |
| 400 | 1310226 | Excess Limit | 超出限制，参考响应体中的错误提示 |
| 400 | 1310217 | Too Many Request | 检查请求是否发送过于频繁 |
| 400 | 1310235 | Retry Later | 稍后重试 |
| 400 | 1310242 | In Mix state | Retey Later |
| 400 | 1310249 | Spreadsheet Deleted | 恢复表格后重试 |
请求参数
Path 参数
返回响应
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request GET '/sheets/v3/spreadsheets//sheets//filter' \
--header 'Authorization: Bearer <token>'响应示例响应示例
{
"code": 0,
"msg": "success",
"data": {
"sheet_filter_info": {
"range": "xxxxxx!A1:H14",
"filtered_out_rows": [
4
],
"filter_infos": [
{
"col": "E",
"conditions": [
{
"filter_type": "number",
"compare_type": "less",
"expected": [
"6"
]
}
]
}
]
}
}
}
扫码加入交流群修改于 2025-10-21 06:12:17