Sign in

v51

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

Update a column

This endpoint allows CORS requests

put/index.php/apps/tables/api/1/columns/{columnId}

Path parameters

columnIdinteger required

Column ID that will be updated

Request body

titlestring nullable

Title

technicalNamestring nullable

Technical name of the column

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

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

customSettingsobject

Custom settings for the column

Response

Updated column

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