Database table fields

Creates a new field for the table related to the provided table_id parameter if the authorized user has access to the related database's workspace. Depending on the type, different properties can optionally be set.If creating the field causes other fields to change then the specificinstances of those fields will be included in the related fields response key.

post/api/database/fields/table/{table_id}/

Path parameters

table_idinteger required

Creates a new field for the provided table related to the value.

Headers

ClientSessionIdstring uuid

An optional header that marks the action performed by this request as having occurred in a particular client session. Then using the undo/redo endpoints with the same ClientSessionId header this action can be undone/redone.

ClientUndoRedoActionGroupIdstring uuid

An optional header that marks the action performed by this request as having occurred in a particular action group.Then calling the undo/redo endpoint with the same ClientSessionId header, all the actions belonging to the same action group can be undone/redone together in a single API call.

Request body

OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR

Response

OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR
OR

Changes

Changed in 3 of the 6 revisions of this API.2493

  • f3396317d932141See the full diff
    • removed the required property oneOf[ButtonFieldFieldSerializerWithRelatedFields]/error from the response with the 200 status

      response-required-property-removed

    • removed the request property oneOf[ButtonFieldCreateField]/url_formula (media type: application/json)

      request-property-removed

    • removed the request property oneOf[ButtonFieldCreateField]/url_formula (media type: application/x-www-form-urlencoded)

      request-property-removed

    • removed the request property oneOf[ButtonFieldCreateField]/url_formula (media type: multipart/form-data)

      request-property-removed

    • removed the optional property oneOf[ButtonFieldFieldSerializerWithRelatedFields]/url_formula from the response with the 200 status

      response-optional-property-removed

    • added the required property oneOf[ButtonFieldFieldSerializerWithRelatedFields]/has_workflow_actions to the response with the 200 status

      response-required-property-added

    This revision also has 1 change that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog

  • 0c490e5b0c7f191See the full diff
    • added ButtonFieldFieldSerializerWithRelatedFields to the response body oneOf list for the response status 200

      response-body-one-of-added

    • added button mapping keys to the request discriminator (media type: application/json)

      request-body-discriminator-mapping-added

    • added button mapping keys to the request discriminator (media type: application/x-www-form-urlencoded)

      request-body-discriminator-mapping-added

    • added button mapping keys to the request discriminator (media type: multipart/form-data)

      request-body-discriminator-mapping-added

    • added ButtonFieldCreateField to the request body oneOf list (media type: application/json)

      request-body-one-of-added

    • added ButtonFieldCreateField to the request body oneOf list (media type: application/x-www-form-urlencoded)

      request-body-one-of-added

    • added ButtonFieldCreateField to the request body oneOf list (media type: multipart/form-data)

      request-body-one-of-added

    • added the new button enum value to the request property oneOf[AIFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[AIFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[AIFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[AutonumberFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[AutonumberFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[AutonumberFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[BooleanFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[BooleanFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[BooleanFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CountFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CountFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CountFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CreatedByFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CreatedByFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CreatedByFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CreatedOnFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CreatedOnFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[CreatedOnFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[DateFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[DateFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[DateFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[DurationFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[DurationFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[DurationFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[EmailFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[EmailFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[EmailFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FileFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FileFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FileFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FormViewEditRowFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FormViewEditRowFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FormViewEditRowFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FormulaFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FormulaFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[FormulaFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LastModifiedByFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LastModifiedByFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LastModifiedByFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LastModifiedFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LastModifiedFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LastModifiedFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LinkRowFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LinkRowFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LinkRowFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LongTextFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LongTextFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LongTextFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LookupFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LookupFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[LookupFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[MultipleCollaboratorsFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[MultipleCollaboratorsFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[MultipleCollaboratorsFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[MultipleSelectFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[MultipleSelectFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[MultipleSelectFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[NumberFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[NumberFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[NumberFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[PasswordFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[PasswordFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[PasswordFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[PhoneNumberFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[PhoneNumberFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[PhoneNumberFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[RatingFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[RatingFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[RatingFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[RollupFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[RollupFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[RollupFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[SingleSelectFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[SingleSelectFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[SingleSelectFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[TextFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[TextFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[TextFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[URLFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[URLFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[URLFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[UUIDFieldCreateField]/type (media type: application/json)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[UUIDFieldCreateField]/type (media type: application/x-www-form-urlencoded)

      request-property-enum-value-added

    • added the new button enum value to the request property oneOf[UUIDFieldCreateField]/type (media type: multipart/form-data)

      request-property-enum-value-added

    • added button mapping keys to the response discriminator for the response status 200

      response-body-discriminator-mapping-added

    This revision also has 4 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog

    • added the required property oneOf[AIFieldFieldSerializerWithRelatedFields]/error to the response with the 200 status

      response-required-property-added