Cell

API for Cell object

Method & Permission

API	GET	POST	PUT	PATCH	DELETE
Cell List	Admin, Project Admin, Project Edit, Project View	Project Admin*, Project Edit*	-	-	-
Cell Detail	-	-	-	Project Admin*, Project Edit*	-

*Cell can not be posted/modified if row.is_locked=True, unless the widget can be added at the read-only

*Cell can not be posted/modified if row.is_archived=True

Cell List

GET /tables/cell/list/{level}/{sid}/{serializer}/

Path Parameters

Name	Type	Description
level	string	organization
sid	string	organization sid
serializer	string	choose of [name, list, detail]

Query Parameters

Name	Type	Description
row__sid	string

Headers

Name	Type	Description
token	string	the authentication token

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
        }
    ]
}

Cell List

POST /tables/cell/list/{level}/{sid}/{serializer}/

Create a new cell for a row.

Path Parameters

Name	Type	Description
level	string	level=organization
sid	string	sid=organization sid
serializer	string	choose of [name, list, detail]

Query Parameters

Name	Type	Description
row__sid	string	the sid of the row

Headers

Name	Type	Description
token	string	the authentication token

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 [e-mail]!
Error: The row (xxx) does not belong to the organization (xxx)

Cell Detail

PATCH /tables/cell/detail/{sid}/

Update the content of a cell.

Path Parameters

Name	Type	Description
sid	string	cell sid

Headers

Name	Type	Description
token	string	the authentication 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 [e-mail]!