---
title: "Create records"
method: POST
path: "/table/{tableId}/record"
tags: ["record"]
---

# Create records

`POST /table/{tableId}/record`

Create one or multiple records with support for field value typecast and custom record ordering.

## Path parameters

- `tableId` string, required

## Request body

- object — Multiple Create 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.
  - `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
  - `records` object[], required — Array of record objects
    - `fields` object, required — Objects with a fields key mapping fieldId or field name to value for that field.

## Response `201`

Returns data about the records.

- object
  - `records` object[], required — Array of record objects
    - `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/revisions/7515f3b33d79/schema)