---
title: "Update multiple records"
method: PATCH
path: "/table/{tableId}/record"
tags: ["record"]
---

# Update multiple records

`PATCH /table/{tableId}/record`

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

## Path parameters

- `tableId` string, required

## Request body

- object — Multiple Update records
  - `fieldKeyType` 'id' | 'name' | 'dbFieldName' — 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
  - `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.
  - `records` object[], required
    - `id` string, required
    - `fields` object, required — Objects with a fields key mapping fieldId or field name to value for that field.
  - `order` object — Where this record to insert to (Optional)
    - `viewId` string, required — You can only specify order in one view when create record (will create a order index automatically)
    - `anchorId` string, required — The record id to anchor to
    - `position` 'before' | 'after', required

## Response `200`

Returns the records data after update.

- object[]
  - `id` string, required — The record id.
  - `name` string — primary field value
  - `fields` object, required — Objects with a fields key mapping fieldId or field name to value for that field.
  - `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

---

[API](https://skmtc.net/teable/apis/teable-app.md) · [All operations](https://skmtc.net/teable/apis/teable-app/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/teable/teable-app/versions/7515f3b33d79/schema)