Finds and replaces field values matching search criteria
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
Headers
Bearer authentication of the form Bearer <token>
, where token is your auth token.
Query parameters
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 ("")
Request
A value to find for a given field in a sheet. For exact matches, wrap the value in double quotes (“Bob”)