Connect DonorPerfect to Supabase

Both apps 101DonorPerfect 38Supabase 63

• Trigger
  New donor

  Polling trigger. Fires when a new donor is added in DonorPerfect. Polls the dp table ordered by donor_id descending; dedups on each record's donor_id.

• Trigger
  New gift

  Polling trigger. Fires when a new gift (donation) is created in DonorPerfect. Polls the dpgift table ordered by gift_id descending; dedups on each record's gift_id.

• Trigger
  New or updated donor

  Triggered when a donor is added or updated.

• Trigger
  New or updated gift

  Triggered when a gift (donation) is created or modified.

• Trigger
  Two-way sync new or updated donors

  A trigger for two-way syncing new and updated donors, with enhanced on-the-fly mapping. Can only be used with enhanced two-way sync actions that support on-the-fly mapping.

• Trigger
  Two-way sync new or updated gifts

  A trigger for two-way syncing new and updated gifts (donations), with enhanced on-the-fly mapping. Polls the DonorPerfect dpgift table.

• Action
  Add code

  Adds a new code and description to the DPCODES table. Allows you to add things like new GL Code, Solicitation, Campaign code and other code values administered in the Code Maintenance screen of DPO.

• Action
  Add contact

  Adds a contact (activity/task) record to a donor in DonorPerfect via the dp_savecontact stored procedure. Supply Donor Id, Activity Code, and contact details.

• Action
  Add donor

  Creates a new donor in DonorPerfect via the dp_savedonor stored procedure. Leave Donor Id empty (0) to create; the new donor_id is returned. Common fields: first/last name, address, city, state, zip, email, phones.

• Action
  Add gift

  Creates a new gift (donation) for a donor in DonorPerfect via the dp_savegift stored procedure. Supply Donor Id, Amount, Gift Date and code fields (GL, Solicit, Sub-solicit, Gift Type, Campaign).

• Action
  Add new donor gift

  Creates a new donation (gift) for the donor with the specified ID.

• Action
  Add new donor gift by email

  Creates a new donation for the donor with the specified email. The gift will only be added if the donor's email is found.

• Action
  Add new pledge

  Adds a new pledge to the specified donor. If successful, the pledge's ID is output.

• Action
  Add other info

  Adds an Other Info (user-defined) record to a donor in DonorPerfect via the dp_saveotherinfo stored procedure. Supply Donor Id, the field name and value.

• Action
  Add other info by email

  Adds "other info" for the first donor found with the given email address. The other info is not added if the email address is not found.

• Action
  Delete donor

  Deletes the donor with the specified Donor Id from DonorPerfect via the dp_deletedonor stored procedure.

• Action
  Find filters by name

  Returns one or more filters that match the specified name. Supports wildcard matching. An empty result is returned if no matching filter is found.

• Action
  Get 20 donor field values

  Returns up to 20 field values for the specified donor. An error occurs if the donor is not found.

• Action
  Get active code by description

  Returns the code having the specified description. An error occurs if the code is not found or is inactive.

• Action
  Get active code description

  Gets the specified code's description. An error occurs if the code is not found or is inactive.

• Action
  Get code description

  Returns the description for a code value in the specified DPO code field (e.g. GL, CAMPAIGN, SOLICIT) from the dpcodes table.

• Action
  Get donor

  Returns all available fields for the donor with the specified Donor ID from the DPO donor (dp) table.

• Action
  Get donor by email

  Returns the DonorPerfect donor whose email address matches the one supplied, including the donor's user-defined field values. An error occurs if no donor has that email address.

• Action
  Get donor by email, first name, and last name

  Returns all available donor fields if one or more donor matches the email, first name, and last name. No error occurs if a donor is not found, the emitted 'donor_id' will be empty instead.

• Action
  Get donor default field info

  Returns information about the specified donor field.

• Action
  Get donor default fields

  Returns all default fields for donors.

• Action
  Get donor gifts

  Returns all gifts (donations) for the donor with the specified Donor ID from the DPO dpgift table.

• Action
  Get donors by filter

  Returns the donor IDs that match the saved DPO filter with the specified Filter ID, via the dp_filterids stored procedure.

• Action
  Get donor user-defined field info

  Returns information about the specified donor user-defined field.

• Action
  Get donor user-defined fields

  Returns all user-defined donor fields.

• Action
  Get donor user-defined field values

  Returns all user-defined field values for the specified donor. An error occurs if the donor is not found.

• Action
  Get field display type

  Gets the specified field's display type, which can either be "code" or "description"

• Action
  Get flags by donor ID

  Returns the specified donor's flags. No error occurs if the donor is not found.

• Action
  Get gift

  Returns all fields for the gift (donation) with the specified Gift ID from the DPO dpgift table.

• Action
  Get gift user-defined field values

  Returns all user-defined field values for the specified gift (donation). An error occurs if the gift is not found.

• Action
  List filters

  Returns the ID and name of all saved DPO filters that have non-empty names from the dpfilter table.

• Action
  Post pledge payment

  Posts a payment to the specified pledge for the specified donor.

• Action
  Update donor

  Updates an existing donor in DonorPerfect via the dp_savedonor stored procedure. Supply the Donor Id of the record to update along with the field values.

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