Bookingmood Query Availability

Maximum number of availability records to return (1-1000). API maximum is 1000 results per request.

Sort results by specified column and direction. Format: 'column_name.direction' where direction is 'asc' or 'desc'. Examples: 'start_date.asc', 'product_id.desc'. If not specified, returns in default order.

Number of availability records to skip before starting to return results (for pagination).

Specify which columns to retrieve. Use '*' for all columns, or provide comma-separated column names (e.g., 'product_id,start_date,end_date,available'). If not specified, returns all columns by default.

Filter by end date using PostgREST operators. Examples: 'lte.2026-12-31' (less than or equal), 'eq.2026-03-01' (equals). Use to find availability ending before or on a specific date.

Filter by availability status using PostgREST operators. Examples: 'eq.true' (only available), 'eq.false' (only unavailable).

Filter by product ID using PostgREST operators. Examples: 'eq.uuid-value' (equals), 'in.(uuid1,uuid2)' (in list). Use this to query availability for specific product(s).

Filter by start date using PostgREST operators. Examples: 'gte.2026-01-01' (greater than or equal), 'eq.2026-02-15' (equals). Use to find availability starting from or on a specific date.

Filter by organization ID using PostgREST operators. Examples: 'eq.uuid-value' (equals). Use this to query availability for products in a specific organization.