Sign in

v51

latestOpenAPI 3.0.3AGPL-3.0-or-laterraw.githubusercontent.com2026-08-017215661.2 KB
api1

Create a column

This endpoint allows CORS requests

post/index.php/apps/tables/api/1/columns

Request body

tableIdinteger nullable

Table ID

viewIdinteger nullable

View ID

titlestring required

Title

technicalNamestring nullable

Technical name of the column

type'text' | 'number' | 'datetime' | 'select' | 'usergroup' | 'relation' required

Column main type

subtypestring nullable

Column sub type

mandatoryboolean required

Is the column mandatory

descriptionstring nullable

Description

numberPrefixstring nullable

Prefix if the column is a number field

numberSuffixstring nullable

Suffix if the column is a number field

numberDefaultnumber double nullable

Default number, if column is a number

numberMinnumber double nullable

Min value, if column is a number

numberMaxnumber double nullable

Max number, if column is a number

numberDecimalsinteger nullable

Number of decimals, if column is a number

textDefaultstring nullable

Default text, if column is a text

textAllowedPatternstring nullable

Allowed pattern (regex) for text columns (not yet implemented)

textMaxLengthinteger nullable

Max length, if column is a text

textUniqueboolean nullable

Whether the text value must be unique, if column is a text

selectionOptionsstring nullable

Options for a selection (json array{id: int, label: string})

selectionDefaultstring nullable

Default option IDs for a selection (json list<int>)

datetimeDefaultstring nullable

Default value, if column is datetime

usergroupDefaultstring nullable

Default value, if column is usergroup (json array{id: string, type: int})

usergroupMultipleItemsboolean nullable

Can select multiple users or/and groups, if column is usergroup

usergroupSelectUsersboolean nullable

Can select users, if column type is usergroup

usergroupSelectGroupsboolean nullable

Can select groups, if column type is usergroup

usergroupSelectTeamsboolean nullable

Can select teams, if column type is usergroup

usergroupShowUserStatusboolean nullable

Whether to show the user's status, if column type is usergroup

selectedViewIdsinteger[] nullable

View IDs where this column should be added to be presented

customSettingsobject

Custom settings for the column

Response

Column created

idinteger required
uuidstring required
titlestring required
technicalNamestring required
tableIdinteger required
createdBystring required
createdByDisplayNamestring required
createdAtstring required
lastEditBystring required
lastEditByDisplayNamestring required
lastEditAtstring required
typestring required
subtypestring required
mandatoryboolean required
descriptionstring required
orderWeightinteger required
numberDefaultnumber double required
numberMinnumber double required
numberMaxnumber double required
numberDecimalsinteger required
numberPrefixstring required
numberSuffixstring required
textDefaultstring required
textAllowedPatternstring required
textMaxLengthinteger required
textUniqueboolean required
selectionOptionsstring required
selectionDefaultstring required
datetimeDefaultstring required
usergroupDefaultstring required
usergroupMultipleItemsboolean required
usergroupSelectUsersboolean required
usergroupSelectGroupsboolean required
usergroupSelectTeamsboolean required
showUserStatusboolean required