---
title: "List changed rows of one table in a delta"
method: GET
path: "/v1/db-snapshots/deltas/{deltaId}/changes"
tags: ["DB Snapshots"]
---

# List changed rows of one table in a delta

`GET /v1/db-snapshots/deltas/{deltaId}/changes`

## Request

- Base URL: `https://api.talonic.com`
- URL: `https://api.talonic.com/v1/db-snapshots/deltas/{deltaId}/changes`
- Auth: HTTP bearer

Paged before/after values for a single table. Row counts per table
live on the delta's `tables` array — read those first to decide what
to fetch.

Persisted change rows are capped per table at capture time; when a
table's `changes_truncated` is true this list is a sample while the
delta's counts stay exact.

## Path parameters

- `deltaId` string, uuid, required

## Query parameters

- `table` string, required
- `limit` integer
- `offset` integer

## Response `200`

A page of changed rows.

- object
  - `data` DbSnapshotChange[]
    - `id` string, uuid
    - `table_key` string
    - `pk` string: Rendered identity value of the row.
    - `change_type` 'added' | 'modified' | 'removed'
    - `before` object, nullable: Row values before the change; null on `added`.
    - `after` object, nullable: Row values after the change; null on `removed`.
    - `changed_at` string, nullable: Exact write time of the row's newest change in the window, as the source's change history recorded it (external-history sources); null on platform captures, which only know the capture time.
  - `table` string: The requested table
  - `total` integer: Change rows persisted for THIS table in this delta. On a partial delta it can grow between pages, since the capture is still writing.
  - `limit` integer: The page size actually applied (requested value clamped to 500).
  - `offset` integer

## Other responses

- `400`: The request is invalid.
- `401`: Missing or invalid API key.
- `404`: The requested resource was not found.
- `429`: Daily rate limit exceeded.

---

[API](https://skmtc.dev/talonic/apis/talonic-api.md) · [All operations](https://skmtc.dev/talonic/apis/talonic-api/llms.txt) · [OpenAPI document](https://skmtc.dev/talonic/apis/talonic-api/revisions/678fe5f8c9c3?raw)