LendingPayments

List all payments

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

get/loans/payments

Request

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

Query parameters

bank_account_idstring

Filter loan payments by bank account ID.

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.

limitinteger

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

loan_idstring

Filter loan payments by loan 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.

Response

Successful response

has_moreboolean required

Whether additional payments exist beyond this page

Example response

{
  "payments": [
    {
      "account_number_id": "acno_2zI1Da9Ro0dvk6HT2gla1H0UTyS",
      "amount": 1000,
      "bank_account_id": "bacc_2zI1DavEbJQbbOIJeExDVJczhqM",
      "collection_account_number_id": "",
      "collection_bank_account_id": "",
      "created_at": "2025-08-03T16:05:12Z",
      "currency": "USD",
      "description": "first payment",
      "effective_at": "2025-08-03T16:05:12Z",
      "id": "lpmt_30mdxZgaXqKELJ5xRVKKj2x3Vrz",
      "idempotency_key": "",
      "ignore_retained_balances": false,
      "interest_amount": 200,
      "is_offline": false,
      "loan_id": "loan_30mcttnSZBlSahXy6LUFzbeemlk",
      "principal_amount": 800,
      "retained_interest_amount": 0,
      "retained_principal_amount": 0,
      "status": "completed"
    }
  ]
}

Changes

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