Manual · 9
Table & column endpoints
| Method | Path | Description |
|---|---|---|
| GET | /tables/{id} |
Fetch a table along with its columns |
| GET | /tables/{id}/schema |
Fetch only the schema |
| POST | /tables/{id}/columns |
Add a physical column (admin) |
| POST | /tables/{id}/columns/foreign-key |
Add a foreign key column (admin) – see Foreign key (1:n) |
| POST | /tables/{id}/columns/formula |
Add a formula column (admin) – see Formula |
| POST | /tables/{id}/columns/lookup |
Add a lookup column (admin) – see Lookup |
| POST | /tables/{id}/columns/rollup |
Add a rollup column (admin) – see Rollup |
| POST | /tables/{id}/columns/links |
Add a links column pair (admin) – see Links fields (n:m) |
| POST | /tables/{id}/columns/attachment |
Add an attachment column (admin) – see Attachment |
| POST | /tables/{id}/columns/auto-number |
Add an auto-number column (admin) – see Auto-number |
| DELETE | /tables/{id}/columns/{colId} |
Delete a column (admin) |
| PUT | /tables/{id}/columns/{colId}/ui-type |
Override the field type (admin) |
| PUT | /tables/{id}/columns/{colId}/format |
Set the display format (admin) – see Display formats at a glance |
| PUT | /tables/{id}/columns/{colId}/display-name |
Override the display name (admin) |
| PUT | /tables/{id}/columns/{colId}/formula |
Change an existing formula column’s formula (admin) |
| GET | /tables/{id}/columns/{colId}/distinct-values |
Distinct values of a column (e.g. for filter autocomplete) |
| PUT | /tables/{id}/display-column |
Set the table’s display field |
| PUT | /tables/{id}/column-order |
Set the column order |
| GET | /tables/{id}/records/export |
CSV export – see CSV export |
| POST | /tables/{id}/csv-import |
Import CSV into an existing table (admin) |