Connect DonorPerfect and Timesheet

Both apps 102DonorPerfect 42Timesheet 60

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

  Triggered when a new absence is requested or recorded in the chosen Timesheet organization.

• Trigger
  New Project

  Triggered when a new project is created in Timesheet.

• Trigger
  New Rate

  Triggered when a new pay rate is created in Timesheet.

• Trigger
  New Tag

  Triggered when a new tag is created in Timesheet.

• Trigger
  New Task

  Triggered when a new tracked time entry is recorded in Timesheet.

• Trigger
  New Team

  Triggered when a new team is created in Timesheet.

• Trigger
  New Todo

  Triggered when a new to-do is created in Timesheet.

• Action
  Approve Absence

  Approves a pending absence request in a Timesheet organization. Returns the updated absence, including its new status and who approved it.

• Action
  Create Expense

  Creates an expense on a Timesheet task, with an amount, date and optional receipt. Returns the new expense with its ID.

• Action
  Create Note

  Creates a note on a Timesheet task, with text and an optional attachment. Returns the new note with its ID.

• Action
  Create Organization

  Creates a new organization (team workspace) in Timesheet. Returns the new organization with its ID.

• Action
  Create Project

  Creates a new project in Timesheet, optionally with a client, default billing rate and team. Returns the new project with its ID.

• Action
  Create Rate

  Creates a pay rate in Timesheet, such as an overtime multiplier or a bonus amount. Returns the new rate with its ID.

• Action
  Create Reminder

  Creates a reminder in Timesheet on a one-off or recurring schedule. Returns the new reminder with its ID and next fire time.

• Action
  Create Tag

  Creates a tag in Timesheet that can be applied to time entries. Returns the new tag with its ID.

• Action
  Create Task

  Creates a time entry (task) on a Timesheet project, with start and end times and optional tags, rate and mileage. Returns the new entry with its ID and duration.

• Action
  Create Team

  Creates a team inside a Timesheet organization. Returns the new team with its ID.

• Action
  Create Todo

  Creates a to-do on a Timesheet project, with an optional due date, assignees and time estimate. Returns the new to-do with its ID.

• Action
  Delete Expense

  Deletes an expense from Timesheet. Returns confirmation that the expense was removed.

• Action
  Delete Note

  Deletes a note from Timesheet. Returns confirmation that the note was removed.

• Action
  Delete Organization

  Deletes an organization from Timesheet. Returns confirmation that the organization was removed.

• Action
  Delete Project

  Deletes a project from Timesheet. Returns confirmation that the project was removed.

• Action
  Delete Rate

  Deletes a pay rate from Timesheet. Returns confirmation that the rate was removed.

• Action
  Delete Reminder

  Deletes a reminder from Timesheet. Returns confirmation that the reminder was removed.

• Action
  Delete Tag

  Deletes a tag from Timesheet. Returns confirmation that the tag was removed.

• Action
  Delete Task

  Deletes a time entry from Timesheet. Returns confirmation that the entry was removed.

• Action
  Delete Team

  Deletes a team from Timesheet. Returns confirmation that the team was removed.

• Action
  Delete Todo

  Deletes a to-do from Timesheet. Returns confirmation that the to-do was removed.

• Action
  Find Absence

  Searches absences in a Timesheet organization by member, contract, type, status or date range, and returns the first match plus the full list of matches.

• Action
  Find Expense

  Searches Timesheet expenses by text, time entry, organization or date range, and returns the first match plus the full list of matches.

• Action
  Find Note

  Searches Timesheet notes by text, time entry, organization or date range, and returns the first match plus the full list of matches.

• Action
  Find Organization

  Looks up a Timesheet organization by name and returns its ID and details. Timesheet has no organization search endpoint, so this reads your organizations and matches the name, ignoring upper/lower case.

• Action
  Find Project

  Searches Timesheet projects by name, team or status, and returns the first match plus the full list of matches.

• Action
  Find Rate

  Searches Timesheet pay rates by name, team, project or status, and returns the first match plus the full list of matches.

• Action
  Find Reminder

  Looks up a Timesheet reminder by name and returns its ID and schedule. Timesheet has no reminder search endpoint, so this reads your reminders and matches the name, ignoring upper/lower case.

• Action
  Find Tag

  Searches Timesheet tags by name, team, project or status, and returns the first match plus the full list of matches.

• Action
  Find Task

  Searches Timesheet time entries by text, project, to-do, team or date range, and returns the first match plus the full list of matches.

• Action
  Find Team

  Searches Timesheet teams by name or organization, and returns the first match plus the full list of matches.

• Action
  Find Todo

  Searches Timesheet to-dos by title, project, status or assignee, and returns the first match plus the full list of matches.

• Action
  Get Current Timer

  Returns the state of your current Timesheet timer — whether it is running, paused or stopped, and the time entry it is tracking.

• Action
  Get Project

  Returns one Timesheet project by ID, including its client, settings and tracked totals.

• Action
  Get Rate

  Returns one Timesheet pay rate by ID, including its multiplier and extra amount.

• Action
  Get Tag

  Returns a single tag by its ID, including its name, colour, archived state, owning team and total tracked time.

• Action
  Get Task

  Returns a single tracked time entry by its ID, including its description, start and end times, duration, billing flags, project, rate, member and tags.

• Action
  Get Team

  Returns a single team by its ID, including its name, description, colour, owning organization, and project and member counts.

• Action
  Pause Timer

  Pauses the running timer, starting a break. Returns the timer with its new paused state.

• Action
  Resume Timer

  Resumes a paused timer, ending the current break. Returns the timer with its new running state.

• Action
  Send Report

  Generates a timesheet report for the chosen period and emails it to the given address.

• Action
  Start Timer

  Starts the timer on a project, creating a running time entry. Returns the timer and the entry it is tracking.

• Action
  Stop Timer

  Stops the running timer and closes out the time entry it was tracking.

• Action
  Update Expense

  Updates an existing expense's description, date, amount, refund status or attached receipt. Fields left blank keep their current values.

• Action
  Update Note

  Updates an existing note's text, date or attachment. Fields left blank keep their current values.

• Action
  Update Organization

  Updates an organization's name, description, image, colour or AI chat setting. Fields left blank keep their current values.

• Action
  Update Project

  Updates an existing project's name, client, office, colour, billing defaults, salary or archived state. Fields left blank keep their current values.

• Action
  Update Rate

  Updates an existing pay rate's name, multiplier, extra amount, enabled or archived state. Fields left blank keep their current values.

• Action
  Update Reminder

  Updates an existing reminder's title, prompt, message template or schedule. Fields left blank keep their current values.

• Action
  Update Tag

  Updates an existing tag's name, colour or archived state. Fields left blank keep their current values.

• Action
  Update Task

  Updates an existing tracked time entry's project, description, times, billing flags, rate or tags. Fields left blank keep their current values.

• Action
  Update Team

  Updates an existing team's name, description, image, colour or salary visibility. Fields left blank keep their current values.

• Action
  Update Todo

  Updates an existing to-do's title, details, status, due date, assignees or time estimate. Fields left blank keep their current values.

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