---
title: "Insert records"
method: POST
path: "/sheets/{sheetId}/records"
tags: ["records"]
---

# Insert records

`POST /sheets/{sheetId}/records`

Adds records to a workbook sheet

## Path parameters

- `sheetId` string, required — Sheet ID

## Headers

- `Authorization` string, required
- `X-Disable-Hooks` 'true', required

## Request body

- TypeRecordsRecordData[]

## Response `200`

Response with status 200

- TypeRecordsRecordsResponse
  - `data` TypeRecordsRecordsResponseData, required
    - `success` boolean, required
    - `records` TypeRecordsRecordWithLinks[] — List of Record objects, including links to related rows
      - `id` string, required — Record ID
      - `values` TypeRecordsRecordDataWithLinks, required — A single row of data in a Sheet, including links to related rows
      - `valid` boolean
      - `messages` TypeRecordsValidationMessage[]
        - `field` string
        - `type` 'error' | 'warn' | 'info'
        - `source` 'required-constraint' | 'unique-constraint' | 'custom-logic' | 'unlinked' | 'invalid-option' | 'is-artifact'
        - `message` string
        - `path` string — A JSONPath string - https://www.rfc-editor.org/rfc/rfc9535
      - `metadata` object
      - `config` TypeRecordsRecordConfig — Configuration of a record or specific fields in the record
        - `readonly` boolean
        - `fields` object
        - `markedForDeletion` boolean
    - `counts` TypeRecordsRecordCounts
      - `total` integer, required
      - `valid` integer, required
      - `error` integer, required
      - `errorsByField` object
      - `byField` object — Counts for valid, error, and total records grouped by field key
    - `versionId` string — Version ID
    - `commitId` string — Commit ID

## Other responses

- `400` — Error response with status 400
- `404` — Error response with status 404

---

[API](https://skmtc.net/flatfile/apis/api-reference.md) · [All operations](https://skmtc.net/flatfile/apis/api-reference/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/flatfile/api-reference/revisions/9d3a9979cd96/schema)