Lists
Lists in InLoox enable structured collection of tabular data within a project. Each list consists of columns (field definitions), data rows, and associated values. Templates allow reuse of list structures.
Lists are always associated with a project. Use ProjectId when filtering to retrieve only the lists of a specific project.
CheckList
The CheckList entity represents a single list within a project.
Data Model
| Property | Type | Description |
|---|---|---|
CheckListId | guid | Unique ID of the list. |
ProjectId | guid | ID of the associated project. |
OrdinalPosition | int32 | Sort position of the list within the project. |
Name | string | Name of the list. |
InitialColumnNames | string[] | Initial column names when creating (optional). |
Endpoints
Retrieve all lists across all projects
/odata/CheckListSupports OData query options.
Retrieve a list by ID
/odata/CheckList({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListId. |
Create a new list
/odata/CheckListUse InitialColumnNames to create columns directly when creating the list. Otherwise, you can add columns later via the CheckListColumn endpoint.
Update an existing list
/odata/CheckList({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListId. |
Body | Delta<ApiCheckList> | ✅ | JSON object with the fields to update. |
Delete a list
/odata/CheckList({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListId. |
Deleting a list also removes all associated columns, rows, and values. This action cannot be undone.
Returns 204 No Content on success.
Relations
Add a relation to the list
/odata/CheckList({key})/AddRelation| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListId. |
itemId | guid | ✅ | The ID of the item to link. |
Remove a relation from the list
/odata/CheckList({key})/RemoveRelation| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListId. |
itemId | guid | ✅ | The ID of the relation to remove. |
CheckListColumn
The CheckListColumn entity defines the columns (fields) of a list.
Data Model
| Property | Type | Description |
|---|---|---|
CheckListColumnId | guid | Unique ID of the column. |
CheckListId | guid | ID of the associated list. |
OrdinalPosition | int32 | Sort position of the column. |
Name | string | Column name. |
ColumnType | int32 | Column type: 0 = Text, 1 = Date/Time, 2 = Integer, 3 = Decimal, 4 = Boolean, 5 = Dropdown list, 6 = Currency. |
Endpoints
Retrieve all list columns across all lists in all projects
/odata/CheckListColumnSupports OData query options.
Retrieve a column by ID
/odata/CheckListColumn({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListColumnId. |
Create a new column
/odata/CheckListColumn| Parameter | Type | Required | Description |
|---|---|---|---|
Body | Delta<ApiCheckListColumn> | ✅ | JSON object with the column properties. |
Update a column
/odata/CheckListColumn({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListColumnId. |
Body | Delta<ApiCheckListColumn> | ✅ | JSON object with the fields to update. |
Delete a column
/odata/CheckListColumn({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListColumnId. |
Deleting a column also removes all associated cell values. This action cannot be undone.
Returns 204 No Content on success.
CheckListDataRow
The CheckListDataRow entity represents a data row in a list. The actual values are stored via CheckListValue.
Data Model
| Property | Type | Description |
|---|---|---|
RowId | guid | Unique ID of the row. |
CheckListId | guid | ID of the associated list. |
OrdinalPosition | int32 | Sort position of the row. |
Endpoints
Retrieve all data rows. Supports OData query options
/odata/CheckListDataRowRetrieve a data row by ID
/odata/CheckListDataRow({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The RowId. |
Create a new data row
/odata/CheckListDataRowUpdate a data row
/odata/CheckListDataRow({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The RowId. |
Body | Delta<ApiCheckListDataRow> | ✅ | JSON object with the fields to update. |
Delete a data row
/odata/CheckListDataRow({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The RowId. |
Deleting a row also removes all associated cell values. This action cannot be undone.
Returns 204 No Content on success.
CheckListTemplate
The CheckListTemplate entity enables saving and loading list templates. Templates can be created from existing lists and loaded into other projects.
Data Model
| Property | Type | Description |
|---|---|---|
CheckListTemplateId | guid | Unique ID of the template. |
Name | string | Name of the template. |
Endpoints
CRUD Operations
Retrieve all list templates
/odata/CheckListTemplateSupports OData query options.
Retrieve a template by ID
/odata/CheckListTemplate({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListTemplateId. |
Create a new template
/odata/CheckListTemplateUpdate a template
/odata/CheckListTemplate({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListTemplateId. |
Body | Delta<ApiCheckListTemplate> | ✅ | JSON object with the fields to update. |
Delete a template
/odata/CheckListTemplate({key})| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListTemplateId. |
Deleting a template cannot be undone.
Returns 204 No Content on success.
Template Management
Save a template from an existing list
/odata/CheckListTemplate/SaveTemplateForCheckList| Parameter | Type | Required | Description |
|---|---|---|---|
Body | object | ✅ | JSON object with the following fields: checkListId (guid, required) — The CheckListId of the list to save as a template. name (string, required) — Name of the new template. |
Saves the structure of an existing list as a reusable template.
Load a template into a project
/odata/CheckListTemplate({key})/LoadTemplateForProject| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListTemplateId of the template to load. |
Body | object | ✅ | JSON object with the following fields: projectId (guid, required) — The ID of the project to load the template into. |
Creates a new list in the specified project based on the template.
Download a template
/odata/CheckListTemplate({key})/DownloadTemplate()| Parameter | Type | Required | Description |
|---|---|---|---|
key | guid | ✅ | The CheckListTemplateId. |
Returns a file with content type application/xml and file name {TemplateName}.json.
CheckListValue
The CheckListValue entity stores the value of a single cell (row × column) in a list.
Data Model
| Property | Type | Description |
|---|---|---|
RowId | guid | ID of the associated data row. |
FieldName | guid | ID of the column (CheckListColumnId). |
Value | any | The stored value (type varies depending on the column type). |
Endpoints
Create or update a cell value
/odata/CheckListValueCreates or updates the value of a single cell in a list.
The Value type must match the column type (ColumnType). For checkbox columns, use true/false; for number columns, use a numeric value.
OData Query Examples
Retrieve lists of a project
GET /odata/CheckList?$filter=ProjectId eq {projectId}&$orderby=OrdinalPosition asc
Create a list
POST /odata/CheckList
Content-Type: application/json
{
"ProjectId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"Name": "Quality Check",
"OrdinalPosition": 0,
"InitialColumnNames": "Task,Status,Responsible"
}
Update a list
PATCH /odata/CheckList('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx')
Content-Type: application/json
{
"Name": "Quality Check – Version 2",
"OrdinalPosition": 2
}
Retrieve columns of a list
GET /odata/CheckListColumn?$filter=CheckListId eq {checkListId}&$orderby=OrdinalPosition asc
Create a column
POST /odata/CheckListColumn
Content-Type: application/json
{
"CheckListId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"Name": "Responsible",
"OrdinalPosition": 3,
"ColumnType": "text"
}
Retrieve rows of a list
GET /odata/CheckListDataRow?$filter=CheckListId eq {checkListId}&$orderby=OrdinalPosition asc
Create a row
POST /odata/CheckListDataRow
Content-Type: application/json
{
"CheckListId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"OrdinalPosition": 0
}
Set a cell value
POST /odata/CheckListValue
Content-Type: application/json
{
"RowId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"FieldName": "Status",
"Value": "Passed"
}
Create a template
POST /odata/CheckListTemplate
Content-Type: application/json
{
"Name": "Standard Quality Check"
}
Save a list as a template
POST /odata/CheckListTemplate/SaveTemplateForCheckList
Content-Type: application/json
{
"CheckListId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"TemplateName": "Template from Quality Check"
}
Load a template into a project
POST /odata/CheckListTemplate('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx')/LoadTemplateForProject
Content-Type: application/json
{
"TemplateId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
"ProjectId": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
}
Combine $filter with $orderby to retrieve lists, columns, and rows in the correct display order. Filtering by ProjectId or CheckListId is the most common pattern.