---
title: "Insert records into a table"
method: POST
path: "/v1/table/{id}/insert"
tags: ["Table", "Data"]
---

# Insert records into a table

`POST /v1/table/{id}/insert`

Insert new records into table `id`.

For tables that have been declared but not yet created on storage
(is_only_declared=true), this operation will create the table with
the provided data.

REST NAMESPACE ONLY
REST namespace uses Arrow IPC stream as the request body.
It passes in the `InsertIntoTableRequest` information in the following way:
- `id`: pass through path parameter of the same name
- `mode`: pass through query parameter of the same name

## Path parameters

- `id` string, required

## Query parameters

- `delimiter` string
- `branch` string
- `mode` string

## Response `200`

Result of inserting records into a table

- InsertIntoTableResponse — Response from inserting records into a table
  - `context` unknown
  - `transaction_id` string — Optional transaction identifier
  - `num_inserted_rows` integer — Number of rows inserted
  - `version` integer — The commit version associated with the operation

## Other responses

- `400` — Indicates a bad request error. It could be caused by an unexpected request body format or other forms of request validation failure, such as invalid json. Usually serves application/json content, although in some cases simple text/plain content might be returned by the server's middleware.
- `401` — Unauthorized. The request lacks valid authentication credentials for the operation.
- `403` — Forbidden. Authenticated user does not have the necessary permissions.
- `404` — A server-side problem that means can not find the specified resource.
- `503` — The service is not ready to handle the request. The client should wait and retry. The service may additionally send a Retry-After header to indicate when to retry.
- `5XX` — A server-side problem that might not be addressable from the client side. Used for server 5xx errors without more specific documentation in individual routes.

---

[API](https://skmtc.net/lance-format/apis/lance-namespace-specification.md) · [All operations](https://skmtc.net/lance-format/apis/lance-namespace-specification/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/lance-format/lance-namespace-specification/versions/f09656f7f568/schema)