Aitable icon

Aitable

Interact with the Aitable API

Actions6

Overview

This node integrates with the Aitable API to manage records within datasheets. Specifically, the Record Create operation allows users to add new records to a selected datasheet by specifying field values.

Common scenarios where this node is beneficial include:

  • Automating data entry into Aitable datasheets from other workflows.
  • Creating new entries based on form submissions or external triggers.
  • Populating datasheets dynamically during data processing pipelines.

For example, after receiving customer information via a web form, you can use this node to create a new record in an Aitable datasheet with fields like "Name", "Email", and "Phone Number" populated accordingly.

Properties

Name Meaning
Datasheet Select the target datasheet where the new record will be created.
Fields Define one or more fields and their corresponding values to set in the new record.

The Fields property supports multiple entries, each consisting of:

  • Field: The name of the field in the datasheet (loaded dynamically based on the selected datasheet).
  • Value: The string value to assign to that field in the new record.

Output

The output contains the newly created record's data as JSON under the json key. This includes all fields returned by the Aitable API for the created record, typically including the record ID and the field values as stored.

Example output structure:

{
  "json": {
    "id": "rec123456789",
    "fields": {
      "Name": "John Doe",
      "Email": "john@example.com",
      "Phone Number": "123-456-7890"
    },
    "createdTime": "2024-01-01T12:00:00Z"
  }
}

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 the Aitable API endpoints to perform operations.
  • Proper configuration of the API token credential in n8n is necessary for successful execution.

Troubleshooting

  • API Errors: If the Aitable API returns an error (e.g., invalid datasheet ID, missing required fields), the node throws an error with the message prefixed by Aitable API Error:. Check that the datasheet ID and field names are correct and that the API token has sufficient permissions.
  • Empty or Incorrect Field Values: Ensure that the field names match exactly those in the datasheet and that values are provided as strings.
  • Credential Issues: If authentication fails, verify that the API token credential is correctly set up and valid.
  • Network Issues: Connectivity problems may cause request failures; ensure network access to the Aitable API endpoint.

Using the node's "Continue On Fail" option can help handle errors gracefully in workflows.

Links and References

Discussion