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

get
Cell List

/tables/cell/list/{level}/{sid}/{serializer}/
Request
Response
Request
Path Parameters
level
required
string
organization
sid
required
string
organization sid
serializer
required
string
choose of [name, list, detail]
Headers
token
required
string
the authentication token
Query Parameters
row__sid
required
string
Response
200: OK
# 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
}
]
}

post
Cell List

/tables/cell/list/{level}/{sid}/{serializer}/
Create a new cell for a row.
Request
Response
Request
Path Parameters
level
required
string
level=organization
sid
required
string
sid=organization sid
serializer
required
string
choose of [name, list, detail]
Headers
token
required
string
the authentication token
Query Parameters
row__sid
required
string
the sid of the row
Response
201: Created
{
"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: Not Acceptable
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)

patch
Cell Detail

/tables/cell/detail/{sid}/
Update the content of a cell.
Request
Response
Request
Path Parameters
sid
required
string
cell sid
Headers
token
required
string
the authentication token
Response
200: OK
{
"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: Not Acceptable
Wrong id - the provided sid is not correct
Your organization does not have enough credits, contact sales@labii.com!