YOOV Lancode icon

YOOV Lancode

Interact with Lancode API
Join our community

Actions9

Overview

The YOOV Lancode node for n8n allows you to interact with the YOOV Lancode API, specifically to list items from a worksheet. The "Item: List" operation retrieves records (items) from a specified worksheet and view, supporting filtering, pagination, and keyword search. This is useful for automating data extraction, reporting, or integrating YOOV Lancode data into other workflows.

Practical examples:

  • Fetching all customer records from a CRM worksheet for further processing.
  • Listing tasks from a project management worksheet filtered by status or assigned user.
  • Paginating through large datasets in YOOV Lancode for batch processing.

Properties

Name Meaning
Worksheet ID The unique identifier of the worksheet from which to list items. Required to specify the data source.
View Name or ID The name or ID of the worksheet view to use for listing items. You can select from available views or provide an ID via expression.
Additional Options A collection of optional parameters to refine the query:
- Filters: JSON array of filter conditions.
- Page No: Page number for pagination (default: 1).
- No of Items: Number of items per page (1–1000, default: 100).
- Keywords: Search keywords to filter results.
Use Raw Output If enabled, returns the raw API response instead of a simplified version.

Output

  • The output is a JSON array where each element represents an item (record) from the specified worksheet and view.
  • Each item contains fields as defined in the worksheet schema.
  • If "Use Raw Output" is enabled, the structure matches the raw response from the YOOV Lancode API.
  • In case of errors and if "Continue On Fail" is enabled, the output will include an object like:
    { "error": "Error message here" }

Dependencies

  • YOOV Lancode API: Requires valid credentials configured in n8n under the "lancodeApi" credential type.
  • n8n Configuration: The base URL for the API is taken from the credentials (hostname field).

Troubleshooting

Common issues:

  • Missing or invalid Worksheet ID: If not provided or incorrect, no items will be returned.
  • Invalid View ID: If the view does not exist, the API may return an error or empty result.
  • API Authentication Errors: Invalid or expired credentials will cause authentication failures.
  • Filter Syntax Errors: Malformed JSON in filters can lead to request errors.

Error messages:

  • "Cannot read property '...' of undefined": Likely due to missing required properties such as Worksheet ID or View ID.
  • "Request failed with status code 401": Check your API credentials.
  • "Invalid filter format": Ensure that the Filters option is a valid JSON array.

Links and References

Discussion