Llana icon

Llana

Consume Llana API

Actions5

Update

AI-generated

Overview

This node integrates with the Llana API to perform CRUD operations on records within specified tables. It supports creating, retrieving (single or multiple), updating, and deleting records in a flexible manner. This node is useful for automating workflows that involve managing data stored in Llana tables, such as syncing records between systems, updating customer information, or batch processing data entries.

For example, you can use this node to update a specific record in a table by specifying the record ID and the fields to change, or retrieve multiple records with optional query parameters to filter results.

Properties

Name Meaning
Authentication Method of authentication to use: API Key, Username & Password, or Host API
Table Name or ID The target table where the operation will be performed; selectable from a list or via expression
Record ID The unique identifier of the record to get, update, or delete (required for these operations)
Fields to Send Collection of fields and their values to send when creating or updating a record

Details on "Fields to Send"

  • Field Name or ID: Select the field in the table to update.
  • Field Value: The value to assign to the selected field.

Output

The node outputs JSON data representing the response from the Llana API for the requested operation:

  • For Update operation, the output JSON contains the updated record's data as returned by the API.
  • For other operations, the output structure corresponds to the respective API responses (e.g., deleted record confirmation, retrieved record data).
  • If binary data were involved (not applicable here), it would be included in the binary output field, but this node does not handle binary data output.

Dependencies

  • Requires access to the Llana API endpoint.
  • Requires appropriate authentication credentials configured in n8n:
    • An API key credential, or
    • Username and password credential, or
    • Host API credential.
  • Uses internal helper functions to load available tables and fields dynamically.

Troubleshooting

  • Invalid Record ID: If the provided record ID does not exist or is malformed, the API may return an error. Verify the record ID is correct.
  • Authentication Errors: Ensure the chosen authentication method is correctly configured and valid.
  • Field Validation: When updating fields, ensure the field names/IDs and values conform to the expected format and data types defined in the Llana table schema.
  • JSON Parsing Error: For operations involving JSON input (like query parameters in listing records), invalid JSON will cause errors. Validate JSON syntax before execution.
  • API Rate Limits or Connectivity Issues: Network problems or API rate limits may cause request failures. Check connectivity and API usage quotas.

Links and References

Discussion