GuidesAPI ReferenceMCPChangelog
Appointments engine

Delete a product category

delete/api/products/categories/{id}

Never blocks and never takes products with it: the composite FK's column-scoped on delete set null (category_id) (0176) un-groups them in the same statement, same shape book_service_groups' own DELETE takes. Appointments only, see POST /api/products.

Authorization

sessionCookie
sb-qxrvgfkjyvbngipqvslu-auth-token<token>

The dashboard's Supabase Auth session cookie, set at sign-in. Large sessions are split across numbered chunks (…auth-token.0, .1), so treat this as a cookie family rather than one name.

Every request re-validates it against the Auth server (getUser()), never by decoding the cookie locally: a JWT nothing has checked is not a credential. Tenancy is then read from the verified app_metadata.company_id claim and enforced by row-level security; it is never read from request input, on any route, ever.

role (admin / staff) is deliberately not in RLS. It gates specific actions in route code, the operations marked admin below, so hiding a button in the UI is cosmetic only, and a route's own check is the enforcement.

In: cookie

Path Parameters

id*string

Category id.

Response Body

application/json

application/json

application/json

application/json

application/json

curl -X DELETE "https://example.com/api/products/categories/string"
{  "ok": true}

Create a product category POST

A named shelf products hang off on the Products list ("Hair care", "Tools"), purely for finding things; it never changes a price (migration 0176). New categories land at the end of the shelf (`sort_order = max+1`). v1 is flat, name-only: no rename or reorder route exists yet. **Appointments only**, see POST /api/products.

Create a package POST

Adds a catalog item: a set of prepaid visits covering one or more services. `company_id` comes from the verified JWT claim, never the body. Writes book_packages then book_package_services in two sequential statements (no RPC transaction); if the second write fails, the just-created package is deleted rather than left with no services on it. **Appointments only**, see migration 20260917130000's own header.