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 "Record" resource with the "Get" operation retrieves a single record by its ID from a selected datasheet.

Common scenarios where this node is beneficial include:

  • Fetching detailed information about a specific record in a datasheet for further processing or decision-making.
  • Integrating Aitable data retrieval into automated workflows, such as syncing record details with other systems or triggering actions based on record content.

Practical example:

  • You have a datasheet tracking customer orders and want to retrieve the details of a particular order by its record ID to update your CRM or send a notification.

Properties

Name Meaning
Datasheet Select the datasheet to operate on. The list is dynamically loaded from available datasheets in your Aitable workspace.
Record ID The unique identifier of the record you want to retrieve from the selected datasheet.

Output

The output contains a JSON object representing the retrieved record's data fields exactly as stored in Aitable. This includes all field names and their corresponding values for that record.

Example output structure (simplified):

{
  "recordId": "rec123",
  "fields": {
    "Name": "Sample Record",
    "Status": "Active",
    "Date": "2024-01-01"
  }
}

No binary data output is produced by this operation.

Dependencies

  • Requires an API authentication token credential for Aitable to authorize requests.
  • The node makes HTTP requests to the Aitable API endpoints to fetch datasheets, fields, and records.
  • Proper configuration of the API key credential in n8n is necessary for successful operation.

Troubleshooting

  • Common issues:

    • Invalid or expired API token: The node will fail to authenticate with the Aitable API.
    • Incorrect Record ID: If the specified record ID does not exist in the datasheet, the node returns an error indicating the record was not found.
    • Network or API downtime: Temporary connectivity issues can cause request failures.

  • Error messages:

    • Aitable API Error: <message> — Indicates an error response from the Aitable API. Check the message for details such as invalid parameters or authorization failure.
    • "Unknown error" — Generic fallback if no specific error message is returned; verify credentials and input parameters.

  • Resolution tips:

    • Verify the API token is valid and has sufficient permissions.
    • Confirm the datasheet and record IDs are correct and exist.
    • Ensure network connectivity to the Aitable API endpoint.
    • Use the "Continue On Fail" option in n8n to handle errors gracefully in workflows.

Links and References

Discussion