This is awesome!

Apr 8, 2010 at 4:01 PM
Edited Apr 8, 2010 at 4:02 PM

Thank you so much for posting this. The Raiser's Edge API has been driving me nuts the last few days and the ability to actually get a DataTable so I can see what I'm pulling is HUGE for me.

For anyone who's struggling in getting started, here's what I did:

public List<string> GetTest()
{
List<string> rtn = new List<string>();
Parise.RaisersEdge.Toolkit.Entities.Managed.RaisersEdgeAPI api = new Parise.RaisersEdge.Toolkit.Entities.Managed.RaisersEdgeAPI(BlackbaudSerialNumber, BlackbaudUsername, BlackbaudPassword, BlackbaudDBNumber, Blackbaud.PIA.RE7.BBREAPI.AppMode.amServer);
Parise.RaisersEdge.Toolkit.Entities.Managed.Query query = new Parise.RaisersEdge.Toolkit.Entities.Managed.Query("APIGetChapters", api.SessionContext);
DataTable dt = query.OpenQuerySetAsDataTable();
foreach (DataColumn dc in dt.Columns)
{
rtn.Add(dc.ColumnName);
}
return rtn;
}

This is just a test method with the goal of seeing what actual column names my query is pulling. Next I'll set up custom entities and map the columns to them. You have saved me from my pulling my hair out! Thanks again.

Apr 23, 2010 at 9:05 PM

I need to do a Raiser's Edge integration. Any guidance on how to start?