跳转到主要内容
PATCH
/
table
/
{tableId}
/
record
/
{recordId}
Update record
curl --request PATCH \
  --url http://127.0.0.1:3000/api/table/{tableId}/record/{recordId} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "record": {
    "fields": {}
  },
  "fieldKeyType": "name",
  "typecast": true,
  "order": {
    "viewId": "<string>",
    "anchorId": "<string>",
    "position": "before"
  }
}
'
{
  "id": "<string>",
  "fields": {},
  "name": "<string>",
  "autoNumber": 123,
  "createdTime": "<string>",
  "lastModifiedTime": "<string>",
  "createdBy": "<string>",
  "lastModifiedBy": "<string>",
  "permissions": {},
  "undeletable": true
}

授权

​
Authorization
string
header
必填

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

路径参数

​
tableId
string
必填
​
recordId
string
必填

请求体

application/json

Update record by id

​
record
object
必填
​
fieldKeyType
enum<string>
默认值:name

Define the key type of record.fields[key], You can click "systemInfo" in the field edit box to get fieldId or enter the table design screen with all the field details

可用选项:
id,
name,
dbFieldName
​
typecast
boolean

Automatic data conversion from cellValues if the typecast parameter is passed in. Automatic conversion is disabled by default to ensure data integrity, but it may be helpful for integrating with 3rd party data sources.

​
order
object

Where this record to insert to (Optional)

响应

200 - application/json

Returns record data after update.

​
id
string
必填

The record id.

​
fields
object
必填

Objects with a fields key mapping fieldId or field name to value for that field.

​
name
string

primary field value

​
autoNumber
number

Auto number, a unique identifier for each record

​
createdTime
string

Created time, date ISO string (new Date().toISOString).

​
lastModifiedTime
string

Last modified time, date ISO string (new Date().toISOString).

​
createdBy
string

Created by, user name

​
lastModifiedBy
string

Last modified by, user name

​
permissions
object

Permissions for the record

​
undeletable
boolean

Whether the record is undeletable

Last modified on December 10, 2025