YOOV Lancode icon

YOOV Lancode

Interact with Lancode API

Actions9

Worksheet → List Fields

AI-generated

Overview

The YOOV Lancode node for n8n allows you to interact with the YOOV Lancode API, specifically to manage and retrieve information about worksheets and their fields.
For the Resource: Worksheet and Operation: List Fields, this node retrieves a list of all fields (columns) defined in a specified worksheet. This is useful when you need to dynamically discover or map worksheet structure before performing further operations such as reading, updating, or creating items.

Common scenarios:

  • Automating data integration workflows where you need to know the available fields in a worksheet.
  • Building dynamic forms or mapping logic based on worksheet structure.
  • Validating or synchronizing external data sources with YOOV Lancode worksheets.

Example:
You want to fetch all field definitions from a worksheet to display them in a dropdown for user selection in subsequent workflow steps.

Properties

Name Meaning
Worksheet ID The unique identifier of the worksheet whose fields you want to list.
Use Raw Output If enabled, returns the raw API response; otherwise, returns a simplified field listing.

Output

The output is an array of objects, each representing a field in the worksheet. Each object contains:

[
  {
    "name": "Field Display Name",
    "value": "Field ID"
  }
]
  • name: The display name of the field.
  • value: The unique identifier of the field.

If "Use Raw Output" is enabled, the output may include additional metadata as returned by the API.

Dependencies

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

Troubleshooting

Common issues:

  • Missing or invalid Worksheet ID: If the Worksheet ID is not provided or incorrect, no fields will be returned.
  • Authentication errors: Invalid or missing API credentials will result in authentication failures.
  • API connectivity issues: Network problems or incorrect API base URL can cause request failures.

Error messages:

  • "error": "<message>" — If an error occurs and "Continue On Fail" is enabled, the error message will appear in the output under the error key.
  • If "Continue On Fail" is not enabled, the workflow will stop and display the error in the n8n UI.

How to resolve:

  • Double-check the Worksheet ID.
  • Ensure your API credentials are correct and have sufficient permissions.
  • Verify network connectivity and API endpoint configuration.

Links and References

Discussion