---
title: "Get SQL charts as code"
method: GET
path: "/api/v1/projects/{projectUuid}/code/sqlCharts"
tags: ["Projects"]
---

# Get SQL charts as code

`GET /api/v1/projects/{projectUuid}/code/sqlCharts`

Gets SQL charts in code representation

## Path parameters

- `projectUuid` string, required

## Query parameters

- `ids` string[]
- `offset` number, double

## Response `200`

Success

- ApiSqlChartAsCodeListResponse
  - `results` object, required
    - `offset` number, double, required
    - `total` number, double, required
    - `spaces` SpaceAsCode[], required
      - `access` SpaceAsCodeAccess
        - `groups` SpaceAsCodeGroupAccess[], required
          - `role` 'viewer' | 'editor' | 'admin', required
          - `name` string, required — Exact, case-sensitive organization group name.
        - `users` SpaceAsCodeUserAccess[], required
          - `role` 'viewer' | 'editor' | 'admin', required
          - `email` string, required — Primary email of a human organization member.
        - `projectMemberAccessRole` 'viewer' | 'editor' | 'admin', required
        - `inheritParentPermissions` boolean, required
      - `slug` string, required — Full portable hierarchy path used for identity and cross-referencing.
      - `spaceName` string, required — The original human-readable space name (preserves emoji, casing, etc.)
      - `version` 1 — Optional only for backwards-compatible metadata-only files.
      - `contentType` 'space', required
    - `missingIds` string[], required
    - `sqlCharts` SqlChartAsCode[], required
      - `name` string, required
      - `description` string, nullable, required
      - `slug` string, required
      - `limit` number, double, required
      - `config` union, required
        - object
          - `type` union, required
            - 'vertical_bar'
            - 'line'
          - `metadata` object, required
            - `version` number, double, required
          - `display` CartesianChartDisplay
            - `stack` union
              - …
            - `legend` object
              - …
            - `series` object
            - `yAxis` object[]
              - …
            - `xAxis` object
              - …
          - `fieldConfig` PivotChartLayout
            - `stack` union
              - …
            - `sortBy` VizSortBy[]
              - …
            - `groupBy` object[]
              - …
            - `y` object[], required
              - …
            - `x` object
              - …
        - object
          - `type` 'pie', required
          - `metadata` object, required
            - `version` number, double, required
          - `display` VizPieChartDisplay
            - `isDonut` boolean
          - `fieldConfig` PivotChartLayout
            - `stack` union
              - …
            - `sortBy` VizSortBy[]
              - …
            - `groupBy` object[]
              - …
            - `y` object[], required
              - …
            - `x` object
              - …
        - object
          - `type` 'table', required
          - `metadata` object, required
            - `version` number, double, required
          - `display` VizTableDisplay
          - `columns` VizColumnsConfig, required
      - `sql` string, required
      - `chartKind` 'line' | 'horizontal_bar' | 'vertical_bar' | 'scatter' | 'area' | 'mixed' | 'pie' | 'table' | 'big_number' | 'funnel' | 'custom' | 'treemap' | 'gauge' | 'map' | 'sankey' | 'data_app_viz', required
      - `downloadedAt` string, date-time
      - `updatedAt` string, date-time
      - `spaceSlug` string, required
      - `contentType` 'sql_chart'
      - `version` number, double, required
  - `status` 'ok', required

## Other responses

- `default` — Error

---

[API](https://skmtc.net/lightdash/apis/lightdash-api.md) · [All operations](https://skmtc.net/lightdash/apis/lightdash-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/lightdash/lightdash-api/versions/40c933755c9a/schema)