单元格

方法与权限

API	GET	POST	PUT	PATCH	DELETE
单元格列表	管理员，项目管理员，项目编辑，项目查看	项目管理员*, 项目编辑*	-	-	-
单元格详情	-	-	-	项目管理员*, 项目编辑*	-

*如果 row.is_locked=True，则无法发布/修改单元格，除非小插件可以添加在只读状态下

*如果 row.is_archived=True，则无法发布/修改单元格

获取单元格列表

端点: /tables/cell/list/{level}/{sid}/{serializer}/

参数: level (路径, 字符串)

组织

参数: sid (路径, 字符串)

组织 sid

参数: serializer (路径, 字符串)

选择 [name, list, detail] 中的一项

参数: token (头部, 字符串)

认证令牌

参数: row__sid (查询, 字符串)

响应: 200

# serializer = name
{
    "page_size": 10,
    "page_number": 1,
    "page_count": 1,
    "count": 1,
    "next": null,
    "previous": null,
    "add_permission": true,
    "results": [
        {
            "sid": "xxx",
            "name": "date_start"
        }
    ]
}
# serializer = list
{
    "page_size": 10,
    "page_number": 1,
    "page_count": 1,
    "count": 1,
    "next": null,
    "previous": null,
    "add_permission": true,
    "results": [
        {
            "sid": "xxx",
            "widget": {
                "sid": "xxx",
                "name": "Date - Edit date value"
            },
            "row": {
                "sid": "xxx",
                "name": "EP625: Test Name 20200525133408"
            },
            "price": "$0.00",
            "change_permission": true
        }
    ]
}
# serializer = detail
{
    "page_size": 10,
    "page_number": 1,
    "page_count": 1,
    "count": 1,
    "next": null,
    "previous": null,
    "add_permission": true,
    "results": [
        {
            "sid": "xxx",
            "data": "2020-05-25",
            "row": {
                "sid": "xxx",
                "name": "EP625: Test Name 20200525133408"
            },
            "column": {
                "sid": "xxx",
                "name": "date_start"
            },
            "widget": {
                "sid": "xxx",
                "name": "Date - Edit date value"
            },
            "date_updated": "2020-05-25T20:34:39.293654Z",
            "date_created": "2020-05-25T20:34:39.292882Z",
            "change_permission": true
        }
    ]
}

发布单元格列表

端点: /tables/cell/list/{level}/{sid}/{serializer}/

为一行创建新的单元格。

参数: level (路径, 字符串)

level=组织

参数: sid (路径, 字符串)

sid=组织 sid

参数: serializer (路径, 字符串)

选择 [name, list, detail] 中的一项

参数: token (头部, 字符串)

认证令牌

参数: row__sid (查询, 字符串)

行的 sid

响应: 201

{
    "sid": "xxx",
    "data": "2020-05-25",
    "row": {
        "sid": "xxx",
        "name": "EP625: Test Name 20200525133408"
    },
    "column": {
        "sid": "xxx",
        "name": "date_start"
    },
    "widget": {
        "sid": "xxx",
        "name": "Date - Edit date value"
    },
    "date_updated": "2020-05-25T20:34:39.293654Z",
    "date_created": "2020-05-25T20:34:39.292882Z",
    "change_permission": true
}

响应: 406

Error: Missing row__sid in the post link.
Error: Your organization does not have enough credits, contact sales@labii.com!
Error: The row (xxx) does not belong to the organization (xxx)

修补单元格详情

端点: /tables/cell/detail/{sid}/

更新单元格的内容。

参数: sid (路径, 字符串)

单元格 sid

参数: token (头部, 字符串)

认证令牌

响应: 200

{
    "sid": "xxx",
    "data": "2020-05-25",
    "row": {
        "sid": "xxx",
        "name": "EP625: Test Name 20200525133408"
    },
    "column": {
        "sid": "xxx",
        "name": "date_start"
    },
    "widget": {
        "sid": "xxx",
        "name": "Date - Edit date value"
    },
    "date_updated": "2020-05-25T20:34:39.293654Z",
    "date_created": "2020-05-25T20:34:39.292882Z",
    "change_permission": true
}

响应: 406

Wrong id - the provided sid is not correct
Your organization does not have enough credits, contact sales@labii.com!