Borrower Payments - Command by ClearGrid AI

Property	Value
Dataset code	`D07`
Section code	`S2` — Payments & Settlements
Endpoint path	`/exports/S2/D07`
Cursor field	`updated_at`
Page size	`1`–`1000` (default `500`)
Availability	Phase 1 — generally available
Pagination	Direct (constant page size)

Each row is one payment event we processed against a customer’s account. It includes the amount, the payment type, the status, and whether we have settled it with you yet.

Fields

Field	Type	Description	Notes
`public_id`	string	Stable public identifier for the payment.
`amount`	integer	Payment amount in minor units (fils/cents).	`75000` = SAR 750.00
`settled_amount`	integer	Amount settled to the lender, in minor units.	`0` until settled
`payment_type`	string	Type of payment (e.g. `PAID_TO_LENDER`).
`payment_status`	string	Processing status (e.g. `SUCCESS`, `PENDING`, `FAILED`).
`is_settled`	boolean	Whether the payment has been settled to the lender.
`paid_before_submission`	boolean	Whether the payment was made before the account was submitted to ClearGrid.
`paid_date`	string \| null	When the payment was made (ISO-8601).
`failure_reason`	string \| null	Reason for failure when `payment_status` is `FAILED`.	`null` otherwise
`created_at`	string	Row creation timestamp (ISO-8601).
`updated_at`	string	Last-modified timestamp (ISO-8601).	Cursor field

Sample row

{
  "public_id": "b1f4c2e0-9a73-4d21-8c54-7e2a1d9b0f31",
  "amount": 75000,
  "settled_amount": 75000,
  "payment_type": "PAID_TO_LENDER",
  "payment_status": "SUCCESS",
  "is_settled": true,
  "paid_before_submission": false,
  "paid_date": "2026-05-18T08:12:44.000Z",
  "failure_reason": null,
  "created_at": "2026-05-18T08:12:45.221Z",
  "updated_at": "2026-05-18T08:30:02.108Z"
}

Pagination characteristics

This dataset is direct — it is filtered to your tenant by lender_id on the collection itself, so each page returns a constant number of rows until the last page. rows.length < limit reliably means you have reached the end.

Use cases

Daily reconciliation against payments settled to the lender.
First-payment-after-PTP attribution.
Failure-rate monitoring by payment_type and failure_reason.