> ## Documentation Index > Fetch the complete documentation index at: https://docs.elementary-data.com/llms.txt > Use this file to discover all available pages before exploring further. # List latest test executions > Lists the most recent execution of every sub-test — a full snapshot of current test results. Not an incremental feed: rows are replaced in place, so re-read the snapshot instead of passing `synced_since`. Executions of disabled tests are omitted unless `disabled=true` is passed, and executions whose test was deleted are never returned. ## OpenAPI ````yaml api-reference/beta/openapi.json get /public/beta/{env_id}/latest-test-executions openapi: 3.1.0 info: description: > The Elementary Public API is a REST interface for programmatically reading Elementary's assets, columns, lineage, tests, and test results for one environment. **Authentication.** Send a bearer token (personal or account token) in the `Authorization` header. The token resolves to an account; results are scoped to the environments that token may view. **Environment scope.** Every resource lives under `/{env_id}`. Call `GET /environments` first to discover the ids you can access. **Pagination.** List endpoints are keyset-paginated: pass `limit` (default 500, max 2000) and follow `next_cursor` until `has_more` is `false`. Cursors are opaque and bound to the filters that produced them — reusing a cursor with different filters returns `400`. **Incremental sync.** Every dataset supports a full scan (default). Assets, columns, and tests also expose two incremental feeds: `synced_since` (upserts) and `deleted_since` (soft-delete tombstones). A test's `synced_at` tracks its definition — new executions do not bump it. Latest test executions and per-test execution history are **not** incremental. Latest executions are a full snapshot replaced in place: re-read it. Execution history is append-only and scoped to one test, filtered by `start_time_from` / `start_time_to` (last 30 days by default). **Lookback limit.** Explicit lower bounds (`synced_since`, `deleted_since`, `start_time_from`) reach back at most 90 days; an older timestamp is treated as 90 days ago rather than rejected. Omitting the filter still returns the full current snapshot. **Rate limiting.** Requests are rate-limited per account; responses carry `RateLimit-*` headers and `429` responses include `Retry-After`. _Beta: the shape may change while we co-design with early adopters._ title: Elementary Public API version: beta servers: - url: https://prod.api.elementary-data.com security: - bearerAuth: [] tags: - description: Discover accessible environments. name: Environments - description: Lineage assets — tables, views, BI assets. name: Assets - description: Columns of assets. name: Columns - description: Asset-to-asset lineage edges. name: Asset lineage - description: Column-level lineage edges. name: Column lineage - description: Test definitions and their configuration. name: Tests - description: Most recent execution of every sub-test. name: Latest test executions - description: Execution history of a single test. name: Test executions - description: Current data health score per asset. name: Asset health scores paths: /public/beta/{env_id}/latest-test-executions: get: tags: - Latest test executions summary: List latest test executions description: >- Lists the most recent execution of every sub-test — a full snapshot of current test results. Not an incremental feed: rows are replaced in place, so re-read the snapshot instead of passing `synced_since`. Executions of disabled tests are omitted unless `disabled=true` is passed, and executions whose test was deleted are never returned. operationId: >- list_latest_test_executions_public_beta__env_id__latest_test_executions_get parameters: - description: Environment identifier that scopes the request. in: path name: env_id required: true schema: description: Environment identifier that scopes the request. title: Env Id type: string - description: Return only executions of these sub-tests. in: query name: sub_test_ids required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: Return only executions of these sub-tests. title: Sub Test Ids - description: Return only executions of these tests. in: query name: test_ids required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: Return only executions of these tests. title: Test Ids - description: Return only executions of tests on these asset ids. in: query name: asset_ids required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: Return only executions of tests on these asset ids. title: Asset Ids - description: Return only executions of tests of these test types. in: query name: test_types required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: Return only executions of tests of these test types. title: Test Types - description: Return only executions of tests of these definition types. in: query name: definition_types required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: Return only executions of tests of these definition types. title: Definition Types - description: >- Return only executions from these source types (e.g. `dbt`, `elementary_cloud`). in: query name: source_types required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: >- Return only executions from these source types (e.g. `dbt`, `elementary_cloud`). title: Source Types - description: >- Return only executions with these statuses, as stored (e.g. `PASS`, `WARN`, `FAIL`, `ERROR`, `SKIPPED`, `NO_DATA`). in: query name: statuses required: false schema: anyOf: - items: type: string maxItems: 1000 type: array - type: 'null' description: >- Return only executions with these statuses, as stored (e.g. `PASS`, `WARN`, `FAIL`, `ERROR`, `SKIPPED`, `NO_DATA`). title: Statuses - description: >- Disabled tests' executions are omitted by default. Pass `true` to return only the disabled ones, `false` for the default (enabled only). in: query name: disabled required: false schema: anyOf: - type: boolean - type: 'null' description: >- Disabled tests' executions are omitted by default. Pass `true` to return only the disabled ones, `false` for the default (enabled only). title: Disabled - description: >- Opaque cursor from a previous response's `next_cursor`. Reuse it only with the identical query parameters that produced it. in: query name: cursor required: false schema: anyOf: - type: string - type: 'null' description: >- Opaque cursor from a previous response's `next_cursor`. Reuse it only with the identical query parameters that produced it. title: Cursor - description: Maximum items to return per page (1-2000). in: query name: limit required: false schema: default: 500 description: Maximum items to return per page (1-2000). maximum: 2000 minimum: 1 title: Limit type: integer - description: >- Sort field for a full scan. Ignored when `synced_since`/`deleted_since` is set (those feeds always order by their own cursor). in: query name: order_by required: false schema: $ref: '#/components/schemas/OrderBy' default: id description: >- Sort field for a full scan. Ignored when `synced_since`/`deleted_since` is set (those feeds always order by their own cursor). - description: Sort direction for `order_by`. in: query name: direction required: false schema: $ref: '#/components/schemas/Direction' default: asc description: Sort direction for `order_by`. responses: '200': content: application/json: schema: $ref: '#/components/schemas/PaginatedResponse_TestExecution_' description: Successful Response '400': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: Invalid cursor or request parameters. '401': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: Authentication is required. '403': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: The token does not have permission to access the resource. '404': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: The requested resource was not found. '422': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: Request validation failed. '429': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: Rate limit exceeded. headers: RateLimit-Limit: description: Maximum requests allowed in the current window. schema: type: integer RateLimit-Remaining: description: Requests remaining in the current window. schema: type: integer RateLimit-Reset: description: Seconds until the current rate-limit window resets. schema: type: integer Retry-After: description: Seconds to wait before retrying. schema: type: integer '500': content: application/json: schema: $ref: '#/components/schemas/ApiErrorResponse' description: An unexpected server error occurred. components: schemas: OrderBy: enum: - id - synced_at title: OrderBy type: string Direction: enum: - asc - desc title: Direction type: string PaginatedResponse_TestExecution_: properties: has_more: default: false description: >- The only signal to continue pagination; a short page may still have more items because permission filtering can trim rows. title: Has More type: boolean items: description: Objects returned in the current page. items: $ref: '#/components/schemas/TestExecution' title: Items type: array next_cursor: anyOf: - type: string - type: 'null' description: >- Opaque cursor for the next page, valid only with identical query parameters. title: Next Cursor required: - items title: PaginatedResponse[TestExecution] type: object ApiErrorResponse: properties: error: $ref: '#/components/schemas/ApiError' description: Structured details about the error. required: - error title: ApiErrorResponse type: object TestExecution: properties: column_name: anyOf: - type: string - type: 'null' description: Column this execution checked, when applicable. title: Column Name description: anyOf: - type: string - type: 'null' description: Description of the test at execution time. title: Description duration_seconds: description: How long the execution took. title: Duration Seconds type: number exception: anyOf: - type: string - type: 'null' description: Error message when the execution errored. title: Exception failure_count: anyOf: - type: integer - type: 'null' description: >- Number of failed rows or detected issues. Null when the execution does not produce a failing-row count (for example volume, freshness, or anomaly cloud tests). title: Failure Count id: description: Identifier of this execution. title: Id type: string quality_dimension: anyOf: - type: string - type: 'null' description: >- Extensible enum. Data-quality dimension the test covers, when classified. examples: - completeness - uniqueness - freshness - validity - accuracy - consistency title: Quality Dimension result_reason: anyOf: - type: string - type: 'null' description: >- Extensible enum. Why the execution produced its status, when Elementary could determine it. examples: - PERMISSIONS_ERROR title: Result Reason start_time: description: When the execution started. format: date-time title: Start Time type: string status: description: >- Extensible enum. Result of the execution. New values may be added over time. examples: - PASS - WARN - FAIL - ERROR - SKIPPED - NO_DATA title: Status type: string sub_test_unique_id: description: >- Stable identifier of the sub-test (a test can explode into several sub-tests, e.g. one per column). Use it to key latest executions. title: Sub Test Unique Id type: string sub_type: description: Sub-test type within the test (e.g. the anomaly type checked). title: Sub Type type: string synced_at: anyOf: - format: date-time type: string - type: 'null' description: When Elementary last synced this execution. title: Synced At test_id: description: ID of the test that produced this execution. title: Test Id type: string required: - id - test_id - sub_test_unique_id - sub_type - status - failure_count - start_time - duration_seconds title: TestExecution type: object ApiError: properties: code: description: Stable code identifying the type of error. title: Code type: string message: description: Human-readable explanation of the error. title: Message type: string required: - code - message title: ApiError type: object securitySchemes: bearerAuth: description: Personal or account token. scheme: bearer type: http ```` This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.