Aitable Unofficial icon

Aitable Unofficial

Interact with Aitable.ai API (Unofficial Integration)

Actions5

Overview

The node enables creating a new record in an Aitable.ai datasheet. It supports setting values for various field types, including text, number, checkbox, date, select, multi-select, and linked records (one-way or two-way links). Users can specify fields either by their names or IDs, with an option to fetch metadata about the datasheet's fields to assist in accurate field identification.

This node is beneficial when automating data entry into Aitable datasheets from other workflows, such as adding new project entries, logging form submissions, or syncing data from external sources.

Example use case: Automatically create a new project record in an Aitable datasheet whenever a new lead is captured in a CRM system, populating fields like project name, start date, status (select), and related contacts (linked records).

Properties

Name Meaning
Space ID The identifier of the Aitable space where the datasheet resides (e.g., spcX9P2xUcKst).
Datasheet ID The identifier of the datasheet in which to create the record (e.g., dstXXXXXXXXXXX). This can be found in the URL when viewing the datasheet.
Use Field Names Boolean flag indicating whether to use field names instead of field IDs when specifying fields. Using field names is recommended for readability and ease of use.
Fields Collection of fields to set on the new record. Each field includes:
- Field Name or ID: The name or ID of the field (e.g., "Title" or fldXXXXXXXXXXX).
- Field Type: One of Checkbox, Date, Link (One-Way), Link (Two-Way), MultiSelect, Number, Select, Text.
- Field Value: The value to assign. For linked fields, enter record IDs separated by commas; to clear a linked field explicitly, type "null". Empty values are ignored for security reasons.
Fetch Fields Boolean flag to fetch datasheet field metadata before creating the record. This helps map field names to IDs automatically and ensures correct field handling.

Output

The output contains the newly created record's data in JSON format, including all fields returned by the Aitable API after creation. The output JSON also includes the datasheetId to indicate the source datasheet.

Example output structure:

{
  "recordId": "recXXXXXXXXXXX",
  "fields": {
    "Title": "New Project",
    "StartDate": "2024-06-01",
    "Status": "Active",
    "Contacts": ["recYYYYYYYYYYY", "recZZZZZZZZZZZ"]
  },
  "datasheetId": "dstXXXXXXXXXXX"
}

No binary data output is produced by this node.

Dependencies

  • Requires an active connection to the Aitable.ai API.
  • Needs an API authentication token configured in n8n credentials (referred generically as "an API key credential").
  • Network access to https://aitable.ai is required.

Troubleshooting

  • Missing Datasheet ID: The node throws an error if the Datasheet ID is not provided. Ensure this ID is correctly set.
  • Field Mapping Errors: If "Fetch Fields" is enabled but the API call to retrieve field metadata fails, the node will throw an error. Check network connectivity and API permissions.
  • Invalid Field Values: Providing empty strings for fields will cause those fields to be ignored. To clear linked fields, explicitly use "null".
  • API Errors: If the API returns an error during record creation, the node outputs a failure message. Review the error details in the output and verify API credentials and datasheet permissions.
  • Continue On Fail: If enabled, the node will continue processing subsequent items even if one item fails, returning error details in the output JSON.

Links and References

Discussion