Actions9
- Item Actions
- Worksheet Actions
Overview
This node interacts with the YOOV Lancode API, specifically focusing on worksheet resources. For the Worksheet resource and the Get Selection Field Options operation, the node retrieves the available options for a selection-type field within a specified worksheet. This is useful when you need to dynamically fetch possible values (such as dropdown or multi-select options) for a particular field in a worksheet, enabling automation scenarios like populating user interfaces, validating data, or mapping selections in workflows.
Practical Example:
Suppose you have a worksheet in YOOV Lancode that tracks project statuses using a single-select field. You can use this node operation to fetch all possible status options, then present them in another system or validate incoming data against these options.
Properties
| Name | Meaning |
|---|---|
| Worksheet ID | The unique identifier of the worksheet from which to retrieve the selection field options. |
| Field Name or ID | The name or ID of the selection field whose options you want to fetch. You can choose from a list or specify an ID using an expression. |
| Use Raw Output | If enabled, returns the raw response from the API instead of a simplified version. |
Output
The output is a JSON array containing the available options for the specified selection field. Each option typically includes:
[
{
"name": "Option Display Name",
"value": "Option ID"
}
]
name: The display name of the selection option.value: The internal ID of the selection option.
If an error occurs and "Continue On Fail" is enabled, the output will include an object like:
{
"error": "Error message"
}
Dependencies
- YOOV Lancode API: Requires valid credentials configured in n8n under the name
lancodeApi. - API Key/Hostname: Must be set up in the n8n credentials for the node to authenticate requests.
Troubleshooting
- Missing Worksheet ID or Field ID: If either the worksheet ID or the selection field ID is missing or incorrect, the node will not return any options or may throw an error.
- Invalid Credentials: If the API credentials are not set up correctly, authentication errors will occur.
- Common Error Messages:
"Cannot read property 'components' of undefined": Likely due to an invalid worksheet ID."Field not found": The specified field ID does not exist in the worksheet."Request failed with status code 401": Authentication issue; check your credentials.
Resolution: Double-check the worksheet and field IDs, ensure credentials are correct, and verify that the field is of a selection type.