Connect Lexware Office to Supabase

Both apps 113Lexware Office 50Supabase 63

• Trigger
  Contact updated (instant)

  Fires when a contact changes in Lexware Office. Event type: contact.changed.

• Trigger
  Invoice status changed (instant)

  Fires when an invoice's status changes in Lexware Office. Event type: invoice.status.changed.

• Trigger
  New article (instant)

  Fires when a new article is created in Lexware Office. Event type: article.created.

• Trigger
  New contact (instant)

  Fires when a new contact is created in Lexware Office. Event type: contact.created.

• Trigger
  New credit note (instant)

  Fires when a new credit note is created in Lexware Office. Event type: credit-note.created.

• Trigger
  New invoice (instant)

  Fires when a new invoice is created in Lexware Office. Event type: invoice.created.

• Trigger
  New order confirmation (instant)

  Fires when a new order confirmation is created in Lexware Office. Event type: order-confirmation.created.

• Trigger
  New quotation (instant)

  Fires when a new quotation is created in Lexware Office. Event type: quotation.created.

• Trigger
  New voucher (instant)

  Fires when a new bookkeeping voucher is created in Lexware Office. Event type: voucher.created.

• Trigger
  Payment changed (instant)

  Fires when the payment status of a sales voucher changes in Lexware Office. Event type: payment.changed.

• Action
  Create a contact

  Creates a contact in Lexware Office as a person or a company, with optional billing address, email, phone and note, and returns the new contact's ID.

• Action
  Create a credit note

  Creates a credit note in Lexware Office for an existing contact or a typed-in address, with your line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a delivery note

  Creates a delivery note in Lexware Office for an existing contact or a typed-in address, with your delivered line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a dunning

  Creates a dunning (payment reminder) in Lexware Office, normally chasing an unpaid invoice. Saves it as a draft unless you choose to finalize it.

• Action
  Create an article

  Creates a product or service article in Lexware Office with its unit, price and tax rate, and returns the new article's ID.

• Action
  Create an invoice

  Creates an invoice in Lexware Office for an existing contact or a typed-in address, with your line items and payment terms. Saves it as a draft unless you choose to finalize it.

• Action
  Create an order confirmation

  Creates an order confirmation in Lexware Office for an existing contact or a typed-in address, with your confirmed line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a quotation

  Creates a quotation in Lexware Office for an existing contact or a typed-in address, with your quoted line items and an expiry date. Saves it as a draft unless you choose to finalize it.

• Action
  Create a voucher

  Books a voucher (an incoming or outgoing document) into Lexware Office with its booking lines, and returns the new voucher's ID.

• Action
  Delete an article

  Deletes an article from Lexware Office by its ID.

• Action
  Download a credit note file

  Returns the PDF file ID and download URL for a finalized credit note in Lexware Office.

• Action
  Download a delivery note file

  Returns the PDF file ID and download URL for a finalized delivery note in Lexware Office.

• Action
  Download a dunning file

  Returns the PDF file ID and download URL for a finalized dunning in Lexware Office.

• Action
  Download a file

  Downloads the actual bytes of a file stored in Lexware Office by its file ID — for example the PDF that "Download an invoice file" reports. Returns the file so a later step can email, upload or attach it.

• Action
  Download an invoice file

  Returns the PDF file ID and download URL for a finalized invoice in Lexware Office.

• Action
  Download an order confirmation file

  Returns the PDF file ID and download URL for a finalized order confirmation in Lexware Office.

• Action
  Download a quotation file

  Returns the PDF file ID and download URL for a finalized quotation in Lexware Office.

• Action
  Find articles

  Searches the Lexware Office article list by article number, barcode or type, and returns the matching articles a page at a time.

• Action
  Find contacts

  Searches Lexware Office contacts by email, name, number or role, and returns the matching contacts a page at a time.

• Action
  Find voucher list

  Lists Lexware Office documents (invoices, credit notes, quotations and the rest) filtered by type, status, contact and date, a page at a time.

• Action
  Find vouchers

  Finds booked vouchers in Lexware Office by their document number and returns the full voucher records.

• Action
  Get a contact

  Returns one Lexware Office contact by its ID, with its roles, person or company details, addresses, emails and phone numbers.

• Action
  Get a credit note

  Returns one Lexware Office credit note by its ID, with its recipient, line items, totals and status.

• Action
  Get a delivery note

  Returns one Lexware Office delivery note by its ID, with its recipient, delivered lines and delivery date.

• Action
  Get a dunning

  Returns a single dunning (payment reminder) by its ID, including its addressee, line items, totals and PDF file reference.

• Action
  Get an article

  Returns a single article (product or service) by its ID, including its name, article number, unit and pricing.

• Action
  Get an invoice

  Returns a single invoice by its ID, including its addressee, line items, totals, payment terms and PDF file reference.

• Action
  Get an order confirmation

  Returns a single order confirmation by its ID, including its addressee, line items, totals and PDF file reference.

• Action
  Get a quotation

  Returns a single quotation by its ID, including its addressee, line items, totals, expiry date and PDF file reference.

• Action
  Get a voucher

  Returns a single bookkeeping voucher by its ID, including its type, contact, amounts, line items and attached files.

• Action
  Get payment information

  Returns the payment status of a voucher, such as an invoice: how much is still open, when it was paid, and the individual payments booked against it.

• Action
  Pursue to a credit note

  Creates a credit note that follows on from an existing invoice, linking the two in Lexware Office. Copies the invoice's recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to a delivery note

  Creates a delivery note that follows on from an existing order confirmation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to a dunning

  Creates a dunning (payment reminder) that follows on from an unpaid invoice, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to an invoice

  Creates an invoice that follows on from an existing order confirmation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to an order confirmation

  Creates an order confirmation that follows on from an existing quotation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Update a contact

  Updates an existing contact in Lexware Office. Reads the contact first and changes only the details you fill in, leaving everything else as it was.

• Action
  Update an article

  Updates an existing article in Lexware Office. Reads the article first and changes only the details you fill in, leaving everything else as it was.

• Action
  Update a voucher

  Updates an existing bookkeeping voucher in Lexware Office. Reads the voucher first and changes only the details you fill in, leaving everything else as it was.

• Action
  Upload Document for Bookkeeping Purposes

  Uploads a receipt or other document to Lexware Office for bookkeeping and returns its file ID, which you can attach to a voucher.

• 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.