Blend API Docs

Blend Developer Portal

Welcome to the Blend developer portal. You'll find comprehensive guides and documentation to help you start working with Blend as quickly as possible, as well as support if you get stuck. You may also visit our public Github repository to download our OpenAPI specs directly. Let's jump right in!

Get Started    API Reference

Questions

Ask A Question
0

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?

Posted by Jon Rothlander about a year ago