获取行记录列表

正式环境

https://api.mingdao.com

POST

/v3/app/worksheets/{worksheet_id}/rows/list

获取工作表记录列表，包含记录创建者、拥有者信息，各控件对应的值

请求参数

Path 参数

Header 参数

Body 参数application/json

示例

{
    "pageSize": 100,
    "pageIndex": 1,
    "viewId": "",
    "fields": [
        ""
    ],
    "filter": {
        "type": "group",
        "logic": "OR",
        "children": [
            {
                "type": "group",
                "logic": "AND",
                "children": [
                    {
                        "type": "condition",
                        "field": "677b4a73d14fcf3edf4e7f15",
                        "operator": "eq",
                        "value": [
                            "1"
                        ]
                    },
                    {
                        "type": "condition",
                        "field": "677b4a73d14fcf3edf4e7f15",
                        "operator": "eq"
                    }
                ]
            }
        ]
    },
    "sorts": [
        {
            "field": "",
            "isAsc": false
        }
    ],
    "search": "",
    "tableView": true,
    "useFieldIdAsKey": true,
    "includeTotalCount": true,
    "includeSystemFields": true
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'https://api.mingdao.com/v3/app/worksheets//rows/list' \
--header 'HAP-Appkey: {{appkey}}' \
--header 'HAP-Sign: {{sign}}' \
--header 'Content-Type: application/json' \
--data-raw '{
    "pageSize": 100,
    "pageIndex": 1,
    "viewId": "",
    "fields": [
        ""
    ],
    "filter": {
        "type": "group",
        "logic": "OR",
        "children": [
            {
                "type": "group",
                "logic": "AND",
                "children": [
                    {
                        "type": "condition",
                        "field": "677b4a73d14fcf3edf4e7f15",
                        "operator": "eq",
                        "value": [
                            "1"
                        ]
                    },
                    {
                        "type": "condition",
                        "field": "677b4a73d14fcf3edf4e7f15",
                        "operator": "eq"
                    }
                ]
            }
        ]
    },
    "sorts": [
        {
            "field": "",
            "isAsc": false
        }
    ],
    "search": "",
    "tableView": true,
    "useFieldIdAsKey": true,
    "includeTotalCount": true,
    "includeSystemFields": true
}'

返回响应

🟢200成功

application/json

Body

示例

{
    "data": {
        "rows": [
            {
                "id": "0bc19fb7-4100-43ad-8f0e-7d2879427677",
                "_createdAt": "2024-03-25 15:52:58",
                "_createdBy": {
                    "id": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "_updatedBy": {
                    "id": "user-api",
                    "fullname": "API",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/worksheetapi.png?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "_owner": {
                    "id": "user-undefined",
                    "fullname": "未指定",
                    "avatar": "https://p1.mingdaoyun.cn/UserAvatar/undefined.gif?imageView2/1/w/48/h/48/q/90",
                    "isPortal": false,
                    "status": 1
                },
                "_updatedAt": "2024-03-25 15:52:58",
                "632444f6182c34e9180b069e": "路由器重置器",
                "632444f6182c34e9180b069f": "9.99",
                "632444f6182c34e9180b06a1": "产品-30",
                "autoid": 15
            }
        ],
        "total": 1
    },
    "success": true
}

修改于 2025-09-05 07:02:57

新建工作表

获取行记录详情