Pull list of "Donations" per Event API Call Trouble

Bob Rowe
Bob Rowe
Second Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Raiser's Edge NXT® APIs

I have been researching the API documentation.

Goal: Pull list of all “Donations” for an Event.

The Gift entity does not have an Event_id parameter to search. The Gift entity does have a GiftSubType where I can search type of “Donations”. But, I do not see how to link that back to a specific Event_id.

I don't see in the Event entity where I can pull a list of Gifts for that Event_id.

Any guidance would be appreciated.

Comments

  • Kris Mahon
    Kris Mahon Blackbaud Employee
    Tenth Anniversary Facilitator 1 Blackbaud Staff Loyalty Badge

    @Bob Rowe We currently don't have a single endpoint to get all donations per event. You will need to first call the GetEventParticipantList endpoint, loop through the results, and then call either the GetParticipantDontations endpoint or the GetParticipantFeePayments endpoint per participant (depending on what your exact need is) which will return you “gift_id” values. If you need more info about the specific gifts, then you will need to use the Gift API to fetch that information based on the “gift_id” value.

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    Giving my 2-cents here:

    Exactly b/c there's no direct relationship between event and appeal, you can only go round-about way with Participation Registration Fee Linking, we have made it a rule that every Event record has a corresponding Appeal record. Meaning, if we have an event for NY 2022 Gala, with Event ID (lookup ID) DIN22NY. There will be an Appeal record with Appeal ID (lookup ID) DIN22NY.

    Every gift record that came in “because/for" the event will be coded with DIN22NY appeal. Notice they ARE 2 separate record type and therefore they do have different record id. Unforunately, there is currently no API that allow you to lookup Appeal by lookup ID, so you will have to find other ways to “find” the record ID of the appeal that correspond to the event. We keep a data warehouse of most RE data, so I can query to get record id from lookup id. You can do the same or other means of getting all appeals and then filter/lookup the record id from lookup id (that is the Event ID).

Categories