General

Searching and filtering loan information is a common lending request. Here's what you need to know:

• Instead of a GET, this search uses a POST request. This allows you to add a payload body that filters for loans that match your criteria. The parameters in the endpoint, meanwhile, let you specify how you want the results displayed—how many entries, how they should be ordered, where to start, and what to expand.
• Pulling large amounts of loan information this way can take some time. If you have vast amounts of loan data, we suggest using a database query instead if the option is available to you.

For more information, our Elasticsearch Loan Mappings article gives a full list of the filters you can use on this request.

For an example on how searching works within the UI, take a look at our Advanced Search Options article.

Database

For information on Loan database tables, see the following articles:

• Database – Loan Table (loan_entity)
• Database – Loan Document Entity (loan_document_entity)
• Database – Loan Status Entity (loan_status_entity)

{
     "query": {
          "bool": {
               "must": {
                    "match": {
                         "loanAmount": 10000
                    }
               },
               "filter": {
                    "range": {
                         "contractDate": {
                              "gte": "2020-10-01",
                              "lte": "2020-10-31"
                         }
                    }
               }
          }
     }
}

📘

Try It Instructions

Our requests often provide sample payload information so that you can receive a 200 response from simply hitting the Try It button. This request is ready for you—hit Try It to send the request.

However, if you would like to try this request with your own tenant account, make sure to change the headers to match your own authentication information.