---
title: "Bulk update records with field values"
method: PATCH
path: "/sheets/{sheetId}/records/bulk-update"
tags: ["records"]
---

# Bulk update records with field values

`PATCH /sheets/{sheetId}/records/bulk-update`

Updates multiple records at once with the same field values based on filter criteria. This is similar to a SQL UPDATE statement where you can update specific fields for all records matching certain conditions.

## Path parameters

- `sheetId` string, required — Sheet ID

## Query parameters

- `filter` 'valid' | 'error' | 'all' | 'none' — Options to filter records
- `filterField` string — Use this to narrow the valid/error filter results to a specific field
- `searchValue` string — Search for the given value, returning matching rows. For exact matches, wrap the value in double quotes ("Bob"). To search for null values, send empty double quotes ("")
- `searchField` string — Use this to narrow the searchValue results to a specific field
- `sortField` string — Name of field by which to sort records
- `sortDirection` 'asc' | 'desc' — Sort direction - asc (ascending) or desc (descending)
- `ids` string — Record ID
- `q` string
- `silent` boolean

## Headers

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

## Request body

- object
  - `fieldUpdates` object, required — A map of field keys to cell values that will be applied to all matching records

## Response `200`

Response with status 200

- TypeVersionsVersionResponse
  - `data` TypeVersionsVersion, required
    - `versionId` string, required — Version ID

---

[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)