查询记录列表

POST

/data/records/list

分页查询表中的记录，支持 filters 与 sort。

请求参数

Authorization

Bearer Token

在 Header 添加参数

Authorization

，其值为在 Bearer 之后拼接 Token

示例：

Authorization: Bearer ********************

Header 参数

Body 参数application/json必填

示例

{
    "table_key": "tbl_xxx",
    "page_size": 20,
    "current_page": 1,
    "filters": [
        "age:gte:18",
        "name:eq:张三"
    ],
    "sort": "created_at:desc"
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location 'https://app.emooai.com/open-api/v1/data/records/list' \
--header 'Emoo-User-Id: ' \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '{
    "table_key": "tbl_xxx",
    "page_size": 20,
    "current_page": 1,
    "filters": [
        "age:gte:18",
        "name:eq:张三"
    ],
    "sort": "created_at:desc"
}'

返回响应

🟢200

application/json

成功（code=200）或业务错误。可能错误码：

4084 invalid_open_api_user_id

4133 base_table_not_found

4199 base_ws_app_not_found

4210 base_open_id_invalid（filter 中 USER 字段 open_id 无效）

Bodyapplication/json

示例

{
    "code": 200,
    "message": "success",
    "data": {
        "total": 0,
        "page_size": 0,
        "current_page": 0,
        "total_pages": 0,
        "results": [
            {
                "id": 0,
                "record_key": "string",
                "fields": {
                    "property1": "string",
                    "property2": "string"
                },
                "created_by": {
                    "id": "string",
                    "name": "string"
                },
                "created_at": "2019-08-24T14:15:22.123Z",
                "updated_by": {
                    "id": "string",
                    "name": "string"
                },
                "updated_at": "2019-08-24T14:15:22.123Z"
            }
        ]
    }
}

🟠400

🟠401

修改于 2026-08-27 02:18:28

删除记录

批量更新记录