LanceDB · Example Payload

Lancedb Merge Insert Example

Vector DatabaseMulti-ModalLance FormatLakehouseRAGAgent MemoryOpen-SourceEmbeddingsFull-Text SearchHybrid SearchColumnar StorageArrowAI Infrastructure

Lancedb Merge Insert Example is an example object payload from LanceDB, with 5 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

$commentonwhenMatchedUpdateAllwhenNotMatchedInsertAllrecords

Example Payload

Raw ↑ 
{
  "$comment": "POST /v1/table/{id}/merge_insert — upsert (insert-or-update) records keyed on id",
  "on": ["id"],
  "whenMatchedUpdateAll": true,
  "whenNotMatchedInsertAll": true,
  "records": [
    { "id": "doc-1001", "text": "LanceDB ships native vector + FTS", "category": "marketing", "embedding": [0.11, -0.42, "..."] },
    { "id": "doc-1002", "text": "Lance v2 format adds zone maps", "category": "engineering", "embedding": [0.07, 0.31, "..."] }
  ]
}

Work with this as data

Every example here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for examples

4 MCP tools reach this
  • find_examplesBrowse and filter every example in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This example 
curl "https://apis.io/api/v1/examples/lancedb-merge-insert-example"
All examples 
curl "https://apis.io/api/v1/examples?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.