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

# List Warehouse Syncs

> List warehouse syncs with their latest run

Returns every sync with its schedule, status, cursor position and latest run, including the progress of the subscriber imports it queued. Requires `warehouse:read`.

<ParamField query="connectionId" type="string">
  Only syncs of this connection.
</ParamField>

```bash theme={null}
curl "https://api.sequenzy.com/api/v1/warehouse-syncs" \
  -H "Authorization: Bearer YOUR_API_KEY"
```

## Response fields

<ResponseField name="syncs" type="object[]">
  <Expandable title="sync">
    <ResponseField name="kind" type="string">
      `subscribers` or `events`.
    </ResponseField>

    <ResponseField name="status" type="string">
      `idle`, `queued`, `running`, or `failed` (a retry is scheduled with
      backoff).
    </ResponseField>

    <ResponseField name="cursorValue" type="string | null">
      Rows with the cursor column at or after this value are read next.
    </ResponseField>

    <ResponseField name="fullResyncRequested" type="boolean">
      A full resync runs next.
    </ResponseField>

    <ResponseField name="lastError" type="string | null">
      Why the last run failed, from the warehouse or your query. Problems on
      Sequenzy's side show a generic message.
    </ResponseField>

    <ResponseField name="latestRun" type="object | null">
      The most recent run. See [List Runs](/api-reference/warehouse/syncs-runs).
    </ResponseField>
  </Expandable>
</ResponseField>

<ResponseExample>
  ```json 200 theme={null}
  {
    "success": true,
    "syncs": [
      {
        "id": "wsync_abc123",
        "connectionId": "wconn_abc123",
        "name": "Customers",
        "kind": "subscribers",
        "query": "select email, first_name, plan, updated_at from analytics.customers",
        "mapping": {
          "emailColumn": "EMAIL",
          "firstNameColumn": "FIRST_NAME",
          "attributes": [
            {
              "column": "PLAN",
              "attribute": "plan"
            }
          ]
        },
        "cursorColumn": "UPDATED_AT",
        "cursorValue": "2026-09-30T11:58:02.000Z",
        "listIds": [],
        "optInMode": "confirmed",
        "triggerAutomations": false,
        "frequency": "hourly",
        "isEnabled": true,
        "fullResyncRequested": false,
        "status": "idle",
        "nextRunAt": "2026-09-30T13:00:00.000Z",
        "lastRunAt": "2026-09-30T12:00:00.000Z",
        "lastSuccessAt": "2026-09-30T12:00:41.000Z",
        "lastError": null,
        "lastErrorAt": null,
        "consecutiveFailures": 0,
        "latestRun": {
          "id": "wrun_1",
          "syncId": "wsync_abc123",
          "status": "succeeded",
          "isManual": false,
          "isFullResync": false,
          "rowsRead": 1204,
          "rowsUnchanged": 1100,
          "rowsSynced": 98,
          "rowsSkipped": 6,
          "rowsFailed": 0,
          "errorSamples": [
            {
              "row": 17,
              "reason": "Missing email"
            }
          ],
          "subscriberImportIds": [
            "imp_1"
          ],
          "imports": [
            {
              "id": "imp_1",
              "status": "completed",
              "totalRows": 98,
              "processedCount": 98,
              "addedCount": 12,
              "updatedCount": 86,
              "skippedCount": 0,
              "failedCount": 0
            }
          ],
          "error": null,
          "startedAt": "2026-09-30T12:00:00.000Z",
          "finishedAt": "2026-09-30T12:00:41.000Z"
        },
        "createdAt": "2026-09-30T10:00:00.000Z",
        "updatedAt": "2026-09-30T12:00:41.000Z"
      }
    ]
  }
  ```
</ResponseExample>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.