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

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 bbcon 2025 Attendee Badge

    @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)

  • @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: