---
title: "List data integrity jobs for a destination"
method: GET
path: "/destinations/{destination_id}/data-integrity"
tags: ["Data Integrity"]
---

# List data integrity jobs for a destination

`GET /destinations/{destination_id}/data-integrity`

Get a list of data integrity jobs for a destination.

## Path parameters

- `destination_id` string, required

## Query parameters

- `page_size` integer
- `order` 'asc' | 'desc'
- `cursor` string

## Response `200`

OK

- object
  - `status` 'success', required
  - `data` ListDataIntegrityJobResponse, required
    - `jobs` DataIntegrityJobResource[], required
      - `id` string, required
      - `org_schema` string, required
      - `submitted_at` string, date-time, required — Timestamp when the job was submitted.
      - `started_at` string, date-time, required — Timestamp when the job started execution.
      - `ended_at` string, date-time, required — Timestamp when the job ended execution.
      - `destination_id` string, required — The unique identifier of the destination associated with this job.
      - `status` string, required — The current status of the job.
      - `model_ids` string[], required — List of model identifiers related to the job.
      - `model_sample_primary_ids` object, required — Mapping of primary ids used for sampling in each model.
      - `data_integrity_results` DataIntegrityResultResource[], required — Results of the data integrity checks.
        - `model_name` string, required — Name of the model checked for integrity.
        - `is_healthy` boolean, required — Indicator of whether the model data is healthy.
        - `error_message` string, required — Error message if there is an issue with the data integrity.
        - `sampling_rate` number, required — The rate at which data is sampled for integrity checks.
        - `total_rows_compared` integer, required — Total number of rows compared during the integrity check.
        - `total_rows_stale` integer, required — Number of rows that are outdated or no longer relevant.
        - `total_rows_pending` integer, required — Number of rows pending to be updated or processed.
        - `total_rows_missing` integer, required — Number of rows that are expected but missing.
        - `total_rows_incorrect` integer, required — Number of rows that do not match the expected values.
        - `total_rows_orphaned` integer, required — Number of rows that exist without corresponding parent entries. This is likely due to hard deletes in the source
        - `mismatched_partitions` MismatchedPartition[] — The partitions that did not have matching hashes.
          - `source_row_count` integer, required
          - `destination_row_count` integer, required
          - `last_modified_lower_bound_epoch` integer, required
          - `last_modified_upper_bound_epoch` integer, required
      - `log_message` string, required — A message logging the result of the integrity check for each specific model.
  - `message` string, required
  - `has_next` boolean, required — Whether there are more items beyond this page.
  - `next_url` string — Full URL to fetch the next page. Only present when has_next is true.

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `404` — Not Found
- `500` — Internal Server Error

---

[API](https://skmtc.dev/prequel/apis/prequel-data-export.md) · [All operations](https://skmtc.dev/prequel/apis/prequel-data-export/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/prequel/prequel-data-export/revisions/09c662a871f8/schema)