列出记录
GET {{base_url}}/bitable/v1/apps/:app_token/tables/:table_id/records
该接口用于列出数据表中的现有记录,单次最多列出 100 行记录,支持分页获取。
参考接口文档:列出记录
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
view_id | string | 视图 id, 如filter或sort有值, view_id会被忽略 | |
filter | string | filter, 不超过2000个字符, 不支持对带特殊字段(关联和公式)的表的使用 | |
sort | string | sort, 不超过1000字符, 不支持对带特殊字段(关联和公式)的表的使用 | |
field_names | string | field_names | |
text_field_as_array | boolean | 控制多行文本字段数据的返回格式, true 表示以数组形式返回 | |
page_token | string | 分页标记,第一次请求不填,表示从头开始遍历;分页查询结果还有更多项时会同时返回新的 page_token,下次遍历可采用该 page_token 获取查询结果 | |
page_size | number | 分页大小 | |
user_id_type | string | 用户 ID 类型。可选值:open_id、union_id、user_id |
RESPONSES
status: OK
{"code":0,"data":{"has_more":false,"items":[{"fields":{"人力耗时":"30","任务执行人":[{"email":"huangpaopao@feishu.cn","en_name":"Paopao Huang","id":"ou_5fb00e0112212cc7012fe3a697336989","name":"黄泡泡"}],"任务描述":"我是最大的功能开发🥕","任务附件":[{"file_token":"boxcndoxG79sKWFlWsNN2iYLNZe","name":"photo.jpg","size":1015367,"tmp_url":"https://open.feishu.cn/open-apis/drive/v1/medias/batch_get_tmp_download_url?file_tokens=boxcndoxG79sKWFlWsNN2iYLNZe","type":"image/jpeg","url":"https://open.feishu.cn/open-apis/drive/v1/medias/boxcndoxG79sKWFlWsNN2iYLNZe/download"},{"file_token":"boxcnJz6m8DNRfO6BJaoLs3V4xf","name":"file.txt","size":80725,"tmp_url":"https://open.feishu.cn/open-apis/drive/v1/medias/batch_get_tmp_download_url?file_tokens=boxcnJz6m8DNRfO6BJaoLs3V4xf","type":"text/plain","url":"https://open.feishu.cn/open-apis/drive/v1/medias/boxcnJz6m8DNRfO6BJaoLs3V4xf/download"}],"截止日期":1638288000000,"文档地址":{"link":"https://www.baidu.com/","text":"百度"},"是否完成":false,"状态":"开发中","相关部门":["研发"]},"id":"rec6ZZIszW","record_id":"rec6ZZIszW"},{"fields":{"人力耗时":"24","任务执行人":[{"email":"huangpaopao@feishu.cn","en_name":"Paopao Huang","id":"ou_5fb00e0112212cc7012fe3a697336989","name":"黄泡泡"}],"任务描述":"华南销售","任务附件":[{"file_token":"boxcnSbRSkr8gsNtflGT60smHYb","name":"file1.txt","size":80725,"tmp_url":"https://open.feishu.cn/open-apis/drive/v1/medias/batch_get_tmp_download_url?file_tokens=boxcnSbRSkr8gsNtflGT60smHYb","type":"text/plain","url":"https://open.feishu.cn/open-apis/drive/v1/medias/boxcnSbRSkr8gsNtflGT60smHYb/download"}],"截止日期":1637337600000,"文档地址":{"link":"https://www.feishu.cn/","text":"飞书"},"是否完成":true,"状态":"已结束","相关部门":["销售","客服"]},"id":"recHakXqfx","record_id":"recHakXqfx"}],"page_token":"recHakXqfx","total":2},"msg":"Success"}