Tables

Create, update and/or delete records in a custom table, one or many per call.

Create a new record in a custom table

Update fields on an existing record in a custom table

Move a record in a custom table to the trash.

Search records in a custom table by free text and/or structured filters (numeric, date, enum conditions).

List the custom data tables in this organization.

Get the columns (field schema) of a custom table and its display field key (the column that renders as the record headline).

Get a single record from a custom table by id.

Read the internal team comments on a custom table record, newest first.

Add an internal team comment to a custom table record.

Change the text of a custom table record comment you wrote; files stay attached.

Delete an internal team comment from a custom table record.

List the saved views across custom tables, with each view's filter, sort and config.

Run a saved view and return its records (paginated).

Create a new custom data table.

Update a custom table: rename, change the description, icon or color, set the display field, or archive it.

Permanently delete a custom table with all its records, fields and views.

Create and/or update columns on a custom table, one or many per call.

Reorder a column: move a field before or after a sibling field (pass exactly one of before/after).

Permanently delete a column and its values from a custom table.

Create a saved view on a custom table, with an icon and a color that say what it shows.

Update a saved view: rename, change the icon, color, sort, filter or grouping, or archive it.

Delete a saved view from a custom table (a table always keeps at least one view).

Copy a saved view (layout, filter, sort and config) as a new view on the same table.

Move a record inside a saved view: place it after or before a sibling record id (at least one required; use before with the first item to move it first) and, on board views, change its group (group_value).

List a board view's groups in display order (the valid 'group' values for Get View Items and Move View Item).

Compute a metric over the records of a saved view: count, sum/avg/min/max of a number field, optionally grouped by a field, windowed by date, filtered, or compared to the previous period.

Reorder a table's saved views: pass the view ids in the desired order (tab order in the UI).