Connect DonorPerfect and RO App

Both apps 93DonorPerfect 42RO App 51

• 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
  Ad Campaigns

  Triggers when a new ad campaign is added in RO App.

• Trigger
  Cash Flow Items

  Triggers when a new cash flow category (income or expense item) is added in RO App.

• Trigger
  Clients List

  Triggers when a new client (person contact) is added in RO App.

• Trigger
  Employees List

  Triggers when a new employee is added to the RO App company account.

• Trigger
  Lead Types

  Triggers when a new inquiry (lead) type is added to your RO App account.

• Trigger
  List of Services

  Triggers when a new service is added to the RO App service catalog.

• Trigger
  List of the Products

  Triggers when a new product is added to the RO App catalog, optionally limited to products matching a name, barcode, SKU, code, MPN or category.

• Trigger
  Locations

  Triggers when a new location is added to your RO App company.

• Trigger
  New Invoice Statuses

  Triggers when a new invoice status is added to your RO App account.

• Trigger
  New Order Items

  Triggers when a new item (product or service) is added to the selected order.

• Trigger
  New Taxes

  Triggers when a new tax rate is added to the company in RO App.

• Trigger
  Order Statuses

  Triggers when a new order status is added to your RO App account.

• Action
  Add Booking Item

  Adds a product or service line item to an existing booking.

• Action
  Add Lead Comment

  Adds a comment to a lead (inquiry) in RO App.

• Action
  Add Order Comment

  Adds a comment to an existing order in RO App, optionally marked private.

• Action
  Add Task Comment

  Adds a comment to a task in RO App.

• Action
  Changing Order Status

  Changes the status of an order, optionally with a comment.

• Action
  Create a Client

  Creates a new client (person) in your RO App contacts.

• Action
  Create a Lead

  Creates a new lead (inquiry) in RO App, optionally linked to a client, location, manager and ad campaign.

• Action
  Create an Order

  Creates a new order in RO App for a client at a chosen location.

• Action
  Create an Order Item

  Adds a product or service line item to an existing order in RO App.

• Action
  Create an Order or Estimate

  Creates a new estimate in RO App for a client at a location.

• Action
  Create a Payment

  Records an income or expense payment in a cashbox in RO App.

• Action
  Create Asset

  Creates a new asset (such as a vehicle or device) in RO App, identified by its serial number.

• Action
  Create Booking

  Creates a new booking for a client at a location with an assigned employee and time slot.

• Action
  Create Product

  Creates a new product in the RO App catalog.

• Action
  Create Service

  Creates a new service in the RO App catalog.

• Action
  Create Task

  Creates a task in RO App with a title, due date and assigned employees, optionally linked to an order, lead, client or invoice.

• Action
  Create Update_booking

  Updates an existing booking's location, status, assignee, client, schedule, resource or comment.

• Action
  Find Product

  Finds products in the RO App catalog by name, barcode, SKU, code, manufacturer part number or category.

• Action
  Find Service

  Finds services in the RO App catalog by name, barcode or category.

• Action
  Get Booking Items

  Returns all the service items on a specific booking.

• Action
  Get Client by ID

  Returns the details of a single client (person) by its ID.

• Action
  Get Estimate by ID

  Returns the full details of a single estimate, including its custom field values.

• Action
  Get Lead by ID

  Returns a single lead (inquiry) by its ID, including its custom fields.

• Action
  Get Order by Id

  Returns the full details of a single order by its ID.

• Action
  Get Prices

  Returns the list of price types (margins) configured for your company.

• Action
  Get Product by Id

  Returns a single product from your RO App catalog by its ID, including its custom fields.

• Action
  Get Product Categories

  Returns the product categories in your RO App catalog, optionally limited to the children of one parent category.

• Action
  Get Service Categories

  Returns the list of service categories in your RO App catalog, optionally under a parent category.

• Action
  Get Task

  Returns a single task by its ID, including all of its details.

• Action
  Get UOMs (Inits of Measure)

  Returns the list of product units of measure (UOMs) defined in the RO App account.

• Action
  Move Asset

  Moves an asset to a different warehouse.

• Action
  Search for Assets

  Searches assets by serial number (VIN, IMEI), optionally narrowed by warehouse, owner or asset ID.

• Action
  Search for Clients

  Searches clients (people) by name, phone, email, manager, tag or date, and returns the matching clients.

• Action
  Search Task

  Searches tasks for ones whose title or description contains the given text, optionally narrowed by author, assignee or deadline.

• Action
  Update an Order Item

  Updates an existing item on an order — its quantity, price, cost, discount, warranty, taxes, assignee or comment.

• Action
  Update an Order or Estimate

  Updates an existing order (or estimate) in RO App — its location, type, people, schedule, notes, due date and custom field values. Fields left blank are not changed.

• Action
  Update_booking_item

  Updates the quantity, price, cost, discount, warranty, taxes or comment of an item on a booking.

• Action
  Update Client

  Updates an existing client (person) in RO App contacts.

• Action
  Update Product

  Updates an existing product in the RO App catalog, such as its title, SKU, category, prices or barcodes.

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