Llana icon

Llana

Consume Llana API

Actions5

Create

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.

Common scenarios where this node is beneficial include:

  • Automating data entry by creating new records in Llana tables.
  • Fetching specific records or lists of records for reporting or further processing.
  • Updating existing records based on external triggers or workflows.
  • Removing obsolete or incorrect records programmatically.

For example, you could use this node to automatically create customer entries in a Llana database when a new order is received, or to update inventory levels after a sale.

Properties

Name Meaning
Authentication Method used to authenticate with the Llana API. Options: API Key, Username & Password, Host API.
Table Name or ID The target table in Llana where the operation will be performed. Can be selected from a list or set via expression.
Operation The action to perform on the record(s). Options: Create, Delete, Get (single record), List Records, Update.
Record ID (Required for Delete, Get, Update) The unique identifier of the record to operate on.
Fields to Send (For Create and Update) A collection of fields and their values to send when creating or updating a record. Each field can be selected from the table's available fields or specified by ID.
Fields (For Get and List Records) Specifies which fields to include in the response.
Return All (For List Records) Whether to return all matching records or limit the number returned.
Send Query Parameters (For List Records) Whether to include query parameters in the request.
Specify Query Parameters (For List Records with query params) Choose between specifying query parameters as key-value pairs or JSON.
Query Parameters (For List Records with key-value query) Collection of name-value pairs to filter the list request.
JSON Query (For List Records with JSON query) Raw JSON string representing query parameters.
Limit (For List Records without Return All) Maximum number of records to return.

Output

The node outputs an array of JSON objects representing the records returned or affected by the operation:

  • For Create and Update, the output contains the newly created or updated record data.
  • For Get (single record), the output contains the requested record's data.
  • For List Records, the output contains an array of records matching the query or criteria.
  • For Delete, the output typically contains confirmation or status of the deletion.

If binary data were involved, it would be handled separately, but this node does not output binary data.

Dependencies

  • Requires access to the Llana API endpoint.
  • Requires authentication credentials configured in n8n, supporting API Key, Username & Password, or Host API methods.
  • Uses helper functions (apiRequest, apiRequestAllItems) from bundled dependencies to handle HTTP requests and pagination.

Troubleshooting

  • Invalid JSON in Query Parameters: When specifying query parameters as JSON, invalid JSON syntax will cause an error. Ensure the JSON is well-formed.
  • Missing Required Fields: Operations like Create, Update, Delete require certain fields such as Table and Record ID (where applicable). Omitting these will result in errors.
  • Authentication Errors: Incorrect or missing credentials will prevent successful API calls. Verify that the correct authentication method and credentials are provided.
  • Empty Responses: If no records match the query or the record ID does not exist, the output may be empty or contain error messages.
  • Rate Limits or API Errors: The Llana API may impose rate limits or return errors; these will be surfaced as node execution errors unless "Continue On Fail" is enabled.

Links and References

Discussion