AirtablePlus icon

AirtablePlus

Append, update, and upsert data from Airtable

Actions3

Update

AI-generated

Overview

The AirtablePlus node for n8n allows you to update existing records in an Airtable base. Specifically, with the "Update" operation, you can modify one or more records by specifying their IDs and providing new field values. This is useful for workflows where you need to keep Airtable data synchronized with other systems, correct errors, or enrich records based on external events.

Practical examples:

  • Automatically updating customer information in Airtable when changes are detected in your CRM.
  • Modifying inventory levels in Airtable after processing orders from an e-commerce platform.
  • Updating task statuses in a project management base as part of an automated workflow.

Properties

Name Meaning
Base ID The ID of the Airtable base to access. Required to identify which Airtable workspace you want to update records in.
Table ID The ID of the table within the base where the record(s) will be updated.
ID The unique identifier of the record to update. This must match the Airtable record's ID.
Fields The fields and their new values to set on the record. You can specify multiple fields, each with a Field Name and Field Value.
Options Additional options for the update operation:
- Bulk Size: Number of records to process at once (1–10).
- Typecast: Whether the Airtable API should attempt mapping of string values for linked records & select options.

Output

  • The output is a JSON array containing the updated records.
  • Each item in the array represents a record and includes all fields returned by the Airtable API after the update.
  • If an error occurs and "Continue On Fail" is enabled, the output will include an object with an error property describing the issue.

Example output:

[
  {
    "id": "recXXXXXXXXXXXXXX",
    "fields": {
      "Name": "Updated Name",
      "Status": "Complete"
    },
    "createdTime": "2024-06-01T12:34:56.000Z"
  }
]

If an error occurs:

[
  {
    "error": "Record not found"
  }
]

Dependencies

  • External Service: Requires access to the Airtable API.
  • API Key: An Airtable API key is required and must be configured in n8n credentials under airtableApi.
  • n8n Configuration: No additional environment variables are needed beyond the Airtable API credential.

Troubleshooting

Common issues:

  • Invalid Record ID: If the provided ID does not exist in the specified table, an error such as "Record not found" will occur.
  • Field Name Mismatch: If a field name does not match any field in the Airtable table, the update may fail or the field will be ignored.
  • API Key Issues: If the API key is missing or invalid, authentication errors will occur.
  • Bulk Size Exceeded: The maximum allowed bulk size is 10; exceeding this will result in an error.

Error messages and resolutions:

  • "The operation \"...\" is not known!": Ensure that the operation is set to "Update".
  • "Record not found": Check that the ID matches an existing record in the specified table.
  • "INVALID_VALUE_FOR_COLUMN": Verify that the field names and values are valid for the target table.

Links and References

Discussion