Connect DonorPerfect and Pennylane

Both apps 81DonorPerfect 42Pennylane 39

• 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 record to a donor in DonorPerfect via the dp_saveotherinfo stored procedure. Supply Donor Id, and optionally the date and comments.

• 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 donor by first and last name

  Returns the first donor whose first and last name exactly match, plus how many donors matched

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

  Returns a single DonorPerfect contact (activity) record by its contact ID, with its standard contact columns.

• 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, with the donor's standard fields. Use Get donor user-defined field values for custom fields. 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
  Get other info

  Returns one DonorPerfect Other Info record by its id, with its standard columns.

• 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
  Set gift custom field

  Sets one of your organization's custom fields (such as Class) on an existing gift

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

• Trigger
  New Billing Subscription V2

  Triggers when a new billing subscription is created in Pennylane.

• Trigger
  New Customer Invoice V2

  Triggers when a new customer invoice or credit note is created in Pennylane.

• Trigger
  New Customer V2

  Triggers when a new customer (company or individual) is created in Pennylane.

• Trigger
  New Product V2

  Triggers when a new product is created in Pennylane.

• Trigger
  New Quote V2

  Triggers when a new quote is created in Pennylane.

• Action
  Add supplier

  Creates a supplier in Pennylane and returns the new supplier record.

• Action
  Create Company Customer V2

  Creates a company customer in Pennylane with its billing address, contact and invoicing details, and returns the new customer.

• Action
  Create Customer Invoice V2

  Creates a draft or finalized customer invoice (or credit note) in Pennylane for an existing customer.

• Action
  Create Individual Customer V2

  Creates an individual (person) customer in Pennylane with their name, billing address and invoicing preferences.

• Action
  Create Product V2

  Creates a product in Pennylane with its label, price before tax and VAT rate, and returns the created product.

• Action
  Create Quote V2

  Creates a quote for a customer in Pennylane, with its line items, dates and optional discount.

• Action
  Finalize customer invoice

  Finalizes a draft customer invoice or credit note in Pennylane, assigning its number and locking it from further edits.

• Action
  Get Billing Subscription V2

  Returns one billing subscription, including its schedule, status, customer and invoice settings.

• Action
  Get supplier

  Returns a single supplier from Pennylane by its id, including contact, address, payment terms and ledger account.

• Action
  Get supplier invoice

  Returns a single supplier invoice from Pennylane by its ID, including amounts, dates, supplier, and payment status.

• Action
  Get transaction

  Returns a single bank transaction by its id, including amount, currency, date, bank account, categories and linked customer or supplier.

• Action
  List bank accounts

  Returns the company's bank accounts with their currency, balance, journal and ledger account.

• Action
  List billing subscriptions

  Returns the billing subscriptions in the Pennylane company, optionally filtered by status, customer or start date.

• Action
  List categories

  Returns the analytical categories defined in the Pennylane company, optionally filtered by group, label or code.

• Action
  List customer invoices

  Returns customer invoices and credit notes, optionally filtered and sorted.

• Action
  List customers

  Returns a list of company and individual customers in Pennylane, optionally filtered and sorted.

• Action
  List ledger accounts

  Returns the company's ledger accounts (chart of accounts), up to 1000 per call, optionally filtered by number, id or enabled status.

• Action
  List ledger entries

  Returns the ledger entries of your Pennylane company, optionally filtered by id, date or journal and sorted by id or date.

• Action
  List products

  Returns the products in the Pennylane company, optionally filtered by label, reference or id.

• Action
  List quotes

  Returns the quotes in your Pennylane company, optionally filtered by customer or status.

• Action
  List supplier invoices

  Returns the supplier invoices in your Pennylane company, optionally filtered and sorted.

• Action
  List suppliers

  Returns the suppliers in your Pennylane company, optionally filtered and sorted.

• Action
  List transactions

  Returns the bank transactions in your Pennylane company, optionally filtered by bank account, journal, date or id.

• Action
  Retrieve Customer V2

  Returns one customer (company or individual) by its Pennylane id, including contact details, addresses and billing settings.

• Action
  Retrieve Invoice V2

  Returns one customer invoice or credit note, including its amounts, status, customer and links to its lines and payments.

• Action
  Retrieve Product V2

  Returns one Pennylane product by its id, including price, VAT rate, unit, ledger account and custom field values.

• Action
  Retrieve Quote V2

  Returns a single quote by its ID, including amounts, status, customer and dates.

• Action
  Update Billing Subscription V2

  Updates a billing subscription in Pennylane: stop or resume it, change its invoicing mode, payment terms, schedule, customer or invoice content.

• Action
  Update Company Customer V2

  Updates an existing company customer in Pennylane and returns the updated customer.

• Action
  Update customer invoice

  Updates a customer invoice in Pennylane. Draft invoices accept all fields; finalized invoices accept only label, external reference, transaction reference, invoice line imputation/performance dates and installments.

• Action
  Update Individual Customer V2

  Updates an individual (person) customer in Pennylane and returns the updated customer.

• Action
  Update Product V2

  Updates an existing product in Pennylane, such as its label, price, VAT rate or custom fields.

• Action
  Update Quote V2

  Updates an existing quote in Pennylane — its dates, customer, texts, discount, language and invoice lines — and returns the updated quote.

• Action
  Update supplier

  Updates an existing supplier in Pennylane and returns the updated supplier.

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