Change a field
PATCH
/api/v1/objects/{objectId}/fields/{fieldId}Authorization
AuthorizationOAuth2 access token · headerrequiredAuthorization-code grant with PKCE. Clients are public and hold no secret. Discovery is published at /.well-known/oauth-authorization-server/api/auth.
Scopes:
api.accessPath parameters
objectIdstringrequiredAn object's id
min length 1 · max length 255
fieldIdstringrequiredA field's id
min length 1 · max length 255
Header parameters
Idempotency-KeystringrequiredReplays the first answer for a repeated request
min length 8 · max length 128
Request body
requiredapplication/jsonkeystringmatches ^[a-z][a-z0-9_]{0,62}$
labelstringmin length 1 · max length 120
requiredbooleantargetObjectIdstringmin length 1 · max length 255
typestringAllowed:
textlongtextdecimalcurrencypercentbooleandatedatetimeemailurlphoneuseraddressselectmulti_selectrelationformularollupdays_sinceResponses
200
The field as it now stands
definitionobjectrequiredShow propertiesHide properties
One of:
object
keystringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
labelstringrequiredmin length 1 · max length 120
requiredbooleanrequireddefault: false
visibleByDefaultbooleantypestringrequiredAllowed:
textlongtextdecimalcurrencypercentbooleandatedatetimeemailurlphoneuseraddressobject
keystringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
labelstringrequiredmin length 1 · max length 120
requiredbooleanrequireddefault: false
visibleByDefaultbooleanoptionsstring[]requiredmax items 200
typestringrequiredobject
keystringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
labelstringrequiredmin length 1 · max length 120
requiredbooleanrequireddefault: false
visibleByDefaultbooleanoptionsstring[]requiredmax items 200
typestringrequiredobject
keystringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
labelstringrequiredmin length 1 · max length 120
requiredbooleanrequireddefault: false
visibleByDefaultbooleancardinalitystringrequiredAllowed:
onemanytargetObjectIdstringrequiredmin length 1 · max length 255
typestringrequiredobject
keystringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
labelstringrequiredmin length 1 · max length 120
requiredbooleanrequireddefault: false
visibleByDefaultbooleanformulaobjectrequiredShow propertiesHide properties
leftstringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
operatorstringrequiredAllowed:
addsubtractmultiplydividerightstringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
typestringrequiredobject
keystringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
labelstringrequiredmin length 1 · max length 120
requiredbooleanrequireddefault: false
visibleByDefaultbooleanrollupobjectrequiredShow propertiesHide properties
aggstringrequiredAllowed:
countsumavgminmaxlastfirstcolumnstring | nullrequiredShow propertiesHide properties
Any of:
string
stringnull
nullfiltersobject[]requiredmax items 20
Show propertiesHide properties
Array of
objectidstringrequiredmax length 128
keystringrequiredmin length 1 · max length 128
opstringrequiredAllowed:
containsnotContainsisisNotisAnyOfisNoneOfgtgteltltebeforeafteronOrBeforeonOrAfterisBetweenisYesterdayisTodayisTomorrowisLastWeekisThisWeekisNextWeekisLastMonthisThisMonthisNextMonthisPastisFutureisEmptyisNotEmptyisTrueisFalsevaluestringrequiredmax length 500
valuesstring[]requiredmax items 50
foreignKeystringrequiredmin length 1 · max length 128
modestringAllowed:
relatedListrelationshipobjectstringrequiredmin length 1 · max length 128
orderBystring | nullShow propertiesHide properties
Any of:
string
stringnull
nullscoreobject | nullShow propertiesHide properties
Any of:
object
bucketsintegermin 1 · max 20
directionstringAllowed:
descascnull
nulltypestringrequiredobject
keystringrequiredmatches ^[a-z][a-z0-9_]{0,62}$
labelstringrequiredmin length 1 · max length 120
requiredbooleanrequireddefault: false
visibleByDefaultbooleandaysSinceobjectrequiredShow propertiesHide properties
columnstringrequiredmin length 1 · max length 128
typestringrequiredidstringrequiredmin length 1 · max length 255
systembooleanrequired400
The request body, query or parameters were refused
codestringrequiredAllowed:
invalid_inputnot_foundconflictforbiddendetailanyerrorstringrequiredreasonstring401
The access token is missing, invalid or revoked
errorstringrequired403
The tenant's module is off, or the token's scope or the member's role does not permit the action
codestringrequiredAllowed:
invalid_inputnot_foundconflictforbiddendetailanyerrorstringrequiredreasonstring404
No such record, or none the caller may read
codestringrequiredAllowed:
invalid_inputnot_foundconflictforbiddendetailanyerrorstringrequiredreasonstring409
The operation conflicts with the current state
codestringrequiredAllowed:
invalid_inputnot_foundconflictforbiddendetailanyerrorstringrequiredreasonstring413
The request exceeds the route's body limit
errorstringrequired500
An unexpected failure
errorstringrequired