Create table rows

curl --request POST \
  --url https://api.getoneprofile.ai/tables/{table_id}/rows/ \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "after_record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "before_record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "count": 1
}
'

import requests

url = "https://api.getoneprofile.ai/tables/{table_id}/rows/"

payload = {
    "after_record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "before_record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "count": 1
}
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({
    after_record_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
    before_record_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
    count: 1
  })
};

fetch('https://api.getoneprofile.ai/tables/{table_id}/rows/', 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.getoneprofile.ai/tables/{table_id}/rows/",
  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([
    'after_record_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
    'before_record_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
    'count' => 1
  ]),
  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.getoneprofile.ai/tables/{table_id}/rows/"

	payload := strings.NewReader("{\n  \"after_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"before_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"count\": 1\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.getoneprofile.ai/tables/{table_id}/rows/")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"after_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"before_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"count\": 1\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.getoneprofile.ai/tables/{table_id}/rows/")

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  \"after_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"before_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"count\": 1\n}"

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

{
  "count": 123,
  "rows": [
    {
      "cells": {},
      "created_at": "2023-11-07T05:31:56Z",
      "record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
    }
  ]
}

{
  "detail": "<string>"
}

{
  "detail": "<string>"
}

{
  "detail": "<string>"
}

{
  "detail": "<string>",
  "issues": [
    {
      "input": "<string>",
      "loc": [
        "<string>"
      ],
      "msg": "<string>",
      "type": "<string>"
    }
  ]
}

{
  "detail": "<string>"
}

{
  "detail": "<string>"
}

{
  "detail": "<string>"
}

table-rows

Create table rows

Append up to 1000 empty rows to the table (one by default) and request a SINGLE row-added recompute run scoped to all of them — the row cap is enforced atomically over the whole batch, so the append is all-or-nothing. Passing after_record_id or before_record_id instead inserts exactly one row directly below or above that row, touching no other row’s position. The run appears on the next active-runs poll; the response never carries a run ID, and a table with no formula columns discards the request at plan time.

POST

tables

{table_id}

rows

Create table rows

curl --request POST \
  --url https://api.getoneprofile.ai/tables/{table_id}/rows/ \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "after_record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "before_record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
  "count": 1
}
'

import requests

url = "https://api.getoneprofile.ai/tables/{table_id}/rows/"

payload = {
    "after_record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "before_record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
    "count": 1
}
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({
    after_record_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
    before_record_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
    count: 1
  })
};

fetch('https://api.getoneprofile.ai/tables/{table_id}/rows/', 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.getoneprofile.ai/tables/{table_id}/rows/",
  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([
    'after_record_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
    'before_record_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
    'count' => 1
  ]),
  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.getoneprofile.ai/tables/{table_id}/rows/"

	payload := strings.NewReader("{\n  \"after_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"before_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"count\": 1\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.getoneprofile.ai/tables/{table_id}/rows/")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"after_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"before_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"count\": 1\n}")
  .asString();

require 'uri'
require 'net/http'

url = URI("https://api.getoneprofile.ai/tables/{table_id}/rows/")

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  \"after_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"before_record_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n  \"count\": 1\n}"

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

{
  "count": 123,
  "rows": [
    {
      "cells": {},
      "created_at": "2023-11-07T05:31:56Z",
      "record_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a"
    }
  ]
}

{
  "detail": "<string>"
}

{
  "detail": "<string>"
}

{
  "detail": "<string>"
}

{
  "detail": "<string>",
  "issues": [
    {
      "input": "<string>",
      "loc": [
        "<string>"
      ],
      "msg": "<string>",
      "type": "<string>"
    }
  ]
}

{
  "detail": "<string>"
}

{
  "detail": "<string>"
}

{
  "detail": "<string>"
}

Authorizations

Authorization

string

header

required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

table_id

string<uuid>

required

Body

application/json

Request body for the row create — how many empty rows, and where.

Without an anchor, rows are appended to the end of the table. With one, exactly one row is inserted directly above or below the anchor row.

after_record_id

string<uuid> | null

Insert a single row directly below this row.

before_record_id

string<uuid> | null

Insert a single row directly above this row.

count

integer

default:1

Number of empty rows to append to the table.

Required range: 1 <= x <= 1000

Response

Successful Response

The rows appended by a create, in creation order.

count

integer

required

rows

TableRowSchema · object[]

required

Show child attributes

API reference

Endpoints

Create table rows

Authorizations

Path Parameters

Body

Response