---
title: "GET /api/ee/dependencies/graph/broken"
method: GET
path: "/api/ee/dependencies/graph/broken"
tags: ["/api/ee/dependencies"]
---

# GET /api/ee/dependencies/graph/broken

`GET /api/ee/dependencies/graph/broken`

Returns a list of all items with broken queries.

   Accepts optional parameters for filtering:
   - `types`: List of entity types to include (e.g., `[:card :transform :snippet :dashboard]`)
   - `card_types`: List of card types to include when filtering cards (e.g., `[:question :model :metric]`)
   - `query`: Search string to filter by name or location
   - `archived`: Controls whether archived entities are included
   - `include_personal_collections`: Controls whether items in personal collections are included (default: false)
   - `sort_column`: Sort column - `:name`, `:location`, or `:dependents-count` (default: `:name`)
   - `sort_direction`: Sort direction - `:asc` or `:desc` (default: `:asc`)
   - `offset`: Default 0
   - `limit`: Default 50

   Returns a map with:
   - `data`: List of broken items, each with `:id`, `:type`, `:data`, and `:error`s fields
   - `total`: Total count of matched items
   - `offset`: Applied offset
   - `limit`: Applied limit

## Query parameters

- `types` union
  - 'transform' | 'table' | 'snippet' | 'dashboard' | 'sandbox' | 'measure' | 'card' | 'document' | 'segment'
  - MetabaseEnterpriseDependenciesDependencyTypesDependencyTypes[]
- `card_types` union
  - 'question' | 'metric' | 'model'
  - string[]
- `query` string
- `archived` boolean
- `include_personal_collections` boolean
- `sort_column` 'name' | 'location' | 'dependents-count'
- `sort_direction` 'desc' | 'asc'

## Response `2XX`

Successful response

- object
  - `data` MetabaseEnterpriseDependenciesApiEntity[], required
    - union
      - MetabaseEnterpriseDependenciesApiTableEntity
        - `data` object, required
          - `db` unknown
          - `db_id` unknown
          - `description` unknown
          - `display_name` unknown
          - `fields` unknown
          - `name` unknown
          - `schema` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'table', required
      - MetabaseEnterpriseDependenciesApiCardEntity
        - `data` object, required
          - `collection` unknown
          - `collection_id` unknown
          - `created_at` unknown
          - `creator` unknown
          - `creator_id` unknown
          - `dashboard` unknown
          - `dashboard_id` unknown
          - `database_id` unknown
          - `description` unknown
          - `display` unknown
          - `document` unknown
          - `document_id` unknown
          - `last-edit-info` unknown
          - `name` unknown
          - `query_type` unknown
          - `result_metadata` unknown
          - `type` unknown
          - `view_count` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'card', required
      - MetabaseEnterpriseDependenciesApiSnippetEntity
        - `data` object, required
          - `collection` unknown
          - `collection_id` unknown
          - `created_at` unknown
          - `creator` unknown
          - `creator_id` unknown
          - `description` unknown
          - `name` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'snippet', required
      - MetabaseEnterpriseDependenciesApiTransformEntity
        - `data` object, required
          - `creator` unknown
          - `description` unknown
          - `last_run` unknown
          - `name` unknown
          - `table` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'transform', required
      - MetabaseEnterpriseDependenciesApiDashboardEntity
        - `data` object, required
          - `collection` unknown
          - `collection_id` unknown
          - `created_at` unknown
          - `creator` unknown
          - `creator_id` unknown
          - `description` unknown
          - `last-edit-info` unknown
          - `moderation_reviews` unknown
          - `name` unknown
          - `view_count` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'dashboard', required
      - MetabaseEnterpriseDependenciesApiDocumentEntity
        - `data` object, required
          - `collection` unknown
          - `collection_id` unknown
          - `created_at` unknown
          - `creator` unknown
          - `description` unknown
          - `name` unknown
          - `view_count` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'document', required
      - MetabaseEnterpriseDependenciesApiSandboxEntity
        - `data` object, required
          - `table` unknown
          - `table_id` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'sandbox', required
      - MetabaseEnterpriseDependenciesApiSegmentEntity
        - `data` object, required
          - `collection` unknown
          - `collection_id` unknown
          - `created_at` unknown
          - `creator` unknown
          - `creator_id` unknown
          - `dashboard` unknown
          - `dashboard_id` unknown
          - `database_id` unknown
          - `description` unknown
          - `display` unknown
          - `document` unknown
          - `document_id` unknown
          - `last-edit-info` unknown
          - `name` unknown
          - `query_type` unknown
          - `result_metadata` unknown
          - `type` unknown
          - `view_count` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'segment', required
      - MetabaseEnterpriseDependenciesApiMeasureEntity
        - `data` object, required
          - `created_at` unknown
          - `creator` unknown
          - `creator_id` unknown
          - `description` unknown
          - `name` unknown
          - `table` unknown
          - `table_id` unknown
        - `dependents_count` MetabaseEnterpriseDependenciesApiUsages, required
        - `errors` MetabaseLibSchemaValidateError[]
          - union
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
            - object
              - …
        - `id` integer, required
        - `type` 'measure', required
  - `limit` integer, required — value must be an integer greater than zero.
  - `offset` integer, required
  - `total` integer, required

## Other responses

- `4XX` — Client error response
- `5XX` — Server error response

## Changes

- **2026-01-20** `bd1deee7eae2` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/metabase/apis/metabase-api/changes/api/ee/dependencies/graph/broken/get.md)

---

[API](https://skmtc.dev/metabase/apis/metabase-api.md) · [All operations](https://skmtc.dev/metabase/apis/metabase-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/metabase/metabase-api/revisions/bd1deee7eae2/schema)