Update or create rows by key
curl --request POST \
--url https://api.databar.ai/v1/table/{table_uuid}/rows/upsert \
--header 'Content-Type: application/json' \
--header 'x-apikey: <x-apikey>' \
--data '
{
"return_rows": false,
"rows": [
{
"fields": {
"company_name": "Acme",
"first_name": "Ivan"
},
"key": {
"email": "ivan@example.com"
}
},
{
"fields": {
"first_name": "New Person",
"title": "Engineer"
},
"key": {
"email": "new@example.com"
}
}
]
}
'import requests
url = "https://api.databar.ai/v1/table/{table_uuid}/rows/upsert"
payload = {
"return_rows": False,
"rows": [
{
"fields": {
"company_name": "Acme",
"first_name": "Ivan"
},
"key": { "email": "ivan@example.com" }
},
{
"fields": {
"first_name": "New Person",
"title": "Engineer"
},
"key": { "email": "new@example.com" }
}
]
}
headers = {
"x-apikey": "<x-apikey>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'x-apikey': '<x-apikey>', 'Content-Type': 'application/json'},
body: JSON.stringify({
return_rows: false,
rows: [
{
fields: {company_name: 'Acme', first_name: 'Ivan'},
key: {email: 'ivan@example.com'}
},
{
fields: {first_name: 'New Person', title: 'Engineer'},
key: {email: 'new@example.com'}
}
]
})
};
fetch('https://api.databar.ai/v1/table/{table_uuid}/rows/upsert', 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://api.databar.ai/v1/table/{table_uuid}/rows/upsert",
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([
'return_rows' => false,
'rows' => [
[
'fields' => [
'company_name' => 'Acme',
'first_name' => 'Ivan'
],
'key' => [
'email' => 'ivan@example.com'
]
],
[
'fields' => [
'first_name' => 'New Person',
'title' => 'Engineer'
],
'key' => [
'email' => 'new@example.com'
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"x-apikey: <x-apikey>"
],
]);
$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://api.databar.ai/v1/table/{table_uuid}/rows/upsert"
payload := strings.NewReader("{\n \"return_rows\": false,\n \"rows\": [\n {\n \"fields\": {\n \"company_name\": \"Acme\",\n \"first_name\": \"Ivan\"\n },\n \"key\": {\n \"email\": \"ivan@example.com\"\n }\n },\n {\n \"fields\": {\n \"first_name\": \"New Person\",\n \"title\": \"Engineer\"\n },\n \"key\": {\n \"email\": \"new@example.com\"\n }\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("x-apikey", "<x-apikey>")
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://api.databar.ai/v1/table/{table_uuid}/rows/upsert")
.header("x-apikey", "<x-apikey>")
.header("Content-Type", "application/json")
.body("{\n \"return_rows\": false,\n \"rows\": [\n {\n \"fields\": {\n \"company_name\": \"Acme\",\n \"first_name\": \"Ivan\"\n },\n \"key\": {\n \"email\": \"ivan@example.com\"\n }\n },\n {\n \"fields\": {\n \"first_name\": \"New Person\",\n \"title\": \"Engineer\"\n },\n \"key\": {\n \"email\": \"new@example.com\"\n }\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.databar.ai/v1/table/{table_uuid}/rows/upsert")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["x-apikey"] = '<x-apikey>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"return_rows\": false,\n \"rows\": [\n {\n \"fields\": {\n \"company_name\": \"Acme\",\n \"first_name\": \"Ivan\"\n },\n \"key\": {\n \"email\": \"ivan@example.com\"\n }\n },\n {\n \"fields\": {\n \"first_name\": \"New Person\",\n \"title\": \"Engineer\"\n },\n \"key\": {\n \"email\": \"new@example.com\"\n }\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"results": [
{
"action": "updated",
"id": "91f0e833-5dfc-4f63-be96-e3a28925190f"
},
{
"action": "created",
"id": "a1b2c3d4-0000-0000-0000-000000000000",
"index": 1
}
]
}{
"error": "<string>",
"max_size": 123,
"columns": [
"<string>"
],
"detail": "<string>"
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>"
}
]
}Rows
Upsert rows by key values
For each row, match on a single key column:
- 0 matches → a new row is created (
action: created). - 1 match → the existing row is updated (
action: updated). - >1 matches → returns an
AMBIGUOUS_MATCHerror for that row.
The key dict must contain exactly one entry {column_name: value}.
POST
/
v1
/
table
/
{table_uuid}
/
rows
/
upsert
Update or create rows by key
curl --request POST \
--url https://api.databar.ai/v1/table/{table_uuid}/rows/upsert \
--header 'Content-Type: application/json' \
--header 'x-apikey: <x-apikey>' \
--data '
{
"return_rows": false,
"rows": [
{
"fields": {
"company_name": "Acme",
"first_name": "Ivan"
},
"key": {
"email": "ivan@example.com"
}
},
{
"fields": {
"first_name": "New Person",
"title": "Engineer"
},
"key": {
"email": "new@example.com"
}
}
]
}
'import requests
url = "https://api.databar.ai/v1/table/{table_uuid}/rows/upsert"
payload = {
"return_rows": False,
"rows": [
{
"fields": {
"company_name": "Acme",
"first_name": "Ivan"
},
"key": { "email": "ivan@example.com" }
},
{
"fields": {
"first_name": "New Person",
"title": "Engineer"
},
"key": { "email": "new@example.com" }
}
]
}
headers = {
"x-apikey": "<x-apikey>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'x-apikey': '<x-apikey>', 'Content-Type': 'application/json'},
body: JSON.stringify({
return_rows: false,
rows: [
{
fields: {company_name: 'Acme', first_name: 'Ivan'},
key: {email: 'ivan@example.com'}
},
{
fields: {first_name: 'New Person', title: 'Engineer'},
key: {email: 'new@example.com'}
}
]
})
};
fetch('https://api.databar.ai/v1/table/{table_uuid}/rows/upsert', 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://api.databar.ai/v1/table/{table_uuid}/rows/upsert",
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([
'return_rows' => false,
'rows' => [
[
'fields' => [
'company_name' => 'Acme',
'first_name' => 'Ivan'
],
'key' => [
'email' => 'ivan@example.com'
]
],
[
'fields' => [
'first_name' => 'New Person',
'title' => 'Engineer'
],
'key' => [
'email' => 'new@example.com'
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"x-apikey: <x-apikey>"
],
]);
$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://api.databar.ai/v1/table/{table_uuid}/rows/upsert"
payload := strings.NewReader("{\n \"return_rows\": false,\n \"rows\": [\n {\n \"fields\": {\n \"company_name\": \"Acme\",\n \"first_name\": \"Ivan\"\n },\n \"key\": {\n \"email\": \"ivan@example.com\"\n }\n },\n {\n \"fields\": {\n \"first_name\": \"New Person\",\n \"title\": \"Engineer\"\n },\n \"key\": {\n \"email\": \"new@example.com\"\n }\n }\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("x-apikey", "<x-apikey>")
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://api.databar.ai/v1/table/{table_uuid}/rows/upsert")
.header("x-apikey", "<x-apikey>")
.header("Content-Type", "application/json")
.body("{\n \"return_rows\": false,\n \"rows\": [\n {\n \"fields\": {\n \"company_name\": \"Acme\",\n \"first_name\": \"Ivan\"\n },\n \"key\": {\n \"email\": \"ivan@example.com\"\n }\n },\n {\n \"fields\": {\n \"first_name\": \"New Person\",\n \"title\": \"Engineer\"\n },\n \"key\": {\n \"email\": \"new@example.com\"\n }\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.databar.ai/v1/table/{table_uuid}/rows/upsert")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["x-apikey"] = '<x-apikey>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"return_rows\": false,\n \"rows\": [\n {\n \"fields\": {\n \"company_name\": \"Acme\",\n \"first_name\": \"Ivan\"\n },\n \"key\": {\n \"email\": \"ivan@example.com\"\n }\n },\n {\n \"fields\": {\n \"first_name\": \"New Person\",\n \"title\": \"Engineer\"\n },\n \"key\": {\n \"email\": \"new@example.com\"\n }\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"results": [
{
"action": "updated",
"id": "91f0e833-5dfc-4f63-be96-e3a28925190f"
},
{
"action": "created",
"id": "a1b2c3d4-0000-0000-0000-000000000000",
"index": 1
}
]
}{
"error": "<string>",
"max_size": 123,
"columns": [
"<string>"
],
"detail": "<string>"
}{
"detail": [
{
"loc": [
"<string>"
],
"msg": "<string>",
"type": "<string>"
}
]
}Upsert = update or create. Rows are matched by the key columns you specify. If a matching row exists, it is updated; otherwise a new row is inserted.
Headers
API Key for authentication
Path Parameters
The UUID of the table
Body
application/json
Response
Successful Response
Show child attributes
Show child attributes
⌘I