The AdHocQueryProcess method on the AppFxWebService.asmx end-point form defaults to a 32,767 row limit

Using the AdHocQueryProcess method on the AppFxWebSerrice.asmx end-point defaults at limit of 32,767 rows returned.  Setting the web.config to the max amount or another amount in the request object RowCount still returns only 32,767 rows.
This is bug in the SDK which is currently being evulated for an future fix.  

Workaround:
Update the web.config 'AdHocQueryMaxRecordsMaximum' key to the max value of  2,147,483,647 and then in the API request object set the RowCount property to 0.  

 

Environment

 Blackbaud Infinity SDK
 4.0

Was this article helpful?