Returns a paginated, filterable list of reservations. No authentication required. Each item in data[] is a fully joined reservation object including customer, brand, branch (with country), section, tables, and payments. The response also echoes back a filters_applied summary of all active filter values.

Returns waiting list entries for a branch, with joined customer, branch (including country and brand), and table data. When id is supplied, returns a single entry object directly instead of a paginated list. No authentication required.

All six modes share this URL. The response shape — and whether a JSON body or a CSV file stream is returned — is determined entirely by which query parameters are supplied. All results are sorted by created_at DESC.

Fetches a single gift card record by its numeric row ID. Returns a single object under data, not an array. Triggers 404 if no card exists with that ID.

Returns a paginated list of gift cards generated from a specific regular gift card template.

Returns a paginated list of bulk gift card batches — one row per batch, showing its ID, batch reference, name, and total card count. Does not return individual cards.

Returns a single batch object including its metadata and up to 100 gift card records, sorted latest first. Returns 404 if the batch_id string does not match any batch.

Streams the gift cards in a batch as a downloadable CSV file. The response body is a raw file stream — not JSON. download_csv=true only works alongside batch_id; without it, the parameter is ignored.

Looks up a single card by its card number and returns its current balance, currency, and status. Returns 404 if no card exists with that number.

The default mode — triggered when none of the special params above are present. Returns a paginated list of gift cards across all types. All filters are optional. Results sorted by created_at DESC.

Mode is determined by the presence of ?id=. When supplied, returns a single country object. When absent, returns a paginated list with optional name/code filters. All list results are sorted by country_name ASC. Pagination uses offset-based skip, not a page parameter.

Fetches a single country record by its numeric row ID. Returns the country object directly under data (not an array). Returns 404 if no country exists with that ID.

Returns a list of countries sorted by country_name ASC. Supports case-insensitive partial matching on name and code. Pagination is offset-based — use skip to advance pages, not a page parameter. The page field in the response is calculated server-side as Math.floor(skip / limit) + 1.

Mode is determined by the presence of id, brand_Id, or brand_code. Any one of those triggers single-fetch mode. Without them, the endpoint returns a paginated list sorted brand_name ASC. The hasFiles response field differs between modes — a detailed per-field object in single mode, true in list mode.

Fetches a single brand by numeric ID, brand code (brand_Id), or its alias brand_code. All three resolve the same record. Returns the full brand object plus a detailed hasFiles map showing which file fields have content. Returns 404 if no brand matches.

Returns a paginated list of brands sorted brand_name ASC. Supports name/code partial matching, country filtering (single or multi via comma-separated IDs), and a lightweight excludeFiles flag that replaces raw binary fields with booleans for lighter payloads. The response always includes "hasFiles": true at the root in list mode.

Mode is selected by the presence of ?id=. Without it, returns a paginated list. The public variant (/api/public/branch) always includes a waiting_list[] per branch — the private version does not. All list results sorted branch_name ASC.

Returns a single branch by numeric row ID. Section capacities are live-adjusted — each section's capacity reflects the raw capacity minus the count of current paid active reservations for that section. Also returns a per-field hasFiles object. Returns 404 if no branch matches.

Returns a paginated list of branches sorted branch_name ASC. Each item includes nested brand, country, sections[], and waiting_list[]. Supports filtering by brand (single ID, comma-separated IDs, or brand code), country, name/code search, and feature flags. Setting limit >= 500 disables pagination and returns all results in one page.

Returns available time slots for a Salt Al Bahar event on a given date, including capacity, pricing, entry fee, and bookable flags. Accounts for paid bookings and temporary cart holds.

Returns bookable slots grouped into regular_slots and mid_night_slots, with event rules and capacity counts. Only rules marked bookable are included.

List, create, or update Salt Al Bahar event bookings (EventBooking). Creates a customer by mobile if one does not exist. PUT requires ?id={numeric_id}.

GET — query parameters

POST — body (create)

PUT — body (update) · query ?id=

Create wallet transactions or list transaction history. Summary available at /api/public/salt-al-bahar/transaction/summery (note: path spelling matches the API).

POST — body

GET — query parameters

Returns section-based available slots for a branch on a given date, respecting custom availability rules, timezone, and live reservation counts.

Fetch one reservation by ?id= or a paginated list with optional filters (branch, customer mobile, date range, status).

Returns waiting list entries for a branch. Auto-expires READY entries older than 15 minutes to NOSHOW before responding. Use ?id= for a single entry or list filters for multiple.

Returns walk-in queue entries for a branch. Supports single fetch via ?id= or filtered list mode.