TRtracecat
tables

Create Column

Add a column to a table.

post/workspaces/{workspace_id}/tables/{table_id}/columns

Request

  • Base URL
    https://platform.tracecat.com/api
  • Auth
    • API key in cookie fastapiusersauth
    • or HTTP bearer

Path parameters

table_idstring uuid required
workspace_idstring uuid required

Request body

namestring required

The name of the column

type'TEXT' | 'INTEGER' | 'NUMERIC' | 'DATE' | 'BOOLEAN' | 'TIMESTAMPTZ' | 'JSONB' | 'SELECT' | 'MULTI_SELECT' required

Supported SQL types.

nullableboolean
defaultunknown
is_indexboolean

Whether to create a unique index on the column

optionsstring[] nullable

Response

Successful Response

idstring uuid required
namestring required
type'TEXT' | 'INTEGER' | 'NUMERIC' | 'DATE' | 'BOOLEAN' | 'TIMESTAMPTZ' | 'JSONB' | 'SELECT' | 'MULTI_SELECT' required

Supported SQL types.

nullableboolean
defaultunknown
is_indexboolean
optionsstring[] nullable

Changes

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