Skip to content
Utilerio
All endpoints

Table Merge

POST/api/v1/tools/table-merge

Stack two spreadsheets into one, or join them on a shared key column like a SQL join.

Authentication

Requires an API key in the X-API-Key header.

Try it

POST/api/v1/tools/table-merge

Parameters

modestringoptional

stack (default) concatenates rows; join merges on a key.

stackjoin
tableAstringrequired

First table as an array of row objects.

tableBstringrequired

Second table as an array of row objects.

leftKeystringoptional

Join key column in tableA. Default first column.

rightKeystringoptional

Join key column in tableB. Default first column.

joinTypestringoptional

Join type when mode is join. Default inner.

innerleft

Request body

{
  "mode": "join",
  "tableA": [
    {
      "id": 1,
      "name": "Ada"
    }
  ],
  "tableB": [
    {
      "id": 1,
      "city": "London"
    }
  ],
  "leftKey": "id",
  "rightKey": "id",
  "joinType": "inner"
}

Response codes

  • 200Success.
  • 400Invalid request — check your body or parameters.
  • 401Missing or invalid API key.
  • 403The API key is not scoped to this endpoint.
  • 429Rate limit exceeded — retry after a short wait.

Language

cURL

Request

curl -X POST https://utilerio.com/api/v1/tools/table-merge \
  -H "X-API-Key: YOUR_KEY" \
  -H "Content-Type: application/json" \
  -d '{"mode":"join","tableA":[{"id":1,"name":"Ada"}],"tableB":[{"id":1,"city":"London"}],"leftKey":"id","rightKey":"id","joinType":"inner"}'

Response

{ "columns": ["id", "name", "city"], "rows": [{ "id": 1, "name": "Ada", "city": "London" }] }