---
title: "Handle Sql Transform Commit"
method: POST
path: "/sql-transforms/commit"
tags: ["Transforms (SQL)"]
---

# Handle Sql Transform Commit

`POST /sql-transforms/commit`

## Request

- Base URL: `https://api.akkio.com` (the document declares no server; this is the origin it was published from)
- URL: `https://api.akkio.com/sql-transforms/commit`
- Auth: none declared

Fully commit a transform.

## Request body

- SQLTransformCommitRequest
  - `flow_id` string, required: The ID of the flow for this transform.
  - `transform_plan_ids` integer[]: A list of transform plans ids to formally commit. This performs these transform plans in sequence and hard-bakes the result, pointing the flow to the result instead.

## Response `200`

Successful Response

- AsyncJobRecord: Do NOT access this table directly.
  - `id` integer, nullable: ID of this object.
  - `created_at` string, date-time, nullable: datetime object representing when this object was created.
  - `updated_at` string, date-time, nullable: datetime object representing when this object was updated.
  - `deleted_at` string, date-time, nullable: datetime object representing when this object was deleted.
  - `status` 'RUNNING' | 'COMPLETED' | 'FAILED'
  - `endpoint` string: Endpoint spawning async job
  - `request` union: request sent to endpoint
    - object
    - unknown[]
      - unknown
  - `sync_response` union: sync response
    - object
    - unknown[]
      - unknown
  - `error` string, nullable: error message
  - `response` unknown

## Other responses

- `422`: Validation Error

---

[API](https://skmtc.dev/akkio/apis/akkio-api.md) - [All operations](https://skmtc.dev/akkio/apis/akkio-api/llms.txt) - [OpenAPI document](https://skmtc.dev/akkio/apis/akkio-api/revisions/c477deff6271?raw)