---
title: "Execute a DML query on external or lakehouse schemas"
method: POST
path: "/v1/dataapps/data/executeDML"
tags: ["Data Apps"]
---

# Execute a DML query on external or lakehouse schemas

`POST /v1/dataapps/data/executeDML`

## Request

- Base URL: `https://api.tetrascience.com`
- URL: `https://api.tetrascience.com/v1/dataapps/data/executeDML`
- Auth: API key in header `ts-auth-token` and API key in header `x-org-slug`

## Request body

- ExecuteDMLRequest
  - `appId` string, required
  - `statement` string, required
  - `parameters` object[], required
    - `name` string, required
    - `value` unknown, required
    - `type` string, required

## Response `200`

OK

- DMLResult
  - `chunk` DMLResultChunk, required
    - `statementId` string, required
    - `chunkIndex` integer, required
    - `nextChunkIndex` integer, nullable, required
    - `data` unknown[], required
      - unknown
    - `rowCount` integer, required
  - `resultSchema` DMLResultSchema, required
    - `columnCount` integer, required
    - `columns` DMLResultSchemaColumn[], required
      - `name` string, required
      - `position` integer, required
      - `type` string, required
  - `statementId` string, required
  - `totalChunks` integer, required
  - `totalRowCount` integer, required

## Other responses

- `400`: Bad Request
- `401`: Unauthorized
- `500`: Internal Server Error

---

[API](https://skmtc.dev/tetrascience/apis/data-ai-workspace-api.md) - [All operations](https://skmtc.dev/tetrascience/apis/data-ai-workspace-api/llms.txt) - [OpenAPI document](https://skmtc.dev/tetrascience/apis/data-ai-workspace-api/revisions/99f3b2ac0b83?raw)