Loan Reporting API - Can it support an ascending sort order?
I'm running into an odd issue with the Loan Reporting API and thought I would post a question to make sure I am not missing something. I am using the Reporting API v3.1.0 and getting the list of loan report data... [/reporting/loans], providing a start date/time and a cursor limit. Works fine.
However, I am running into a problem because while you can retrieving the list of loans based on a given start-date/time, the results are sorted descending from the current date/time back to the oldest. So the newest loans will always show up first in the list. Is it possible to control the order to get an ascending list? I don't see anything in the documentation, so I assume that it is not supported.
The issue is that I am storing the data from the reporting API locally while spinning through the cursor. Once I get through all the loans, I can then generate a report. However, I never get through all of the loans, as while it takes a couple of hours to process them all, new loans are still being added/updated. So there's no way to pull them all from a given start date/time to current in such a way as to sore them to generate a report over tens-of-thousands of records. However, if they were simply listed ascending, I could process them, log the last run date, then pick up from there for the next run. They would always be in sync and always contain all of the date for my report. I don't see a way to do this over any sizable number of records so long as they are sorted descending.
Is there a way to control the order on the Loan Reporting API? Is that something that we can suggest for a future enhancement?