Get loan sale summaries for loans already sold

Get loan sale summaries for loans already sold. Data returned by this API are updated daily after loan_daily_summary reports are generated. Read more.

get/loans/sales/summaries/sold

Request

Base URL: https://api.column.com
URL: https://api.column.com/loans/sales/summaries/sold
Auth: HTTP basic

Query parameters

datestring

Effective date of the loan daily summary report. Format: YYYY-MM-DD. If not specified, loan sale summaries from the latest loan_daily_summary report will be returned.

expandstring[]

List of fields to be expanded. Format: expand=field_1&expand=field_2. Available values: loans (return list of loan sale details).

loan_program_idstring

Filter loan sale summaries by loan program ID.

Response

Successful response

currency_codestring required

Currency of the loan

effective_datestring required

Effective date of loan sales. Format: YYYY-MM-DD

loan_countinteger required

Number of loans for sale

total_feestring required

Total fee amount in cents of loans for sale

total_intereststring required

Total interest amount in cents of loans for sale

total_principalstring required

Total principal amount in cents of loans for sale

total_sale_pricestring required

Total sale price for loans at the end of the effective date

Example response

{
  "currency_code": "USD",
  "effective_date": "2025-08-07",
  "loan_count": 2,
  "loans": [
    {
      "fee": "100",
      "id": "loan_3112JdNBZLqeFREfkTIkGZR0fpw",
      "interest": "1000",
      "loan_program_id": "lpgm_3112JdzqLGdrBCljdV6UPSKqhJf",
      "principal": "100000",
      "sale_price": "100900"
    },
    {
      "fee": "100",
      "id": "loan_3112Jm6zh5BBnQQUq5BODMzODWY",
      "interest": "1000",
      "loan_program_id": "lpgm_3112JqzDIjsvbsJ5XYLA9amU1VS",
      "principal": "100000",
      "sale_price": "100900"
    }
  ],
  "total_fee": "200",
  "total_interest": "2000",
  "total_principal": "200000",
  "total_sale_price": "201800"
}

Changes

No recorded changes to this operation across all 1 revision of this API.