System.OutOfMemoryException error when using Altru adHocQuery endpoint when using multiple fields in report.

Ana Cabrera

Hello experts,

I recently encountered an issue while using the AdHocQuery endpoint with a report of constituents. It seems that when the report contains certain fields, the response size limit is reached, resulting in errors. Removing some fields solves the problem, but this is not a permanent solution as our database grows over time. I have tried to implement pagination to manage the response size limit, but I can't find any information on how to do this with the current endpoint. Can anyone provide guidance or assistance on implementing pagination for this endpoint?

Response error: System.OutOfMemoryException' was thrown.

I found this article but didn't see the real issue:

Is there way to paginate records in this endpoint?

Son Le

something wrong with your request?

Ana Cabrera

@Son Le

Yes, I have to limit it because it fails with the System.OutOfMemoryException error. But I need all the results and I haven't found a way to get them. I tried using an offset, but it didn't work for this endpoint.

Example try:
try #1 https://api.sky.blackbaud.com/alt-anamg/adhocqueries/{query_id}[?limit=25000&offset=1]
try #2 https://api.sky.blackbaud.com/alt-anamg/adhocqueries/{query_id}[?offset=1&limit=25000].

Do you have any workaround for pagination?