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