---
title: "List delinquent loans"
method: GET
path: "/api/v1/dashboard/delinquent-loans"
tags: ["Dashboard"]
---

# List delinquent loans

`GET /api/v1/dashboard/delinquent-loans`

Returns delinquent loan drill-down rows for a portfolio and bucket at a requested business date.

## Query parameters

- `portfolioId` string, uuid, required — Portfolio identifier.
- `asOf` string, date — Business date (YYYY-MM-DD); defaults to today (UTC).
- `productIds` string[], nullable — Filter by loan product identifiers (repeat to pass multiple).
- `productVersionIds` string[], nullable — Filter by loan product version identifiers (repeat to pass multiple).
- `bucketCode` 'current' | '1_30' | '31_60' | '61_90' | '91_plus' | 'par30' | 'par60' | 'par90' — Delinquency bucket code.
- `assignedOfficerId` string, uuid — Filter by assigned officer identifier.
- `limit` integer — Page size.
- `offset` integer — Page offset.

## Response `200`

OK

- DelinquentLoansHumaBody
  - `asOfDate` string, date-time, required — Business date the rows were computed for (RFC3339, UTC midnight).
  - `freshness` DashboardFreshnessHuma, required
    - `generatedAt` string, date-time, required — Timestamp when the snapshot was generated (RFC3339, UTC).
    - `isStale` boolean, required — True when the snapshot is older than the freshness policy allows.
    - `liveFallbackUsed` boolean, required — True when no usable snapshot existed and metrics were computed live as a fallback.
    - `policyCode` string, required — Code of the freshness policy applied to evaluate staleness.
    - `policyPersistedAt` string, date-time, required — Timestamp when the active freshness policy was last persisted (RFC3339, UTC).
    - `snapshotAsOfDate` string, date-time, required — Business date the source snapshot was computed for (RFC3339, UTC).
    - `snapshotId` string, required — Identifier (UUID) of the snapshot the metrics were read from; empty when served live.
    - `source` string, required — Origin of the metrics (e.g. snapshot vs. live computation).
    - `stalenessReason` string — Explanation of why the data is considered stale; omitted when fresh.
  - `limit` integer, required — Page size echoed back from the request (max rows in this response).
  - `loans` DelinquentLoanRowHuma[], nullable, required — Delinquent loan drill-down rows for the page; always a JSON array (never null).
    - `asOfDate` string, date-time, required — Business date the row was computed for (RFC3339, UTC midnight).
    - `assignedOfficerId` string, required — Identifier (UUID) of the loan officer assigned to the loan.
    - `assignedOfficerName` string, required — Display name of the assigned loan officer.
    - `borrowerId` string, required — Borrower identifier (UUID) who holds the loan.
    - `borrowerName` string, required — Display name of the borrower.
    - `bucketCode` string, required — Delinquency bucket the loan falls into (one of current, 1_30, 31_60, 61_90, 91_plus, par30, par60, par90).
    - `daysOverdue` integer, required — Number of days past the oldest unpaid due date as of the business date.
    - `loanAccountId` string, required — Loan account identifier (UUID) for this delinquent loan.
    - `oldestDueDate` string, date-time, required — Due date of the oldest unpaid installment driving the delinquency (RFC3339, UTC).
    - `outstandingAmount` string, required — Total outstanding principal balance on the loan (decimal string, two-decimal scale).
    - `overdueAmount` string, required — Total past-due amount on the loan (decimal string, two-decimal scale).
    - `productId` string, required — Loan product identifier (UUID) the loan was originated under.
    - `productVersionId` string, required — Loan product version identifier (UUID) governing this loan's terms.
  - `offset` integer, required — Zero-based row offset echoed back from the request.

## Other responses

- `default` — Error

---

[API](https://skmtc.net/lerian/apis/identity-plugin.md) · [All operations](https://skmtc.net/lerian/apis/identity-plugin/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/lerian/identity-plugin/versions/25daba385532/schema)