获取工作表
GET
https://open.feishu.cn/open-apis/sheets/v3/spreadsheets/{spreadsheet_token}/sheets/query
错误码
| HTTP状态码 | 错误码 | 描述 | 排查建议 |
|---|---|---|---|
| 400 | 1310251 | Invalid Parameter | 参考响应体中的错误提示 |
| 400 | 1310213 | Permission Fail | 没有文档相应权限 |
| 400 | 1310249 | Spreadsheet Deleted | 恢复表格后重试 |
| 400 | 1310214 | SpreadSheet Not Found | 检查表格 token |
| 500 | 1315201 | Server Error | 服务内部错误，详询客服 |
| 500 | 1315203 | Server Error | 服务内部错误，详询客服 |
| 500 | 1315210 | Server Error | 服务内部错误，详询客服 |
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request GET 'https://open.feishu.cn/open-apis/sheets/v3/spreadsheets/shtxxxxxxxxxxxxxxxx/sheets/query' \
--header 'Authorization;'响应示例响应示例
{
"code": 0,
"msg": "success",
"data": {
"sheets": [
{
"sheet_id": "sxj5ws",
"title": "title",
"index": 0,
"hidden": false,
"grid_properties": {
"frozen_row_count": 0,
"frozen_column_count": 0,
"row_count": 200,
"column_count": 20
},
"resource_type": "sheet",
"merges": [
{
"start_row_index": 0,
"end_row_index": 0,
"start_column_index": 0,
"end_column_index": 0
}
]
}
]
}
}请求参数
Path 参数
spreadsheet_token
string
必需
示例值:
shtxxxxxxxxxxxxxxxx
Header 参数
Authorization
string
必需
默认值:
Bearer {{access_token}}
Content-Type
string
必需
默认值:
application/json; charset=utf-8
返回响应
扫码加入交流群修改于 2023-01-13 10:05:03