Solicit codes in Power BI connector

Alex Feuchtwanger

Hello,

Are solicit codes available in the Power BI connector? I've looked but cannot find them. It would be helpful to be able to analyse data about how many constituents have certain solicit codes in Power BI.

Thanks,
Alex

Alex Wong

@Alex Feuchtwanger
solicit code is available from SKY API however, it is only available from per constituent basis:

https://developer.sky.blackbaud.com/docs/services/communication-preference/operations/ListConstituentSolicitCodesSingleConstituent

If you want to run BI report on solicit code, you will have difficult time getting all constituent's solicit code without exhausting API call limits (25K per 24hr).

If you have RE:Queue, that would be the best option to have a scheduled export from RE Database view's query to get solicit codes of all constituent for use in BI.

Alex Feuchtwanger

@Alex Wong
Thanks Alex that makes sense

Heather McLean

@Alex Feuchtwanger - Did you make any headway on this report? Care to share at the upcoming User Group?

Alex Feuchtwanger

Hi @Heather McLean, no it's not been a priority unfortunately. Would be happy to share some of the other things we've been working on if there was ever a user group meeting during my work hours!