---
title: "Merge Insert"
method: POST
path: "/v1/table/{name}/merge_insert/"
tags: ["Data"]
---

# Merge Insert

`POST /v1/table/{name}/merge_insert/`

Create a "merge insert" operation This operation can add rows, update rows, and remove rows all in a single transaction. See python method `lancedb.table.Table.merge_insert` for examples.

## Path parameters

- `name` string, required

## Query parameters

- `on` string, required
- `when_matched_update_all` boolean
- `when_matched_update_all_filt` string
- `when_not_matched_insert_all` boolean
- `when_not_matched_by_source_delete` boolean
- `when_not_matched_by_source_delete_filt` string

## Response `200`

Merge Insert successful

## Other responses

- `400` — Invalid request
- `401` — Unauthorized
- `404` — Not found

---

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