List Records
AI-generatedOverview
This node integrates with the Llana API to perform various record management operations on specified tables. The "List Records" operation allows users to retrieve multiple records from a chosen table, optionally filtering and limiting the results.
Common scenarios for this node include:
- Fetching data from a database or service managed by Llana for reporting or further processing.
- Synchronizing records between Llana and other systems.
- Querying specific subsets of data using flexible query parameters.
For example, a user might list all customer records from a "Customers" table, optionally specifying fields like "Name" and "Email", and applying filters such as "Country = USA".
Properties
| Name | Meaning |
|---|---|
| Authentication | Method used to authenticate requests. Options: API Key, Username & Password, Host API. |
| Table Name or ID | The target table from which to list records. Can be selected from a dropdown or specified via an expression. |
| Fields | Specific fields/columns to include in the response. Multiple fields can be selected. |
| Return All | Whether to return all matching records or limit the number of results. |
| Send Query Parameters | Whether to include query parameters in the request to filter or modify the returned data. |
| Specify Query Parameters | How to specify query parameters when sending them: either as key-value pairs ("Using Fields Below") or as raw JSON ("Using JSON"). |
| Query Parameters | When specifying query parameters as key-value pairs, these are the individual parameters to send. Each parameter has a name and value. |
| JSON | When specifying query parameters as JSON, this is the raw JSON string representing the query parameters. Must be valid JSON. |
| Limit | Maximum number of records to return when not returning all. Minimum value is 1. Defaults to 50. |
Output
The node outputs an array of JSON objects representing the retrieved records. Each object corresponds to one record from the specified table and includes the requested fields.
If binary data were involved (not applicable here), it would be included in the output's binary property, but this operation deals only with JSON data.
Dependencies
- Requires access to the Llana API endpoint.
- Requires appropriate authentication credentials depending on the selected method (API key, username/password, or host API).
- Uses helper functions to load available tables and fields dynamically.
- No additional external dependencies beyond standard n8n workflow environment.
Troubleshooting
- Invalid JSON in Query Parameters: If specifying query parameters as JSON, ensure the JSON is valid. The node throws an error if parsing fails.
- Missing Required Fields: The "Table Name or ID" is required; omitting it will cause errors.
- Authentication Errors: Ensure correct credentials are provided according to the selected authentication method.
- Limit Exceeded: If not returning all records, the limit must be at least 1; setting invalid limits may cause errors.
- Empty Results: If no records match the query parameters, the output will be an empty array.
Links and References
- n8n Expressions Documentation
- Llana API documentation (not provided here; refer to your Llana API docs for details on endpoints and query parameters)