Get List (with Constituent ID) of Participants at Event

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

I am attempting to Create a List of Constituents who attended an Event. I specifically need their ConstituentID field to be included.

I prefer the List be generated in the RE NXT UI → Lists page.

Otherwise, the Events API endpoint only includes a “Participant ID” which then requires a 2nd lookup to identify which constituent that belongs to.

Any suggestions?

Comments

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

    @Bob Rowe
    In the Event > Working with participant list, you can add a column Constituent ID

  • Bob Rowe
    Bob Rowe
    Second Anniversary Name Dropper Participant Facilitator 1

    @Alex Wong

    Thanks! Then I am guessing the only way to get this via the API is to convert the “Event List” to a “Constituent List” manually and then grab the data there.

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

    @Bob Rowe
    I'm not sure what you trying to do at the end, but it isn't that hard to automate.

    • call event participant API to get list of participant for an event
    • call the “create list” API and create a constituent list with the records id you found in the previous step
    • call the “get constituent list” api to get list of constituent by the list ID, provided as output from above step

    do note that there isn't a “delete list” API for now, so that means the constituent list you created will “stay” in your RE instance unless you manually delete it.

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

    @Bob Rowe
    Actually, there is another way to go about this, AS LONG AS your event doesn't have too many constituent.

    The List Constituent API endpoint allow you to specify multiple constituent_id (constituent system record id, this is provided in the list participant API).

    1b0abdbde890f431f9eb2c9fc838009d-huge-im

    So you can get the participant list using the API, filtering is_constituent_filter as true. (so you only get participant that is constituent). Then call the List Constituent API directly by specifying multiple constituent_id field with each of the constituent system record id: constituent_id=1&constituent_id=2&constituent_id=3, etc.

    You can avoid the create list I mentioned before and thereby avoiding a bunch of list in RE NXT that needs to be manually deleted afterward.

    However, there IS a limit of how many allowed in an HTTP call. I do not know what is the limit though. Try it out.

Categories