Tables

Create Table

Create a new table in the specified database.

POST/databases/{databaseId}/tables

Request

curl --request POST \
  --url 'https://tables-api.softr.io/api/v1/databases/<databaseId>/tables' \
  --header 'Softr-Api-Key: <api-key>' \
  --header 'Content-Type: application/json' \
  --data '{
  "name": "<string>",
  "description": "<string>",
  "primaryFieldName": "<string>",
  "fields": [
    {
      "name": "<string>",
      "type": "<string>",
      "options": {}
    }
  ]
}'

import json
import requests

url = "https://tables-api.softr.io/api/v1/databases/<databaseId>/tables"
headers = {
  "Softr-Api-Key": "<api-key>",
  "Content-Type": "application/json"
}
payload = json.loads("{\"name\":\"<string>\",\"description\":\"<string>\",\"primaryFieldName\":\"<string>\",\"fields\":[{\"name\":\"<string>\",\"type\":\"<string>\",\"options\":{}}]}")

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", {
  method: "POST",
  headers: {
    "Softr-Api-Key": "<api-key>",
    "Content-Type": "application/json"
  },
  body: JSON.stringify({
    "name": "<string>",
    "description": "<string>",
    "primaryFieldName": "<string>",
    "fields": [
      {
        "name": "<string>",
        "type": "<string>",
        "options": {}
      }
    ]
  }),
});

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");
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, "{\"name\":\"<string>\",\"description\":\"<string>\",\"primaryFieldName\":\"<string>\",\"fields\":[{\"name\":\"<string>\",\"type\":\"<string>\",\"options\":{}}]}");
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", bytes.NewBuffer([]byte("{\"name\":\"<string>\",\"description\":\"<string>\",\"primaryFieldName\":\"<string>\",\"fields\":[{\"name\":\"<string>\",\"type\":\"<string>\",\"options\":{}}]}")))
  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"))
    .header("Softr-Api-Key", "<api-key>")
    .header("Content-Type", "application/json")
    .method("POST", HttpRequest.BodyPublishers.ofString("{\"name\":\"<string>\",\"description\":\"<string>\",\"primaryFieldName\":\"<string>\",\"fields\":[{\"name\":\"<string>\",\"type\":\"<string>\",\"options\":{}}]}"))
    .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")
request = Net::HTTP::Post.new(uri)
request["Softr-Api-Key"] = "<api-key>"
request["Content-Type"] = "application/json"
request.body = "{\"name\":\"<string>\",\"description\":\"<string>\",\"primaryFieldName\":\"<string>\",\"fields\":[{\"name\":\"<string>\",\"type\":\"<string>\",\"options\":{}}]}"

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>",
    "name": "<string>",
    "description": "<string>",
    "primaryFieldId": "<string>",
    "defaultViewId": "<string>",
    "fields": [
      {
        "id": "<string>",
        "name": "<string>",
        "description": "<string>",
        "type": "SINGLE_LINE_TEXT",
        "options": {},
        "allowMultipleEntries": true,
        "readonly": true,
        "required": true,
        "locked": true,
        "defaultValue": "<string>",
        "aiOptions": {
          "aiFillable": true,
          "aiOnly": true,
          "allowWebSearch": true,
          "aiModel": "<string>",
          "prompt": "<string>",
          "canBeTriggeredManually": true,
          "runWhenRecordIsCreated": true,
          "runWhenRecordIsUpdated": true
        },
        "createdAt": "2024-01-01T00:00:00Z",
        "updatedAt": "2024-01-01T00:00:00Z"
      }
    ],
    "createdAt": "2024-01-01T00:00:00Z",
    "updatedAt": "2024-01-01T00:00:00Z"
  }
}

Authorizations

Softr-Api-KeyAPI key · headerrequired

Path Parameters

databaseIdstringrequired

Body

application/json

namestring

descriptionstring

primaryFieldNamestring

fieldsobject[]

Show child attributes

fields.namestring

fields.typestring

fields.optionsRecord<string, unknown>

Response

application/json

The newly created table.

dataobject

Show child attributes

data.idstring

data.namestring

data.descriptionstring | null

data.primaryFieldIdstring

data.defaultViewIdstring

data.fieldsobject[]

Show child attributes

data.fields.idstring

data.fields.namestring

data.fields.descriptionstring | null

Optional description of the field.

data.fields.typeenum<string>

The type of the field.

Available options: SINGLE_LINE_TEXT, CHECKBOX, CURRENCY, DATE, DATETIME, DURATION, EMAIL, SELECT, NUMBER, ATTACHMENT, RATING, LINKED_RECORD, LONG_TEXT, URL, PERCENT, PHONE, LOOKUP, ROLLUP, FORMULA, CREATED_AT, UPDATED_AT, CREATED_BY, UPDATED_BY, AUTONUMBER, RECORD_ID, USER

data.fields.optionsRecord<string, unknown>

Configuration options for the field, specific to its type. See the official documentation for the structure of each type.

data.fields.allowMultipleEntriesboolean

data.fields.readonlyboolean

data.fields.requiredboolean

data.fields.lockedboolean

data.fields.defaultValuestring | null

data.fields.aiOptionsobject | null

AI-powered auto-fill configuration. Null if not configured.

Show child attributes

data.fields.aiOptions.aiFillableboolean

data.fields.aiOptions.aiOnlyboolean

data.fields.aiOptions.allowWebSearchboolean

data.fields.aiOptions.aiModelstring

data.fields.aiOptions.promptstring

data.fields.aiOptions.canBeTriggeredManuallyboolean

data.fields.aiOptions.runWhenRecordIsCreatedboolean

data.fields.aiOptions.runWhenRecordIsUpdatedboolean

data.fields.createdAtstring<date-time>

data.fields.updatedAtstring<date-time>

data.createdAtstring<date-time>

data.updatedAtstring<date-time>

curl --request POST \ --url 'https://tables-api.softr.io/api/v1/databases/<databaseId>/tables' \ --header 'Softr-Api-Key: <api-key>' \ --header 'Content-Type: application/json' \ --data '{ "name": "<string>", "description": "<string>", "primaryFieldName": "<string>", "fields": [ { "name": "<string>", "type": "<string>", "options": {} } ] }'

{ "data": { "id": "<string>", "name": "<string>", "description": "<string>", "primaryFieldId": "<string>", "defaultViewId": "<string>", "fields": [ { "id": "<string>", "name": "<string>", "description": "<string>", "type": "SINGLE_LINE_TEXT", "options": {}, "allowMultipleEntries": true, "readonly": true, "required": true, "locked": true, "defaultValue": "<string>", "aiOptions": { "aiFillable": true, "aiOnly": true, "allowWebSearch": true, "aiModel": "<string>", "prompt": "<string>", "canBeTriggeredManually": true, "runWhenRecordIsCreated": true, "runWhenRecordIsUpdated": true }, "createdAt": "2024-01-01T00:00:00Z", "updatedAt": "2024-01-01T00:00:00Z" } ], "createdAt": "2024-01-01T00:00:00Z", "updatedAt": "2024-01-01T00:00:00Z" } }

Create Table

Authorizations

Path 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