Insert rows into a table of a site's database
Inserts 1 to 100 rows, all or none. The sites gateway checks every row against the site’s schema, sets the four system columns, with created_by the admin’s user id, and answers the rows it inserted. A row it refuses, because a column is not in the table, a value has the wrong type, a row is too big or the body names a system column, refuses the whole insert and nothing is written.
An insert is not idempotent: sending it again inserts the rows again. A 502 or 504 does not say the rows were not written, because the sites gateway may have applied the insert before the call failed, so read the table before you send it again.
A row that nests more than 95 levels of objects and arrays is refused with 422, below the 100 levels a request body is parsed to. A row the site wrote itself is answered whole however deep its values nest.
Needs member_site_data.create and member_site_data.view, because the answer is the rows whole, with the values the gateway filled.
curl --request POST \
--url https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"rows": [
{
"title": "Hello"
},
{
"title": "Welcome"
}
]
}
'import requests
url = "https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}"
payload = { "rows": [{ "title": "Hello" }, { "title": "Welcome" }] }
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({rows: [{title: 'Hello'}, {title: 'Welcome'}]})
};
fetch('https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}', 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.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}",
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([
'rows' => [
[
'title' => 'Hello'
],
[
'title' => 'Welcome'
]
]
]),
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://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}"
payload := strings.NewReader("{\n \"rows\": [\n {\n \"title\": \"Hello\"\n },\n {\n \"title\": \"Welcome\"\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://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"rows\": [\n {\n \"title\": \"Hello\"\n },\n {\n \"title\": \"Welcome\"\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}")
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 \"rows\": [\n {\n \"title\": \"Hello\"\n },\n {\n \"title\": \"Welcome\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"rows": [
{
"id": "0199537f-0000-7000-8000-0000000000a1",
"title": "Hello",
"created_by": "42",
"created_at": "2026-11-05T10:00:00.000Z",
"updated_at": "2026-11-05T10:00:00.000Z"
},
{
"id": "0199537f-0000-7000-8000-0000000000a2",
"title": "Welcome",
"created_by": "42",
"created_at": "2026-11-05T10:00:00.000Z",
"updated_at": "2026-11-05T10:00:00.000Z"
}
],
"status": 201,
"meta": {
"request_uuid": "3b8f1d27-6c4e-4a91-8e5d-2f7c9a1b0e64",
"timestamp": "2026-11-05T10:05:00Z"
}
}{}{}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}Authorizations
Path Parameters
Body
The rows to insert. Any other field is refused.
curl --request POST \
--url https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table} \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"rows": [
{
"title": "Hello"
},
{
"title": "Welcome"
}
]
}
'import requests
url = "https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}"
payload = { "rows": [{ "title": "Hello" }, { "title": "Welcome" }] }
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({rows: [{title: 'Hello'}, {title: 'Welcome'}]})
};
fetch('https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}', 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.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}",
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([
'rows' => [
[
'title' => 'Hello'
],
[
'title' => 'Welcome'
]
]
]),
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://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}"
payload := strings.NewReader("{\n \"rows\": [\n {\n \"title\": \"Hello\"\n },\n {\n \"title\": \"Welcome\"\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://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}")
.header("Authorization", "Bearer <token>")
.header("Content-Type", "application/json")
.body("{\n \"rows\": [\n {\n \"title\": \"Hello\"\n },\n {\n \"title\": \"Welcome\"\n }\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.fluid.app/api/company/v2026-10/member-sites/{id}/data/{table}")
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 \"rows\": [\n {\n \"title\": \"Hello\"\n },\n {\n \"title\": \"Welcome\"\n }\n ]\n}"
response = http.request(request)
puts response.read_body{
"rows": [
{
"id": "0199537f-0000-7000-8000-0000000000a1",
"title": "Hello",
"created_by": "42",
"created_at": "2026-11-05T10:00:00.000Z",
"updated_at": "2026-11-05T10:00:00.000Z"
},
{
"id": "0199537f-0000-7000-8000-0000000000a2",
"title": "Welcome",
"created_by": "42",
"created_at": "2026-11-05T10:00:00.000Z",
"updated_at": "2026-11-05T10:00:00.000Z"
}
],
"status": 201,
"meta": {
"request_uuid": "3b8f1d27-6c4e-4a91-8e5d-2f7c9a1b0e64",
"timestamp": "2026-11-05T10:05:00Z"
}
}{}{}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}{
"error": {
"message": "<string>",
"details": {}
},
"status": 123,
"meta": {
"request_uuid": "<string>",
"timestamp": "2023-11-07T05:31:56Z"
}
}