> ## Documentation Index
> Fetch the complete documentation index at: https://sequinstream.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# List backfills

Returns a list of all backfills for a specific sink.

## Request fields

<ParamField path="sink_id_or_name" type="string" required>
  The name or ID of the sink
</ParamField>

## Response fields

<ResponseField name="data" type="sink_consumer[]">
  Where each `sink_consumer` is an object with the following fields:

  <ResponseField name="id" type="string">
    The unique identifier of the backfill
  </ResponseField>

  <ResponseField name="state" type="string">
    The current state of the backfill (active, completed, cancelled)
  </ResponseField>

  <ResponseField name="table" type="string">
    The name of the table that was backfilled
  </ResponseField>

  <ResponseField name="inserted_at" type="string">
    The timestamp when the backfill was created
  </ResponseField>

  <ResponseField name="sink_consumer" type="string">
    The name of the sink consumer
  </ResponseField>

  <ResponseField name="updated_at" type="string">
    The timestamp when the backfill was last updated
  </ResponseField>

  <ResponseField name="canceled_at" type="string">
    The timestamp when the backfill was cancelled (null if not cancelled)
  </ResponseField>

  <ResponseField name="completed_at" type="string">
    The timestamp when the backfill was completed (null if not completed)
  </ResponseField>

  <ResponseField name="rows_ingested_count" type="integer">
    The number of rows ingested by the backfill
  </ResponseField>

  <ResponseField name="rows_initial_count" type="integer">
    The initial number of rows to be processed
  </ResponseField>

  <ResponseField name="rows_processed_count" type="integer">
    The number of rows processed by the backfill
  </ResponseField>

  <ResponseField name="sort_column" type="string">
    The column used for sorting the backfill data
  </ResponseField>
</ResponseField>

<RequestExample>
  ```bash cURL theme={null}
  curl -X GET "https://api.sequinstream.com/api/sinks/kafka-ids/backfills" \
    -H "Authorization: Bearer YOUR_API_TOKEN"
  ```

  ```json Response theme={null}
  {
    "data": [
      {
        "id": "e0c918bb-12a2-4810-94a3-387cd672a478",
        "state": "completed",
        "table": "public.benchmark_records",
        "inserted_at": "2025-04-09T04:06:23Z",
        "sink_consumer": "kafka-ids",
        "updated_at": "2025-04-09T04:06:28Z",
        "canceled_at": null,
        "completed_at": "2025-04-09T04:06:28.000000Z",
        "rows_ingested_count": 54700,
        "rows_initial_count": 54700,
        "rows_processed_count": 54700,
        "sort_column": "benchmark_records"
      }
    ]
  }
  ```
</RequestExample>