capabilities.work

Enrich Records

A 2-step recipe with Airtable. We can help you get access.

Recipe · 2 steps

Enrich Records

Locate a record with an empty field and patch it.

  1. Search the table for a record where the target field is empty, returning at most one match to enrich.
  2. Patch the matched record with the enrichment fields, leaving all other fields intact. Typecast is enabled so string values are converted to the appropriate cell value types.
What you'll need to have ready
  • baseId: The Airtable base identifier (e.g. appXXXXXXXXXXXXXX).
  • tableIdOrName: The table id or name to enrich records in.
  • emptyField: The field name to test for emptiness (e.g. "Company").
  • fields: The map of field name/value pairs to patch onto the record.
For your developer

Arazzo workflow airtable:enrich-records, 2 operations: listRecords → updateRecord. Specs on APIs.io.