YOOV Lancode icon

YOOV Lancode

Interact with Lancode API
Join our community

Actions9

Overview

The YOOV Lancode n8n node allows you to interact with the YOOV Lancode API, specifically for managing items (records) within a worksheet.
For the Resource: Item and Operation: Get, this node retrieves a single row (item) from a specified worksheet by its Row ID.
This is useful in scenarios where you need to fetch detailed information about a specific record, such as looking up user data, order details, or any custom entity stored in a YOOV Lancode worksheet.

Practical examples:

  • Retrieve customer details by their unique Row ID for further processing.
  • Fetch an order's information to send a notification or trigger another workflow.
  • Look up a support ticket's data for reporting or escalation.

Properties

Name Meaning
Worksheet ID The unique identifier of the worksheet containing the item you want to retrieve.
Row ID The unique identifier of the row (item) to fetch from the worksheet.
Use Raw Output If enabled, returns the raw API response instead of a simplified version. (true/false)

Output

  • The output will be a JSON object representing the requested item (row) from the worksheet.
  • The structure of the output depends on the worksheet's schema and the "Use Raw Output" setting:
    • If Use Raw Output is enabled, the output will match the raw response from the YOOV Lancode API.
    • Otherwise, it will be a simplified version suitable for downstream n8n nodes.
  • Example output (structure may vary):
{
  "id": "row_12345",
  "fields": {
    "Name": "John Doe",
    "Email": "john@example.com",
    "Status": "Active"
  },
  "createdAt": "2024-06-01T12:00:00Z",
  "updatedAt": "2024-06-05T09:30:00Z"
}

Dependencies

  • External Service: Requires access to the YOOV Lancode API.
  • Authentication: Needs valid credentials configured in n8n under the name lancodeApi.
  • n8n Configuration: The hostname for the API must be set in the credentials.

Troubleshooting

Common Issues:

  • Missing or incorrect Worksheet ID / Row ID:
    • Error: "Worksheet ID is required" or "Row ID is required"
    • Solution: Ensure both IDs are provided and correct.
  • Invalid credentials or missing authentication:
    • Error: Authentication errors from the API.
    • Solution: Check that the lancodeApi credential is correctly set up in n8n.
  • API errors (e.g., item not found):
    • Error: "Item not found" or similar messages in the output.
    • Solution: Verify that the Row ID exists in the specified worksheet.

Error Handling:

  • If "Continue On Fail" is enabled, errors will be returned in the output as { "error": "Error message" }.

Links and References

Discussion