How to fetch Solicit Codes/Communication preferences in bulk?
we have around 50,000 constituents, and would like to export solicit codes for all of them. Currently, the only way we've found to fetch the codes is using request
GET ListConstituentCommunicationPreferencesSingleConstituent
but that only lists the values we need for a single constituents. Fetching this for 50000 will take a lot of time, and also quickly exhaust our daily request limit.
Is there a way to fetch solicit codes/communication preferences in a reasonable amount of requests? We don't actually need the exact solicit codes/communication preferences, we just need to distingish between 3 concrete codes. I thought maybe there was an endpoint to list constituents, while filtering by their codes - that would also technically work for us - we could deduce that way which constituents have which codes, but I didn't find such endpoint.
Any help is much appreciated.
Comments
-
@Blackbaud1 API1
Unfortunately there isn't anyway to do this “nicely” over SKY API currently.I get this through using database view query > RE:Queue scheduled export > Power Automate flow to process the csv into data warehouse. (4hrs interval sync)
0 -
@Blackbaud1 API1 I agree with this and have also faced this as an issue. I created an idea on the ideas page. Feel free to vote on it:
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 209 bbcon®
- 1.4K Blackbaud Altru®
- 395 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 359 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 563 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 243 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 779 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

