开放平台

简要描述:

  • 表记录

请求URL:

  • https://dwbapi.thinkerx.com/api/sheet/getSheetData

请求方式:

  • GET

参数:


参数名
必选传参类类型说明
AuthorizationHeaderstring通行证
sheet_idbodystring表id
pagebodystring当前页
pageSize
bodystring每页数量
search_conditionbodyarray查询关键词:表标题id
search_query
bodyint查询值
project_idbody
项目id


返回示例

{
    "code": 0,
    "message": "\u64cd\u4f5c\u6210\u529f",
    "data": {
        "titles": [//表标题
            {
                "detail_id": 148,//表标题id
                "title_id": 7,//标题id
                "sort": 1,//排序
                "width": 120,
                "name": "\u8ba2\u5355\u7f16\u53f7",//标题名
                "type": "system",//类型
                "data_type": "order",//系统标题类型
                "system_title": "order_code",//系统标题字段
                "process_id": 0,//对应环节id
                "values": []
            },
            {
                "detail_id": 2410,
                "title_id": 2292,
                "sort": 2,
                "width": 198,
                "name": "\u4eba\u5458\u5355\u9009",
                "type": "custom",
                "data_type": "user",
                "system_title": null,
                "process_id": 0,
                "values": [
                    "workshop",
                    "employee",
                    "customer"
                ]
            },
            {
                "detail_id": 149,
                "title_id": 8,
                "sort": 3,
                "width": 120,
                "name": "\u8ba2\u5355\u5546\u54c1",
                "type": "system",
                "data_type": "order",
                "system_title": "product_name",
                "process_id": 0,
                "values": []
            },
            {
                "detail_id": 150,
                "title_id": 9,
                "sort": 4,
                "width": 120,
                "name": "\u8ba2\u5355\u91d1\u989d",
                "type": "system",
                "data_type": "order",
                "system_title": "money",
                "process_id": 0,
                "values": []
            },
            {
                "detail_id": 151,
                "title_id": 10,
                "sort": 5,
                "width": 120,
                "name": "\u4e0b\u5355\u65f6\u95f4",
                "type": "system",
                "data_type": "order",
                "system_title": "order_time",
                "process_id": 0,
                "values": []
            },
            {
                "detail_id": 152,
                "title_id": 11,
                "sort": 6,
                "width": 120,
                "name": "\u8ba2\u5355\u72b6\u6001",
                "type": "system",
                "data_type": "order",
                "system_title": "status",
                "process_id": 0,
                "values": []
            },
            {
                "detail_id": 153,
                "title_id": 12,
                "sort": 7,
                "width": 120,
                "name": "\u914d\u9001\u5730\u5740",
                "type": "system",
                "data_type": "order",
                "system_title": "address",
                "process_id": 0,
                "values": []
            }
        ],
        "data": [//当前记录列表
            {
                "id": 173,//记录id
                "detail_id": 36,//表id
                "created_at": "2026-02-04T06:42:37.000000Z",
                "updated_at": "2026-02-04T06:42:37.000000Z",
                "deleted_at": null,
                "records": [//记录值
                    {
                        "id": 1092,//当前记录id
                        "detail_id": 148,//表标题id
                        "group_id": 173,//记录id
                        "title_id": 7,//标题id
                        "value": ""//当前值
                    },
                    {
                        "id": 1093,
                        "detail_id": 149,
                        "group_id": 173,
                        "title_id": 8,
                        "value": ""
                    },
                    {
                        "id": 1094,
                        "detail_id": 150,
                        "group_id": 173,
                        "title_id": 9,
                        "value": ""
                    },
                    {
                        "id": 1095,
                        "detail_id": 151,
                        "group_id": 173,
                        "title_id": 10,
                        "value": ""
                    },
                    {
                        "id": 1096,
                        "detail_id": 152,
                        "group_id": 173,
                        "title_id": 11,
                        "value": ""
                    },
                    {
                        "id": 1097,
                        "detail_id": 153,
                        "group_id": 173,
                        "title_id": 12,
                        "value": ""
                    },
                    {
                        "id": 1098,
                        "detail_id": 2410,
                        "group_id": 173,
                        "title_id": 2292,
                        "value": ""
                    }
                ]
            },
            {
                "id": 80,
                "detail_id": 36,
                "created_at": "2025-10-18T06:04:57.000000Z",
                "updated_at": "2025-10-18T06:04:57.000000Z",
                "deleted_at": null,
                "records": [
                    {
                        "id": 403,
                        "detail_id": 148,
                        "group_id": 80,
                        "title_id": 7,
                        "value": "20250514-1"
                    },
                    {
                        "id": 404,
                        "detail_id": 149,
                        "group_id": 80,
                        "title_id": 8,
                        "value": "\u5438\u5851\u95e8"
                    },
                    {
                        "id": 405,
                        "detail_id": 150,
                        "group_id": 80,
                        "title_id": 9,
                        "value": ""
                    },
                    {
                        "id": 406,
                        "detail_id": 151,
                        "group_id": 80,
                        "title_id": 10,
                        "value": "2025-05-14 10:54:24"
                    },
                    {
                        "id": 407,
                        "detail_id": 152,
                        "group_id": 80,
                        "title_id": 11,
                        "value": "\u5df2\u51fa\u5e93"
                    },
                    {
                        "id": 408,
                        "detail_id": 153,
                        "group_id": 80,
                        "title_id": 12,
                        "value": "\u6d4b\u8bd5\u7ec8\u7aef\u5730\u5740"
                    },
                    {
                        "id": 792,
                        "detail_id": 2410,
                        "group_id": 80,
                        "title_id": 2292,
                        "value": "2123123"
                    }
                ]
            },
            {
                "id": 79,
                "detail_id": 36,
                "created_at": "2025-10-18T06:04:52.000000Z",
                "updated_at": "2025-10-18T06:04:52.000000Z",
                "deleted_at": null,
                "records": [
                    {
                        "id": 397,
                        "detail_id": 148,
                        "group_id": 79,
                        "title_id": 7,
                        "value": "20250514-2"
                    },
                    {
                        "id": 398,
                        "detail_id": 149,
                        "group_id": 79,
                        "title_id": 8,
                        "value": "\u67dc\u4f53"
                    },
                    {
                        "id": 399,
                        "detail_id": 150,
                        "group_id": 79,
                        "title_id": 9,
                        "value": "11"
                    },
                    {
                        "id": 400,
                        "detail_id": 151,
                        "group_id": 79,
                        "title_id": 10,
                        "value": "2025-05-14 14:24:24"
                    },
                    {
                        "id": 401,
                        "detail_id": 152,
                        "group_id": 79,
                        "title_id": 11,
                        "value": "\u5df2\u51fa\u5e93"
                    },
                    {
                        "id": 402,
                        "detail_id": 153,
                        "group_id": 79,
                        "title_id": 12,
                        "value": ""
                    },
                    {
                        "id": 791,
                        "detail_id": 2410,
                        "group_id": 79,
                        "title_id": 2292,
                        "value": ""
                    }
                ]
            }
        ],
        "total": 3,//总记录数量
        "page": "1",//当前页
        "pageSize": "10",//当前每页显示数量
        "project_role": null//当前项目角色
    },
    "timestamp": 1772008459
}

返回参数说明

参数名类型说明
statusint状态码 0成功 1失败
messagestr返回信息
dataobject返回值








新格尔累计为
7368555
位用户提供服务

客服热线

联系电话:400-1567-080

微信咨询

扫码在线咨询
企微官网客服在线随时答复

公众号

扫一扫
关注官方公众号

抖音号

扫一扫
关注官方抖音号