How do I list, get, create, update, and delete records via the API?

CRUD operations

List — GET /api-public/v1/{project}/{model or table} — any query param is passed through as a filter (Hosted) or matches the documented query params (Core: page, limit, search, sort_field, sort_dir, or any column name for an exact match). Get one — GET .../{id} (Hosted) or GET ...?id={id} (Core). Create — POST with a JSON body. Payloads capped at 1MB. Update — PUT .../{id} (Hosted) or PATCH with { "id": "...", "id_column": "...", ...fields } (Core). Core''s id_column defaults to id — set it explicitly if your primary key isn''t literally named id. Delete — DELETE .../{id} (Hosted) or DELETE with { "id": "..." } in the body (Core).