Update multiple records

Update multiple records in a single request with support for field value typecast and record reordering.

PATCH /table/{tableId}/record

cURL

cURL

curl --request PATCH \
  --url https://sheets.vn/api/table/%7BtableId%7D/record \
  --header 'Authorization: Bearer REPLACE_BEARER_TOKEN' \
  --header 'content-type: application/json' \
  --data '{"fieldKeyType":"id","typecast":true,"records":[{"id":"string","fields":{"property1":null,"property2":null}}],"order":{"viewId":"string","anchorId":"string","position":"before"}}'

200

[
  {
    "id": "<string>",
    "fields": {},
    "name": "<string>",
    "autoNumber": 123,
    "createdTime": "<string>",
    "lastModifiedTime": "<string>",
    "createdBy": "<string>",
    "lastModifiedBy": "<string>",
    "permissions": {},
    "undeletable": true
  }
]

Ủy quyền

Authorization · string · header · bắt buộc

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

Tham số đường dẫn

tableId · string · bắt buộc

Nội dung

application/json

Multiple Update records

records · object[] · bắt buộc

Show child attributes

fieldKeyType · enum<string> · mặc định: 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

Tùy chọn có sẵn: 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)

Show child attributes

Phản hồi

200 - application/json

Returns the records data after update.

id · string · bắt buộc

The record id.

fields · object · bắt buộc

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

Show child attributes

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

Show child attributes

undeletable · boolean

Whether the record is undeletable