Tables

Updates the field definition in the table

put/v3/tables/{tableName}/fields/{fieldName}

Request

  • Base URL: https://demo.caspio.com/integrations/rest
  • URL: https://demo.caspio.com/integrations/rest/v3/tables/{tableName}/fields/{fieldName}
  • Auth: API key in header Authorization

Path parameters

tableNamestring required

Table name

fieldNamestring required

Field Name

Request body

Namestring nullable

Field name

Typestring nullable

Field type

Uniqueboolean nullable

Indicates whether the field value must be unique (possible values = {true, false})

UniqueAllowNullsboolean nullable

Indicates whether the null value is allowed in the unique field (use only if Unique = true, possible values = {true, false})

Labelstring nullable

Field label

Descriptionstring nullable

Field description

DisplayOrderinteger nullable

Display order (0 means first)

OnInsertboolean nullable

Used only for TIMESTAMP field type. Indicates whether the date and time will be recorded when record is submitted (possible values = {true, false})

OnUpdateboolean nullable

Used only for TIMESTAMP field type. Indicates whether the date and time will be recorded when record is updated (possible values = {true, false})

TimeZonestring nullable

Used only for TIMESTAMP field type. Indicates the time zone used to record date and time

Formatstring nullable

Field format which is used only for RANDOM ID (possible values {"0", "U", "0U"}) and PREFIXED AUTONUMBER (possible values {"1", "01", "001", "0001", "00001", "000001", "0000001"}) field type

Prefixstring nullable

Prefix of the field value which is used only for RANDOM ID and PREFIXED AUTONUMBER field type (string length must be less than 50)

Lengthinteger nullable

Length of the random part value which is used only for RANDOM ID field type (if Format = "0" then Length must be from 8 to 12, if Format = {"U", "0U"} then Length must be from 6 to 12)

ListFieldstring[] nullable

List of values which is used only for LIST-STRING, LIST-NUMBER, LIST-DATE/TIME (example: ["value1", "value2", "value3"])

AttachmentPermittedFileTypesstring[] nullable

List of values (permitted file extensions) which is used only for ATTACHMENT field type (if empty all file types are allowed)

AttachmentMinFileSizeinteger nullable

Minimum file size which is used only for ATTACHMENT field type

AttachmentMaxFileSizeinteger nullable

Maximum file size which is used only for ATTACHMENT field type

AttachmentSmartResizerboolean nullable

Smart resizer option which is used only for ATTACHMENT field type

AttachmentSmartResizerForRetinaboolean nullable

Optimize for Retina displays option which is used only for ATTACHMENT field type (only if AttachmentSmartResizer = true)

AttachmentAltTextstring nullable

Alt text which is used only for ATTACHMENT field type

AttachmentTitlestring nullable

Title which is used only for ATTACHMENT field type

Response

NoContent

Changes

No recorded changes to this operation across all 1 revision of this API.