Bulk Create Records

Bulk create records

curl --request POST \
  --url https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "records": [
    {
      "Name": "John Doe",
      "Email": "john@example.com",
      "Priority": "high"
    },
    {
      "Name": "Jane Smith",
      "Email": "jane@example.com",
      "Priority": "low"
    }
  ]
}
'

import requests

url = "https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk"

payload = { "records": [
        {
            "Name": "John Doe",
            "Email": "john@example.com",
            "Priority": "high"
        },
        {
            "Name": "Jane Smith",
            "Email": "jane@example.com",
            "Priority": "low"
        }
    ] }
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    records: [
      {Name: 'John Doe', Email: 'john@example.com', Priority: 'high'},
      {Name: 'Jane Smith', Email: 'jane@example.com', Priority: 'low'}
    ]
  })
};

fetch('https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'records' => [
        [
                'Name' => 'John Doe',
                'Email' => 'john@example.com',
                'Priority' => 'high'
        ],
        [
                'Name' => 'Jane Smith',
                'Email' => 'jane@example.com',
                'Priority' => 'low'
        ]
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk"

	payload := strings.NewReader("{\n  \"records\": [\n    {\n      \"Name\": \"John Doe\",\n      \"Email\": \"john@example.com\",\n      \"Priority\": \"high\"\n    },\n    {\n      \"Name\": \"Jane Smith\",\n      \"Email\": \"jane@example.com\",\n      \"Priority\": \"low\"\n    }\n  ]\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"records\": [\n    {\n      \"Name\": \"John Doe\",\n      \"Email\": \"john@example.com\",\n      \"Priority\": \"high\"\n    },\n    {\n      \"Name\": \"Jane Smith\",\n      \"Email\": \"jane@example.com\",\n      \"Priority\": \"low\"\n    }\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"records\": [\n    {\n      \"Name\": \"John Doe\",\n      \"Email\": \"john@example.com\",\n      \"Priority\": \"high\"\n    },\n    {\n      \"Name\": \"Jane Smith\",\n      \"Email\": \"jane@example.com\",\n      \"Priority\": \"low\"\n    }\n  ]\n}"

response = http.request(request)
puts response.read_body

{
  "success": true,
  "records": [
    {
      "id": "d4b3c2a3-c46b-46a1-a8ec-81b664bb41cb",
      "data": {
        "fwtJyga6dso": "John Doe",
        "k8mNp2xQ9rL": "john@example.com",
        "vB3zXc7Hf2w": "high"
      },
      "fields": {
        "Name": "John Doe",
        "Email": "john@example.com",
        "Priority": "high"
      },
      "createdAt": "2025-11-13T11:59:45.000Z",
      "updatedAt": "2025-11-13T11:59:45.000Z"
    }
  ]
}

POST

bases

{databaseId}

tables

{tableId}

records

bulk

Bulk create records

curl --request POST \
  --url https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "records": [
    {
      "Name": "John Doe",
      "Email": "john@example.com",
      "Priority": "high"
    },
    {
      "Name": "Jane Smith",
      "Email": "jane@example.com",
      "Priority": "low"
    }
  ]
}
'

import requests

url = "https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk"

payload = { "records": [
        {
            "Name": "John Doe",
            "Email": "john@example.com",
            "Priority": "high"
        },
        {
            "Name": "Jane Smith",
            "Email": "jane@example.com",
            "Priority": "low"
        }
    ] }
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.post(url, json=payload, headers=headers)

print(response.text)

const options = {
  method: 'POST',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    records: [
      {Name: 'John Doe', Email: 'john@example.com', Priority: 'high'},
      {Name: 'Jane Smith', Email: 'jane@example.com', Priority: 'low'}
    ]
  })
};

fetch('https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "POST",
  CURLOPT_POSTFIELDS => json_encode([
    'records' => [
        [
                'Name' => 'John Doe',
                'Email' => 'john@example.com',
                'Priority' => 'high'
        ],
        [
                'Name' => 'Jane Smith',
                'Email' => 'jane@example.com',
                'Priority' => 'low'
        ]
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk"

	payload := strings.NewReader("{\n  \"records\": [\n    {\n      \"Name\": \"John Doe\",\n      \"Email\": \"john@example.com\",\n      \"Priority\": \"high\"\n    },\n    {\n      \"Name\": \"Jane Smith\",\n      \"Email\": \"jane@example.com\",\n      \"Priority\": \"low\"\n    }\n  ]\n}")

	req, _ := http.NewRequest("POST", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

HttpResponse<String> response = Unirest.post("https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"records\": [\n    {\n      \"Name\": \"John Doe\",\n      \"Email\": \"john@example.com\",\n      \"Priority\": \"high\"\n    },\n    {\n      \"Name\": \"Jane Smith\",\n      \"Email\": \"jane@example.com\",\n      \"Priority\": \"low\"\n    }\n  ]\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://tables.zite.com/api/v1/bases/{databaseId}/tables/{tableId}/records/bulk")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Post.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"records\": [\n    {\n      \"Name\": \"John Doe\",\n      \"Email\": \"john@example.com\",\n      \"Priority\": \"high\"\n    },\n    {\n      \"Name\": \"Jane Smith\",\n      \"Email\": \"jane@example.com\",\n      \"Priority\": \"low\"\n    }\n  ]\n}"

response = http.request(request)
puts response.read_body

{
  "success": true,
  "records": [
    {
      "id": "d4b3c2a3-c46b-46a1-a8ec-81b664bb41cb",
      "data": {
        "fwtJyga6dso": "John Doe",
        "k8mNp2xQ9rL": "john@example.com",
        "vB3zXc7Hf2w": "high"
      },
      "fields": {
        "Name": "John Doe",
        "Email": "john@example.com",
        "Priority": "high"
      },
      "createdAt": "2025-11-13T11:59:45.000Z",
      "updatedAt": "2025-11-13T11:59:45.000Z"
    }
  ]
}

Creates up to 100 records in one request using either the table ID or table name. Optionally performs an upsert (create or update existing records) by matching on one or more field values.

Use field names or field IDs as keys and field values as data (e.g., "Email": "user@example.com" or "fwtJyga6dso": "user@example.com")

Limits

Parameter	Type	Required	Min	Max
`records`	array	Yes	1	100
`matchOn`	array	No	1	20

Any id key included in a record is ignored — the database generates the record ID.

Upsert with `matchOn`

Pass matchOn with a list of field IDs to upsert instead of always creating. For each incoming record, existing records are matched on all of the listed fields:

If a match is found, that record is updated with the provided values.
If no match is found, a new record is created.

{
  "records": [
    { "Email": "john@example.com", "Name": "John Doe", "Priority": "high" },
    { "Email": "jane@example.com", "Name": "Jane Smith", "Priority": "low" }
  ],
  "matchOn": ["k8mNp2xQ9rL"]
}

Unlike the keys inside each record, matchOn accepts field IDs only — field names are rejected. A record’s field IDs are the keys of the data object returned by any record endpoint (for example, List Records).

When matchOn is provided, the response status is 200 (records may have been updated) rather than 201.

Authorizations

Authorization

string

header

required

Enter your Zite API key. Format: Bearer <api_key>

Path Parameters

databaseId

string

required

The unique identifier of the database

tableId

string

required

The unique identifier of the table. You can also use the table name instead of the ID.

Body

application/json

records

object[]

required

Records to create (1-100). Each item is an object with field names or field IDs as keys and their corresponding values. Any id key is ignored — the database generates the record ID.

Required array length: 1 - 100 elements

Example:

[
  {
    "Name": "John Doe",
    "Email": "john@example.com",
    "Priority": "high"
  },
  {
    "Name": "Jane Smith",
    "Email": "jane@example.com",
    "Priority": "low"
  }
]

matchOn

string[]

Optional list of field IDs to upsert on (1-20 keys). Must be field IDs, not field names (unlike the keys inside each record). When provided, each incoming record is matched against existing records on all listed fields: a match updates that record, otherwise a new record is created. Omit to always create new records.

Required array length: 1 - 20 elements

Example:

["k8mNp2xQ9rL"]

Response

Records created successfully. When matchOn is provided (upsert), the status is 200 instead of 201.

success

boolean

required

Whether the bulk operation succeeded

records

object[]

required

The created (or upserted) records

Show child attributes

Last modified on July 25, 2026

Create Record Get Record by ID

Getting Started

Configure Database

Manage Data

Access & Sharing

Automations

Tips

Zite MCP

API Reference

Limits

Upsert with `matchOn`

Authorizations

Path Parameters

Body

Response

​Limits

​Upsert with matchOn

Authorizations

Path Parameters

Body

Response

Limits

Upsert with `matchOn`