Fundraisers - Easy way to get list of solicitors & their constituents

We need an efficient way to get a list of all solicitors and the constituents assigned to each of them. The closest endpoint now is the Constituent Fundraiser List but since that is only for single constituents it really is not helpful if your end goal is to find out which of your constituents are solicitors and for each of those which other constituents are assigned to them. We've got over 370,000 constituents so there is no practical way for us to make API calls for each one individually to see if they happen to have any fundraisers - with a 25,000 call daily limit it'd take over 2 weeks to go through them all if we did nothing else!

I'd like to request a new List endpoint that would return a list of all Solicitor constituents who have fundraisers under them. Even better if the result set is nested to include who each of those fundraisers are. But even just getting a list of who is a Solicitor would be huge since it'd mean we only had to use the existing Constituent Fundraiser list calls on the say 50 constituents who actually are solicitors vs wasting calls asking for every constituent.

 

(See also https://community.blackbaud.com/forums/viewtopic/426/32552?post_id=120180 )

  • Guest
  • May 1 2017
  • Planned
  • Attach files
      Drop here to upload
    • Angie Addison commented
      22 Jan 18:36

      Is this a dead topic? It's been quite a few years in Planned status and early on seemed imminent but has gone cold. We would be grateful if we could listen for add/change events on constituent fundraiser assignment, or if those actions updated the mod date on constituents itself then we could program to always get updated fundraiser when that happens or if we could have the inverse of what's available today and get a fundraiser endpoint that is passing a fundraiser constituent id and getting all their assigned constituents as part of our daily job. Any of those would be progress. Thanks!

    • S Natt commented
      February 24, 2020 08:18

      Hello,

      has there been any updates on this? i believe we still only have Fundraiser Assignment list (Single Constituent) option and not one for all ourconstituents in the database. Also attaching the voting for a similar issue:

      https://blackbaud-developer.ideas.aha.io/ideas/API-I-230

    • Guest commented
      February 02, 2018 06:29

      same here, it is really painful and inefficient to get the fundraisers list by using the current fundraiser list endpoint. 

    • Guest commented
      January 11, 2018 15:20

      Is there any ETA on "We will soon be introducing a fundraiser list, as well as fundraiser management endpoints for creating and editing goals and assignments for existing fundraisers. " ?

    • Deleted User commented
      October 31, 2017 21:33

      I apologize for the delay with this functionality. The body of work ended up being more complicated than expected, and we hit some roadblocks with the underlying data service implementation. However, we are continuing to churn through it as we speak.

       

      We will soon be introducing a fundraiser list, as well as fundraiser management endpoints for creating and editing goals and assignments for existing fundraisers. Again, due to some unexpected complications, the ability to create a fundraiser will still be a ways out.

    • Guest commented
      August 01, 2017 02:16

      Any update on implementing this? Back in May it was a month or so away and it's now the end of July.

       

      As for the need to manipulate/create fundraiser relationships it isn't currently a need. For my immediate purposes I just need a way to get back the existing data.

    • Deleted User commented
      May 04, 2017 15:13

      Hi Brian,

      My team is actively doing research into this area right now! We expect to have some endpoints related to managing existing fundraisers in the next month or so, available in the Fundraising API. This will include getting a list of fundraisers, fetching their assigned constituents, and getting collections of their fundraising goals.

       

      Are you also interested in manipulating these relationships, such as creating new fundraiser relationships, or are you predominately focused on retrieving the existing ones?