---
title: "Finds and replaces field values matching search criteria"
method: PUT
path: "/sheets/{sheetId}/find-replace"
tags: ["records"]
---

# Finds and replaces field values matching search criteria

`PUT /sheets/{sheetId}/find-replace`

Searches for all values that match the 'find' value (globally or for a specific field via 'fieldKey') and replaces them with the 'replace' value. Wrap 'find' value in double quotes for exact match (""). Returns a commitId for the updated records

## 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
- `ids` string — Record ID
- `q` string

## Headers

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

## Request body

- object
  - `find` union
    - string
    - integer
    - integer
    - number, double
    - boolean
    - string, date
    - string, date-time
    - string[]
  - `replace` union
    - string
    - integer
    - integer
    - number, double
    - boolean
    - string, date
    - string, date-time
    - string[]
  - `fieldKey` string, required — A unique key used to identify a field in a sheet

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