Aitable icon

Aitable

Interact with the Aitable API
Join our community

Actions6

Overview

This node interacts with the Aitable API to manage records within datasheets. Specifically, the Update Record operation allows users to modify existing records by specifying the record ID and the fields to update.

Common scenarios where this node is beneficial include:

  • Updating customer or inventory data stored in an Aitable datasheet.
  • Modifying specific fields of a record based on workflow logic or external triggers.
  • Automating updates to datasets without manual intervention.

For example, you might use this node to update the status of an order record after payment confirmation or to change the priority of a task in a project management datasheet.

Properties

Name Meaning
Datasheet Select the datasheet to operate on. This determines which table the record belongs to.
Record ID The unique identifier of the record to update.
Fields One or more fields to update on the record. Each field consists of:
- Field: The name of the field to update (loaded dynamically based on the selected datasheet).
- Value: The new value to set for that field.

Output

The output JSON contains the updated record's data as returned by the Aitable API. It includes all fields of the record after the update has been applied.

Example output structure:

{
  "recordId": "rec123",
  "fields": {
    "Name": "Updated Name",
    "Status": "Completed",
    ...
  }
}

No binary data output is produced by this operation.

Dependencies

  • Requires an API authentication token credential for the Aitable API.
  • The node makes HTTP requests to https://aitable.ai/fusion/v1 endpoints.
  • The user must have access rights to the specified datasheet and record within Aitable.

Troubleshooting

  • API Errors: If the API returns an error message, it will be thrown as Aitable API Error: <message>. Common causes include invalid record ID, insufficient permissions, or malformed field values.
  • Record Not Found: If the specified record ID does not exist, the API may return an error or no records, resulting in failure.
  • Field Loading Issues: The list of fields depends on the selected datasheet. If fields do not load, verify the datasheet ID and API credentials.
  • Empty Field Values: Ensure that field values are provided; empty or incorrect values may cause the update to fail or produce unexpected results.
  • Continue On Fail: If enabled, errors will be captured in the output JSON under an error property instead of stopping execution.

Links and References

Discussion