Records

Create Record

Create a new record in the specified table.

POST/databases/{databaseId}/tables/{tableId}/records

Request

curl --request POST \
  --url 'https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records' \
  --header 'Softr-Api-Key: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "fields": {}
}'

import json
import requests

url = "https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records"
headers = {
  "Softr-Api-Key": "<api-key>",
  "Content-Type": "application/json"
}
payload = json.loads("{\"fields\":{}}")

response = requests.request("POST", url, headers=headers, json=payload)
print(response.json())

const response = await fetch("https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records", {
  method: "POST",
  headers: {
    "Softr-Api-Key": "<api-key>",
    "Content-Type": "application/json"
  },
  body: JSON.stringify({
    "fields": {}
  }),
});

const data = await response.json();
console.log(data);

<?php
$client = curl_init();

curl_setopt($client, CURLOPT_URL, "https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records");
curl_setopt($client, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($client, CURLOPT_HTTPHEADER, [
    "Softr-Api-Key: <api-key>",
    "Content-Type: application/json",
]);
curl_setopt($client, CURLOPT_POSTFIELDS, "{\"fields\":{}}");
curl_setopt($client, CURLOPT_RETURNTRANSFER, true);

$response = curl_exec($client);
curl_close($client);
echo $response;

package main

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

func main() {
  req, _ := http.NewRequest("POST", "https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records", bytes.NewBuffer([]byte("{\"fields\":{}}")))
  req.Header.Set("Softr-Api-Key", "<api-key>")
  req.Header.Set("Content-Type", "application/json")
  res, _ := http.DefaultClient.Do(req)
  defer res.Body.Close()
  data, _ := io.ReadAll(res.Body)
  fmt.Println(string(data))
}

import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;

var request = HttpRequest.newBuilder(URI.create("https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records"))
    .header("Softr-Api-Key", "<api-key>")
    .header("Content-Type", "application/json")
    .method("POST", HttpRequest.BodyPublishers.ofString("{\"fields\":{}}"))
    .build();

var response = HttpClient.newHttpClient().send(
    request, HttpResponse.BodyHandlers.ofString());
System.out.println(response.body());

require 'net/http'
require 'json'

uri = URI("https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records")
request = Net::HTTP::Post.new(uri)
request["Softr-Api-Key"] = "<api-key>"
request["Content-Type"] = "application/json"
request.body = "{\"fields\":{}}"

response = Net::HTTP.start(uri.hostname, uri.port, use_ssl: uri.scheme == "https") do |http|
  http.request(request)
end

puts response.body

application/json

{
  "data": {
    "id": "<string>",
    "tableId": "<string>",
    "fields": {},
    "createdAt": "2024-01-01T00:00:00Z",
    "updatedAt": "2024-01-01T00:00:00Z"
  }
}

Authorizations

Softr-Api-KeyAPI key · headerrequired

Path Parameters

databaseIdstringrequired

tableIdstringrequired

Query Parameters

fieldNamesbooleandefault: false

If true, use field names as keys in the response fields object instead of field IDs.

Body

application/json

fieldsRecord<string, unknown>

A map of Field IDs to their values.

Response

application/json

The newly created record.

dataobject

Show child attributes

data.idstring

data.tableIdstring

data.fieldsRecord<string, unknown>

A map of Field IDs to their values for this record.

data.createdAtstring<date-time>

data.updatedAtstring<date-time>

curl --request POST \ --url 'https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records' \ --header 'Softr-Api-Key: <api-key>' \ --header 'Content-Type: application/json' \ --data '{ "fields": {} }'

Create Record

Authorizations

Path Parameters

Query Parameters

Body

Response

Use these docs with your AI tools

Query these docs via MCP

Query these docs over HTTP

Read these docs as Markdown