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
  • Angie Addison commented
    22 Jan 06:36pm

    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
    24 Feb, 2020 08:18am

    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
    2 Feb, 2018 06:29am

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

  • Guest commented
    11 Jan, 2018 03:20pm

    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
    31 Oct, 2017 09:33pm

    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
    1 Aug, 2017 02:16am

    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
    4 May, 2017 03:13pm

    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?