Records

Update a record

Applies a partial update; the body is {"fields":{…}}, keyed by field id or exact name.

PATCH/v1/tables/{tableId}/records/{recordId}

Request

curl --request PATCH \
  --url 'https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records/<recordId>' \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
  "fields": {}
}'

import json
import requests

url = "https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records/<recordId>"
headers = {
  "Authorization": "Bearer <token>",
  "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://your-suite.gtable.app/your-app/v1/tables/<tableId>/records/<recordId>", {
  method: "PATCH",
  headers: {
    "Authorization": "Bearer <token>",
    "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://your-suite.gtable.app/your-app/v1/tables/<tableId>/records/<recordId>");
curl_setopt($client, CURLOPT_CUSTOMREQUEST, "PATCH");
curl_setopt($client, CURLOPT_HTTPHEADER, [
    "Authorization: Bearer <token>",
    "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://your-suite.gtable.app/your-app/v1/tables/<tableId>/records/<recordId>", bytes.NewBuffer([]byte("{\"fields\":{}}")))
  req.Header.Set("Authorization", "Bearer <token>")
  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://your-suite.gtable.app/your-app/v1/tables/<tableId>/records/<recordId>"))
    .header("Authorization", "Bearer <token>")
    .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://your-suite.gtable.app/your-app/v1/tables/<tableId>/records/<recordId>")
request = Net::HTTP::Patch.new(uri)
request["Authorization"] = "Bearer <token>"
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": {
    "record": {},
    "stillVisible": true,
    "droppedFields": 123,
    "warnings": [
      {
        "code": "<string>",
        "recordId": "<string>",
        "fieldId": "<string>",
        "fieldName": "<string>",
        "message": "<string>"
      }
    ],
    "changesetId": "<string>"
  }
}

{
  "error": {
    "code": "not_found",
    "message": "<string>",
    "details": {}
  }
}

If the change moves the record outside what you can see, the response says so rather than pretending the record vanished. Email, URL and phone text is preserved; visible suspect values are returned in warnings (code suspect_format, recordId, fieldId, fieldName, message). A warning is a successful save, not a reason to retry. Invalid numeric values, ratings and ISO dates fail with validation_failed/422. A failing create batch saves no rows.

Requires the records:write scope. Operation records.update. MCP tool records_update. CLI, once published: gtable records update.

Path parameters

Name	Type	Required	Description
`tableId`	string	yes
`recordId`	string	yes

Headers

Name	Type	Required	Description
`Idempotency-Key`	string	no	Any unique string. Sending the same key with the same request again returns the first response (marked `Idempotency-Replayed: true`) instead of running it twice. Reusing it for a different request is refused with 409. Kept for 24 hours. Up to 255 characters.

Request body

Field	Type	Required	Description
`fields`	object	yes
`baseVersion`	string	no	Up to 64 characters.

Response

application/json

Success

dataobjectrequired

Show child attributes

recordRecord<string, object>required

stillVisiblebooleanrequired

droppedFieldsintegerrequired

warningsobject[]required

changesetIdstring

curl --request PATCH \ --url 'https://your-suite.gtable.app/your-app/v1/tables/<tableId>/records/<recordId>' \ --header 'Authorization: Bearer <token>' \ --header 'Content-Type: application/json' \ --data '{ "fields": {} }'

{ "data": { "record": {}, "stillVisible": true, "droppedFields": 123, "warnings": [ { "code": "<string>", "recordId": "<string>", "fieldId": "<string>", "fieldName": "<string>", "message": "<string>" } ], "changesetId": "<string>" } }

Update a record

Path parameters

Headers

Request body

Response

Use these docs with your AI tools

Query these docs via MCP

Query these docs over HTTP

Read these docs as Markdown