Llana icon

Llana

Consume Llana API

Actions5

Get

AI-generated

Overview

This node integrates with the Llana API to perform CRUD operations on records within specified tables. It supports multiple authentication methods and allows users to create, retrieve, update, delete, or list records from a chosen table.

Common scenarios where this node is beneficial include:

  • Automating data retrieval from Llana tables for reporting or further processing.
  • Creating new records in Llana based on external triggers or workflows.
  • Updating existing records dynamically as data changes.
  • Deleting obsolete or unwanted records programmatically.
  • Querying multiple records with optional filtering and pagination.

For example, you could use this node to fetch a specific customer record by ID, update their contact information, or list all orders placed within a certain date range.

Properties

Name Meaning
Authentication Method used to authenticate requests. Options: API Key, Username & Password, Host API.
Operation The action to perform on the data. Options: Create (add a new record), Delete (remove a record), Get (retrieve a single record), List Records (retrieve multiple records), Update (modify a record).
Table Name or ID The target table to operate on. Choose from a loaded list of tables or specify an ID via expression.
Record ID The unique identifier of the record to get, update, or delete. Required for these operations.
Fields For "Get" and "List Records" operations, select which fields to include in the response.
Return All For "List Records", whether to return all matching results or limit the number returned.
Send Query Parameters For "List Records", whether to send query parameters to filter or modify the request.
Specify Query When sending query parameters, choose how to specify them: using key-value pairs or raw JSON.
Query Parameters When specifying query parameters as key-value pairs, add one or more name-value pairs to send.
JSON When specifying query parameters as JSON, provide the raw JSON string.
Limit For "List Records" when not returning all, the maximum number of records to return.
Fields to Send For "Create" and "Update" operations, specify one or more fields and their values to send in the request.

Output

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

  • For Get: A single record object containing the requested fields.
  • For List Records: An array of record objects, each including the selected fields.
  • For Create and Update: The created or updated record object.
  • For Delete: Typically a confirmation object indicating success.

If binary data were involved, it would be included in the output's binary property, but this node does not handle binary data in its current implementation.

Dependencies

  • Requires access to the Llana API endpoint.
  • Supports three authentication methods requiring appropriate credentials or tokens configured in n8n.
  • Uses helper functions (apiRequest, apiRequestAllItems) from bundled GenericFunctions to make HTTP requests.
  • Relies on dynamic loading of available tables and fields via getTables and getFields methods.

Troubleshooting

  • Invalid JSON in Query Parameters: When specifying query parameters as JSON, invalid JSON will cause an error. Ensure the JSON is well-formed.
  • Missing Required Fields: Operations like Get, Update, and Delete require a valid Record ID; omitting it will cause errors.
  • Authentication Failures: Incorrect or missing credentials will result in authorization errors. Verify that the correct authentication method and credentials are set.
  • Table or Field Not Found: Selecting a non-existent table or field may cause request failures. Use the provided load options to select valid entries.
  • Limit Exceeded: When not returning all records, setting a very high limit might cause performance issues or API rejections.

Links and References

Discussion