Skip to main content
PropertyValue
Dataset codeD17
Section codeS3 — Collections Cases
Endpoint path/exports/S3/D17
Cursor fieldcreated_at
Page size1–1000 (default 500)
AvailabilityAvailable (v1.2)
PaginationVia (variable page size — joined through a parent)
Each row is one activity recorded against a borrower deal — a stage change, agent assignment, manual touch, and so on.

​
Fields

FieldTypeDescriptionNotes
public_idstringStable per-row identifier (string-cast Mongo _id).Use as the warehouse primary key
actionstringAction code (e.g. stage_changed, assigned).
commentstring | nullOptional comment.
created_bystringActor (user id or system tag).
detailsobjectSub-object describing the change.Inner keys: oldStage, newStage, assignedUserName
created_atstringEvent timestamp (ISO-8601).Cursor field

​
details object

FieldTypeDescription
oldStagestring | nullStage before the change.
newStagestring | nullStage after the change.
assignedUserNamestring | nullAgent assigned as part of this activity.

​
Sample row

{
  "public_id": "664b1c2d3e4f5a6071829017",
  "action": "stage_changed",
  "comment": "Customer requested a call back next week",
  "created_by": "agent_4471",
  "details": {
    "oldStage": "stage_new",
    "newStage": "stage_negotiation",
    "assignedUserName": "Mariam Al-Shehri"
  },
  "created_at": "2026-05-22T11:14:05.000Z"
}

​
Pagination characteristics

This dataset is via — it is filtered to your tenant by joining through its parent (deal_id → BorrowerDeals). On multi-tenant databases a single response may contain fewer rows than your limit even when more data exists. The cursor still advances correctly — keep paging until nextCursor is null. See Pagination → Variable page size.

​
Use cases

  • Case-activity audit trail.
  • Agent productivity attribution.
  • Stage-funnel analysis.

Need Help?

Our support team is available Monday-Friday, 9 AM - 6 PM GST. Reach out at support@cleargrid.co or visit our help center.