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
- New Grantmaking TEST Community
- New Altru Test Community
- New bbcon Community - TEST
- 10 Blackbaud Agents for Good™
- New Raiser's Edge NXT Community
- 7 Blackbaud Community Help
- 217 bbcon®
- 1.4K Blackbaud Altru®
- 408 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.2K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 16 donorCentrics®
- 361 Blackbaud eTapestry®
- 2.7K Blackbaud Financial Edge NXT®
- 679 Blackbaud Grantmaking™
- 596 Blackbaud Education Management Solutions for Higher Education
- 3.3K Blackbaud Education Management Solutions for K-12 Schools
- 951 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 85 JustGiving® from Blackbaud®
- 6.9K Blackbaud Raiser's Edge NXT®
- 3.9K SKY Developer
- 255 ResearchPoint™
- 122 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 246 Member Lounge (Just for Fun)
- 40 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Closed) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) 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
- 820 Community News
- 3.1K Jobs Board
- 57 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

