Create a new column

Use this API to create a new column in the table

Request Body — REQUIRED
askribeKey string Your secret Askribe key. Can be obtained from your org's settings dashboard
tableId string The tableId of your table. It looks like TXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
columnName string The name of the column
description string The description of the column
contextVariableType object The type of the column variableType string Possible values: [STRING, INTEGER, REAL, BOOLEAN, DATE, TIME, DATE_TIME, IMAGE, AUDIO, VIDEO, FILE, CATEGORY, NLU_ENTITY, BLUEPRINT, LIST, SET, HASHMAP, RICHTEXT] categoryValues object[] label string value string nluEntityId string blueprintId string enumId string t1Type (circular) t2Type (circular) blueprintFields (circular)[] otherDateTypeBaseType (circular) dynamicFieldDateMapperType string Possible values: [UNIX_TIMESTAMP_IN_SECONDS, UNIX_TIMESTAMP_IN_MILLISECONDS, UNIX_TIMESTAMP_IN_NANOSECONDS, STRING_FORMAT] otherDateStringFormat string
defaultValue object contextVariableType object The type of the column variableType string Possible values: [STRING, INTEGER, REAL, BOOLEAN, DATE, TIME, DATE_TIME, IMAGE, AUDIO, VIDEO, FILE, CATEGORY, NLU_ENTITY, BLUEPRINT, LIST, SET, HASHMAP, RICHTEXT] categoryValues object[] label string value string nluEntityId string blueprintId string enumId string t1Type (circular) t2Type (circular) blueprintFields (circular)[] otherDateTypeBaseType (circular) dynamicFieldDateMapperType string Possible values: [UNIX_TIMESTAMP_IN_SECONDS, UNIX_TIMESTAMP_IN_MILLISECONDS, UNIX_TIMESTAMP_IN_NANOSECONDS, STRING_FORMAT] otherDateStringFormat string value string
specialType string Possible values: [NONE, CREATED_AT, UPDATED_AT, CREATED_BY, UPDATED_BY, FOREIGN_KEY, LOOKUP_COLUMN, USER, CONTACT] Used to indicate if a column is special type like foreign key, lookup column, etc.
overriddenType string Possible values: [NONE, MULTI_LINE, PHONE_NUMBER, EMAIL, URL, CURRENCY, PERCENT, DURATION, RATING, AUTONUMBER, BARCODE, QR, BUTTON] Used to indicate if a column has custom formatting type like multi-line, phone number, url etc.
isFormula boolean Is the column a formula column
formulaExpression string Formula of the column if the column is of formula type
fkReferredTableId string The id of the referred table if the column is a foreign key or lookup column
backingColumnId string The id of the backing column if the column is a foreign key or lookup column
fkReferMultipleRows boolean Is the foreign key column referring to multiple rows
fkIsSelectionLimitedToView boolean Is the foreign key selection limited to a view
fkLimitSelectionToViewId string The id of the view to which the foreign key selection is limited
fkIsSelectionLimitedToCondition boolean Is the foreign key selection limited to a condition
fkLimitSelectionToCondition string The condition to which the foreign key selection is limited
lookupColumnReferredColumnId string The column which the lookup column is referring to
lookupIsItemsShownLimited boolean Is the lookup column showing limited items
lookupShownItemsLimitedType string Possible values: [FIRST, LAST, TOP] How are the loookup column items limited
lookupShownItemsLimitedValue int32 The value of the limit when lookup column shows limited items
isReferenceType boolean Is the column a reference type. Applicable when the column is a QR type or Barcode Type
referredSourceColumnId string The id of the source column if the column is a reference type
referredCDPPrimaryFieldId string The id of the primary field of the referred CDP if the column is of CONTACT type
isIdentifier boolean Is unique constraint applicable on columns
isMandatory boolean Are non-null values allowed on column
barcodeFormats string[] Allowed barcode formats if the column is of barcode type
buttonLabel string Label of the button if the column is of button type
buttonStyle string Style of the button if the column is of button type
customTableButtonActionType string Possible values: [OPEN_URL, TRIGGER_FLOW, EMBED_IFRAME] Action type of the button if the column is of button type
buttonURL string URL of the button if the column is of button type and customTableButtonActionType = OPEN_URL | EMBED_IFRAME
buttonTriggerFlowId string Flow id to be triggered if the column is of button type and customTableButtonActionType = TRIGGER_FLOW
buttonTriggerNodeId string Node id to be triggered if the column is of button type and customTableButtonActionType = TRIGGER_FLOW
formattingOptions object Formatting options for the column

Responses
200 Returns the newly created column Schema — OPTIONAL object