Connect Apaleo to Supabase

Both apps 134Apaleo 71Supabase 63

• Trigger
  New Booking

  Triggers when a new booking is created in Apaleo, returning the booker details and its reservations.

• Trigger
  New Company

  Triggers when a new company is created in Apaleo.

• Trigger
  New Folio

  Triggers when a new folio is created in Apaleo, newest first.

• Trigger
  New Reservation

  Triggers when a new reservation is created in Apaleo, optionally limited to certain properties, statuses or channels.

• Trigger
  Reservation Updated

  Triggers when a reservation is created or changed, including status changes such as check-in, check-out or cancellation.

• Action
  Add Allowance to Folio

  Posts an allowance (a discount or credit) to a folio in Apaleo.

• Action
  Add Charge to Folio

  Adds a charge for a good or service to a folio and posts it immediately. Returns the new charge id and any fee charge ids.

• Action
  Add Reservations to Booking

  Creates one or more new reservations and adds them to an existing booking. Returns the ids of the reservations that were created.

• Action
  Amend Reservation Stay

  Changes the stay details of a reservation: arrival, departure, number of guests and the rate plan for each night.

• Action
  Assign Unit to Reservation

  Assigns a specific unit (room) to a confirmed or in-house reservation, optionally for part of the stay and optionally locking it.

• Action
  Book Service for Reservation

  Books a service (such as breakfast or spa) onto an existing reservation, for the whole stay or for specific dates.

• Action
  Cancel Block

  Cancels a block that is Definite or Tentative, changing its status to Canceled.

• Action
  Cancel Invoice

  Cancels an invoice in Apaleo, creating a cancellation invoice and reopening the folio where applicable.

• Action
  Cancel Reservation

  Cancels a confirmed reservation whose arrival is still in the future, setting its status to Canceled.

• Action
  Change Unit Condition

  Changes the housekeeping condition (Clean, Clean to be inspected, Dirty) of a unit in apaleo.

• Action
  Check In Reservation

  Checks in a confirmed reservation that has a unit assigned, moving it to In House.

• Action
  Check Out Reservation

  Checks out an in-house reservation, setting its status to Checked Out and posting all open folio charges.

• Action
  Close Folio

  Closes a folio so no further charges or payments can be added. Only possible when the folio balance is 0; this cannot be undone.

• Action
  Confirm Block

  Confirms a tentative block, changing its status to Definite.

• Action
  Create Block

  Creates a block of inventory for a group booking at a given rate plan and date range, and returns the new block's id.

• Action
  Create Booking

  Creates a booking in Apaleo containing one or more reservations for a booker. Returns the new booking id and the ids of its reservations.

• Action
  Create Company

  Creates a company (corporate account) for a property in Apaleo, with its address, tax details and bookable rate plans.

• Action
  Create Folio

  Creates an additional guest folio for a reservation, or a new external folio for a property, with the given debitor.

• Action
  Create Group

  Creates a group booking in Apaleo for one or more properties, with the booker's details. Returns the new group's id.

• Action
  Create Invoice

  Creates an invoice for one folio. The folio's debitor must have a name, city, postal code and country.

• Action
  Create Maintenance

  Creates a maintenance window (out of service, out of order or out of inventory) for a unit.

• Action
  Create Payment

  Records a custom payment (cash, cheque, voucher or externally processed) on an Apaleo folio.

• Action
  Create Payment Link

  Creates a link to a payment form where a guest can pay an amount toward a folio. Returns the id of the pending payment.

• Action
  Create Refund

  Creates a refund on an Apaleo folio for the given amount and payment method. The refund is processed asynchronously.

• Action
  Create Unit

  Creates a new unit (room) in an Apaleo property.

• Action
  Delete Block

  Deletes a block, as long as no reservations have been picked up from it.

• Action
  Delete Company

  Deletes a company and removes it from any rate plans that have not used it yet.

• Action
  Delete Folio

  Deletes an empty, non-main folio. This cannot be undone.

• Action
  Delete Group

  Deletes a group booking in Apaleo. Only possible while no blocks are linked to the group.

• Action
  Delete Maintenance

  Deletes a maintenance window from a unit. Maintenances that started yesterday or earlier cannot be deleted.

• Action
  Get Block

  Returns a specific Apaleo block (inventory held for a group booking) by its ID.

• Action
  Get Booking

  Returns a booking with its booker details, reservations and property totals.

• Action
  Get Company

  Returns a company (corporate account) by its ID, including its address, tax details and bookable rate plans.

• Action
  Get Folio

  Returns one folio by ID, including its charges, allowances, payments, balance and debitor details.

• Action
  Get Group

  Returns a specific group booking, optionally including its blocks and available actions.

• Action
  Get Invoice

  Returns an invoice's details, including recipient, line items, payments, tax details and totals.

• Action
  Get Invoice PDF

  Downloads the PDF file of an existing invoice.

• Action
  Get Maintenance

  Returns a scheduled unit maintenance (out of service, out of order or out of inventory) by its ID, including its unit and time window.

• Action
  Get Payment

  Returns a single payment on a folio, including its amount, method, status and dates.

• Action
  Get Property

  Returns a property (hotel) by its id, including its name, address, company details, time zone and currency.

• Action
  Get Rate Plan

  Returns a single rate plan by its ID, including its pricing, policies, restrictions and channels.

• Action
  Get Reservation

  Returns a single reservation, including its guest, stay dates, rate plan, unit and amounts.

• Action
  Get Service

  Returns a specific service (such as breakfast) with its price, availability and accounting settings.

• Action
  Get Stay Offers

  Returns the available room offers (unit groups with rate plans and prices) for a property, arrival and departure date and number of guests.

• Action
  Get Unit

  Returns a single unit (room or space) with its property, unit group, status, and attributes.

• Action
  Get Unit Group

  Returns a unit group (room type) with its property, names, descriptions, capacity and unit count.

• Action
  List Bookings

  Returns the bookings in your Apaleo account, optionally filtered by reservation, group, channel, external code or booker details.

• Action
  List Folios

  Returns the folios in your Apaleo account, optionally filtered by property, reservation, booking, company, status, type, dates or balance.

• Action
  List Payments

  Returns the payments recorded on a folio, newest first, optionally filtered by payment status.

• Action
  List Properties

  Returns the list of properties (hotels) in the Apaleo account, optionally filtered by status or country.

• Action
  List Rate Plans

  Returns the rate plans in your Apaleo account, optionally filtered by property, codes, channels, unit groups and other criteria.

• Action
  List Rates

  Returns the prices and restrictions of a rate plan for each time slice in a date range.

• Action
  List Reservations

  Returns the reservations in your Apaleo account, optionally filtered by booking, property, status, dates, guest text and more.

• Action
  List Services

  Returns the services (extras such as breakfast or parking) set up for your properties, optionally filtered by property, name, channel or type.

• Action
  List Unit Groups

  Returns the unit groups (room types, meeting rooms, parking and similar) defined in Apaleo, optionally for one property.

• Action
  List Units

  Returns the units (rooms) of your Apaleo account, optionally filtered by property, unit group, condition, occupancy or name.

• Action
  Mark Invoice Paid

  Marks an Apaleo invoice as paid, recording the payment method and receipt reference.

• Action
  Reopen Folio

  Reopens a closed folio so charges and payments can be posted again. Only works when no invoice has been created for the folio.

• Action
  Update Booking

  Updates a booking's comment, booker comment, booker or payment account.

• Action
  Update Company

  Updates an existing company's name, contact details, tax IDs, address, invoicing options or rate plans. Fields left blank are not changed.

• Action
  Update Folio

  Updates a folio's debitor or company in Apaleo.

• Action
  Update Group

  Updates a group booking's name, comments, properties, booker or payment account.

• Action
  Update Maintenance

  Updates the start, end or description of an existing maintenance window for a unit.

• Action
  Update Rates

  Creates or overwrites the prices and restrictions of a rate plan for the given time slices.

• Action
  Update Reservation

  Updates a reservation's comments, travel purpose, market segment, company, charge and pre-check-in flags, or applies other allowed changes such as the primary guest.

• Action
  Update Unit

  Updates a unit's name, description, condition, unit group or maximum occupancy in Apaleo. Only the fields you fill in are changed.

• Action
  Alpha Creates A New Api Key For The Project

  Creates a 'publishable' or 'secret' api key for an existing supabase project, optionally with a description; 'secret' keys can have customized jwt templates.

• Action
  Alpha Get A Third Party Integration

  Retrieves the detailed configuration for a specific third-party authentication (tpa) provider, identified by `tpa id`, within an existing supabase project specified by `ref`.

• Action
  Alpha Lists All Third Party Auth Integrations

  Lists all configured third-party authentication provider integrations for an existing supabase project (using its `ref`), suitable for read-only auditing or verifying current authentication settings.

• Action
  Alpha Removes A Third Party Auth Integration

  Removes a third-party authentication provider (e.g., google, github) from a supabase project's configuration; this immediately prevents users from logging in via that method.

• Action
  Alpha Updates An Api Key For The Project

  Updates an existing supabase project api key's `description` and/or `secret jwt template` (which defines its `role`); does not regenerate the key string.

• Action
  Beta Activates A Vanity Subdomain For A Project

  Activates a vanity subdomain for the specified supabase project, requiring subsequent dns configuration for the subdomain to become operational.

• Action
  Beta Checks Vanity Subdomain Availability

  Checks if a specific vanity subdomain is available for a supabase project; this action does not reserve or assign the subdomain.

• Action
  Beta Get Project S Ssl Enforcement Configuration

  Retrieves the ssl enforcement configuration for a specified supabase project, indicating if ssl connections are mandated for its database.

• Action
  Beta Gets Current Vanity Subdomain Config

  Fetches the current vanity subdomain configuration, including its status and custom domain name, for a supabase project identified by its reference id.

• Action
  Beta Gets Project S Network Bans

  Retrieves the list of banned ipv4 addresses for a supabase project using its unique project reference string; this is a read-only operation.

• Action
  Beta Gets Project S Network Restrictions

  Retrieves the current network restriction settings (e.g., ip whitelists) for a supabase project using its reference id; this is a read-only operation for auditing or verifying network security.

• Action
  Beta Gets Project S Pgsodium Config

  Retrieves the pgsodium configuration, including the root encryption key, for an existing supabase project identified by its `ref`.

• Action
  Beta Remove Network Bans

  Removes specified ipv4 addresses from a supabase project's network ban list, granting immediate access; ips not currently banned are ignored.

• Action
  Beta Run Sql Query

  Executes a given sql query against the project's database; use for advanced data operations or when standard api endpoints are insufficient, ensuring queries are valid postgresql and sanitized. use the get table schemas or generate type script types tool to retrieve the table schema, then base your query on it.

• Action
  Beta Updates Project S Network Restrictions

  Updates and applies network access restrictions (ipv4/ipv6 cidr lists) for a supabase project, which may terminate existing connections not matching the new rules.

• Action
  Config Pgsodium Update With Root Key Warning

  Critically updates or initializes a supabase project's pgsodium root encryption key for security setup or key rotation, requiring secure backup of the new key to prevent irreversible data loss.

• Action
  Create A Database Branch

  Creates a new, isolated database branch from an existing supabase project (identified by `ref`), useful for setting up separate environments like development or testing, which can optionally be linked to a git branch.

• Action
  Create A Function

  Creates a new serverless edge function for a supabase project (identified by `ref`), requiring valid javascript/typescript in `body` and a project-unique `slug 1` identifier.

• Action
  Creates A New Sso Provider

  Creates a new saml 2.0 single sign-on (sso) provider for a supabase project, requiring either `metadata xml` or `metadata url` for saml idp configuration.

• Action
  Creates A New Third Party Auth Integration

  Call this to add a new third-party authentication method (oidc or jwks) to a supabase project for integrating external identity providers (e.g., for sso); the api may also support `custom jwks` if sent directly.

• Action
  Delete A Database Branch

  Permanently and irreversibly deletes a specific, non-default database branch by its `branch id`, without affecting other branches.

• Action
  Delete A Function

  Permanently deletes a specific edge function (by `function slug`) from a supabase project (by `ref`); this action is irreversible and requires prior existence of both project and function.

• Action
  Delete Project Vanity Subdomain

  Permanently and irreversibly deletes an active vanity subdomain configuration for the specified supabase project, reverting it to its default supabase url.

• Action
  Deploy Function

  Deploys edge functions to a supabase project using multipart upload.

• Action
  Disable Project Readonly

  Temporarily disables a supabase project's read-only mode for 15 minutes to allow write operations (e.g., for maintenance or critical updates), after which it automatically reverts to read-only.

• Action
  Disables Preview Branching

  Disables the preview branching feature for an existing supabase project, identified by its unique reference id (`ref`).

• Action
  Generate Type Script Types

  Generates and retrieves typescript types from a supabase project's database; any schemas specified in `included schemas` must exist in the project.

• Action
  Get Database Branch Config

  Retrieves the read-only configuration and status for a supabase database branch, typically for monitoring or verifying its settings.

• Action
  Get Project Api Keys

  Retrieves all api keys for an existing supabase project, specified by its unique reference id (`ref`); this is a read-only operation.

• Action
  Get Project S Pgbouncer Config

  Retrieves the active pgbouncer configuration (postgresql connection pooler) for a supabase project, used for performance tuning, auditing, or getting the connection string.

• Action
  Get Project Upgrade Eligibility

  Checks a supabase project's eligibility for an upgrade, verifying compatibility and identifying potential issues; this action does not perform the actual upgrade.

• Action
  Get Project Upgrade Status

  Retrieves the latest status of a supabase project's database upgrade for monitoring purposes; does not initiate or modify upgrades.

• Action
  Gets A Specific Sql Snippet

  Retrieves a specific sql snippet by its unique identifier.

• Action
  Gets A Sso Provider By Its Uuid

  Retrieves the configuration details for a specific single sign-on (sso) provider (e.g., saml, google, github, azure ad), identified by its uuid, within a supabase project.

• Action
  Gets Information About The Organization

  Fetches comprehensive details for a specific supabase organization using its unique slug.

• Action
  Gets Project S Auth Config

  Retrieves the project's complete read-only authentication configuration, detailing all settings (e.g., providers, mfa, email/sms, jwt, security policies) but excluding sensitive secrets.

• Action
  Gets Project S Postgres Config

  Retrieves the current read-only postgresql database configuration for a specified supabase project's `ref`, noting that some advanced or security-sensitive details might be omitted from the response.

• Action
  Gets Project S Postgrest Config

  Retrieves the postgrest configuration for a specific supabase project.

• Action
  Gets Project S Service Health Status

  Retrieves the current health status for a supabase project, for specified services or all services if the 'services' list is omitted.

• Action
  Gets Project S Supavisor Config

  Retrieves the supavisor (connection pooler) configuration for a specified supabase project, identified by its reference id.

• Action
  Get Table Schemas

  Retrieves column details, types, and constraints for multiple database tables to help debug schema issues and write accurate sql queries.

• Action
  List All Database Branches

  Lists all database branches for a specified supabase project, used for isolated development and testing of schema changes; ensure the project reference id is valid.

• Action
  List All Functions

  Lists metadata for all edge functions in a supabase project (specified by 'ref'), excluding function code or logs; the project must exist.

• Action
  List All Organizations

  Lists all organizations (id and name only) associated with the supabase account, excluding project details within these organizations.

• Action
  List All Projects

  Retrieves a list of all supabase projects, including their id, name, region, and status, for the authenticated user.

• Action
  List All Secrets

  Retrieves all secrets for a supabase project using its reference id; secret values in the response may be masked.

• Action
  List Members Of An Organization

  Retrieves all members of a supabase organization, identified by its unique slug, including their user id, username, email, role, and mfa status.

• Action
  Lists All Backups

  Lists all database backups for a supabase project, providing details on existing backups but not creating new ones or performing restores; availability may depend on plan and configuration.

• Action
  Lists All Buckets

  Retrieves a list of all storage buckets for a supabase project, without returning bucket contents or access policies.

• Action
  Lists All Sso Providers

  Lists all configured single sign-on (sso) providers for a supabase project, requiring the project reference id (`ref`) of an existing project.

• Action
  Lists Sql Snippets For The Logged In User

  Retrieves a list of sql snippets for the logged-in user, optionally filtered by a specific supabase project if `project ref` is provided.

• Action
  Removes A Sso Provider By Its Uuid

  Deletes a specific sso provider by its id (`provider id`) from a supabase project (`ref`), which disables it and returns its details; ensure this action will not inadvertently lock out users.

• Action
  Resets A Database Branch

  Resets an existing supabase database branch, identified by `branch id`, to its initial clean state, irreversibly deleting all its current data and schema changes.

• Action
  Retrieve A Function

  Retrieves detailed information, metadata, configuration, and status for a specific edge function using its project reference id and function slug.

• Action
  Retrieve A Function Body

  Retrieves the source code (body) for a specified serverless edge function using its project reference and function slug; this is a read-only operation that does not execute the function or return runtime logs.

• Action
  Returns Project S Readonly Mode Status

  Retrieves the read-only mode status for a specified supabase project to check its operational state; this action does not change the read-only state.

• Action
  Update A Function

  Updates an existing supabase edge function's properties (like name, slug, source code, jwt settings, import map) identified by project `ref` and `function slug`, supporting plain text code or eszip for the body.

• Action
  Update Database Branch Config

  Updates the configuration of a supabase database branch, allowing modification of its name, associated git branch, reset-on-push behavior, persistence, and status.

• Action
  Updates A Sso Provider By Its Uuid

  Updates an existing sso provider's saml metadata, associated email domains, or attribute mappings for a supabase project, identified by `ref` and `provider id`.

• Action
  Updates Project S Postgres Config

  Updates specified postgresql configuration parameters for an existing supabase project (`ref`) to optimize database performance; note that unspecified parameters remain unchanged, and caution is advised as incorrect settings can impact stability or require a restart.

• Action
  Updates Project S Postgrest Config

  Updates postgrest configuration settings (e.g., `max rows`, `db pool`, `db schema`, `db extra search path`) for a supabase project to fine-tune api performance, data exposure, and database resource usage.

• Action
  Updates Project S Supavisor Config

  Updates the supavisor (database pooler) configuration, such as `default pool size`, for an existing supabase project identified by `ref`; the `pool mode` parameter in the request is deprecated and ignored.

• Action
  Update Ssl Enforcement Config

  Updates the ssl enforcement configuration (enable/disable) for a specified supabase project's database.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.