Assigned Appeal

Kelly Hogan

I tried searching but did not find anything. I am guessing it is not available but maybe I am just missing it. I was hoping to add information about Constituent Assigned Appeal and Response to my PowerBI reports. Along with number solicited per package etc.

Alex Wong

@Kelly Hogan
you can only get constituent assigned appeal info 1 constituent at a time:

https://developer.sky.blackbaud.com/api#api=56b76470069a0509c8f1c5b3&operation=ListConstituentAppealsSingleConstituent&definition=ConstituentAppealRead

problem trying to get these info into power bi is going to be iterating each constituent.

It is possible to do, but difficult and may go over your daily API call limit if you have too many constituent.

You will be better off using RE:Queue (or if you do not have RE:Queue, then manually exporting constituent assigned appeal data from database view) to get the data in csv, store in a cloud storage (i.e. SharePoint) and load into Power BI

Kelly Hogan

@Alex Wong
Thank you!

Alex Wong

@Kelly Hogan
or you can wait for the Query API, which is supposedly coming soon