Records

Update Record

Partially update a specific record by its ID. Only the fields provided in the request body will be changed.

PATCH/databases/{databaseId}/tables/{tableId}/records/{recordId}

Request

curl --request PATCH \
  --url 'https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records/<recordId>' \
  --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/<recordId>"
headers = {
  "Softr-Api-Key": "<api-key>",
  "Content-Type": "application/json"
}
payload = json.loads("{\"fields\":{}}")

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

const response = await fetch("https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records/<recordId>", {
  method: "PATCH",
  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/<recordId>");
curl_setopt($client, CURLOPT_CUSTOMREQUEST, "PATCH");
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("PATCH", "https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records/<recordId>", 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/<recordId>"))
    .header("Softr-Api-Key", "<api-key>")
    .header("Content-Type", "application/json")
    .method("PATCH", 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/<recordId>")
request = Net::HTTP::Patch.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

recordIdstringrequired

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 new values.

Response

application/json

The updated 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 PATCH \ --url 'https://tables-api.softr.io/api/v1/databases/<databaseId>/tables/<tableId>/records/<recordId>' \ --header 'Softr-Api-Key: <api-key>' \ --header 'Content-Type: application/json' \ --data '{ "fields": {} }'

Update 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