LendingLoan

List all loans

List all loans under the platform. Filtered results can be retrieved with extra parameters in the query.

get/loans

Request

  • Base URL: https://api.column.com
  • URL: https://api.column.com/loans
  • Auth: HTTP basic

Query parameters

created.gtstring date-time

Return results where the created_at field is greater than this value.

created.gtestring date-time

Return results where the created_at field is greater than or equal to this value.

created.ltstring date-time

Return results where the created_at field is less than this value.

created.ltestring date-time

Return results where the created_at field is less than or equal to this value.

ending_beforestring

A cursor for use in pagination. ending_before is an ID that defines your place in the list. For instance, if you make a list request and receive 20 objects, starting with foo_ZXhhbXBsZQo, your subsequent call can include ending_before=foo_ZXhhbXBsZQo in order to fetch the previous page of the list.

entity_idstring

Filter loans by entity ID.

limitinteger

A limit on the number of objects to be returned, between 1 and 100. The default is 10.

loan_program_idstring

Filter loans by loan program ID.

starting_afterstring

A cursor for use in pagination. starting_after is an ID that defines your place in the list. For instance, if you make a list request and receive 20 objects, ending with foo_ZXhhbXBsZQo, your subsequent call can include starting_after=foo_ZXhhbXBsZQo in order to fetch the next page of the list.

statusstring

Filter loans by status.

type'unsecured' | 'secured'

Filter loans by type.

Response

Successful response

has_moreboolean required

Whether additional loans exist beyond this page

Example response

{
  "loans": [
    {
      "allow_overpayment": false,
      "auto_sell": false,
      "balances": {
        "interest_paid": "300",
        "interest_receivable": "54400",
        "principal_charged_off": "0",
        "principal_holding": "0",
        "principal_outstanding": "6666600",
        "principal_paid": "33300",
        "retained_interest_paid": "100",
        "retained_interest_receivable": "9800",
        "retained_principal_charged_off": "0",
        "retained_principal_outstanding": "1111100",
        "retained_principal_paid": "5500",
        "servicing_fee_payable": "560"
      },
      "canceled_at": null,
      "charged_off_at": null,
      "collateral_locked_amount": 0,
      "created_at": "2025-06-06T08:00:00Z",
      "currency": "USD",
      "delinquent_at": null,
      "description": "",
      "disputed_at": null,
      "id": "loan_2zEi4Q67eiQqyQkGXPqEzWXn5Q",
      "interest_config_id": "icfg_2zEi4VfLQfR06mm1fnAGcwcNT1D",
      "is_business_seasoning_days": false,
      "is_revolving": true,
      "loan_program_id": "lpgm_2zEi4QiopsBnyfuHQweFXc7Csi8",
      "maturity_date": "2025-07-30",
      "max_principal_balance": 100000000000,
      "paid_off_at": null,
      "primary_signer_entity_id": "enti_2zEi4U3gAGjdRAVHOJ19UkyG27K",
      "retained_by_column": false,
      "seasoning_days": 2,
      "status": "current",
      "type": "unsecured"
    }
  ]
}

Changes

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