I Need to update an Airtable record's "Status" and "Booking Options" fields (both are Single Select type). The Record ID for the update is passed into the Airtable node as part of its input JSON item (e.g., from a previous Set or Switch node).
Airtable Node Configuration ("Update Record" operation):
- Resource: Record
- Operation: Update
- Mapping Column Mode: Map Each Column Manually
- Columns to match on: id
- ID (using to match) - Expression: {{$json.airtableRecordIdToUpdate}}
- (This expression correctly resolves to a valid Airtable Record ID string like "recUkSMINWTJgvPzw" when previewed in the expression editor with the correct input item).
- Values to Update:
- Status: (Hardcoded string, e.g., "In Progress - A - Needs Pickup location")
- Booking Options: (Hardcoded string, e.g., "A - Pickup/Drop")
- (Field names used here exactly match Airtable field names, case-sensitive).
The issue is when the node executes with the Record ID supplied by the expression {{$json.airtableRecordIdToUpdate}}, it fails with Error Code 422.
The Airtable API error message is: "You must provide an array of up to 10 record objects, each with an \"id\" field and a \"fields\" object for cell values."
However, if I delete the expression from the "ID (using to match)" field and instead hardcode the exact same Record ID string (e.g., recUkSMINWTJgvPzw) directly into that field, the Airtable update node succeeds perfectly, and the record is updated in Airtable.