Actions9
- Item Actions
- Worksheet Actions
Overview
The Worksheet → List Views operation in the YOOV Lancode n8n node retrieves a list of all views associated with a specified worksheet. This is useful for automation scenarios where you need to dynamically access, display, or process different worksheet views—such as filtering data, generating reports, or building user interfaces that allow users to select from available worksheet views.
Practical examples:
- Fetching all available views for a worksheet to let users pick which view to use in subsequent workflow steps.
- Automating processes that depend on the structure or filters defined in specific worksheet views.
Properties
| Name | Meaning |
|---|---|
| Worksheet ID | The unique identifier of the worksheet whose views you want to list. |
| Use Raw Output | If enabled, returns the raw API response instead of a simplified object structure. |
Output
The output is a JSON array where each item represents a view of the specified worksheet. Each object typically contains:
[
{
"id": "<view_id>",
"name": "<view_name>",
// ...other possible fields depending on the API and 'Use Raw Output' setting
}
]
- If Use Raw Output is enabled, the structure may include additional fields as returned by the underlying API.
Dependencies
- YOOV Lancode API: Requires valid credentials configured in n8n under the name
lancodeApi. - n8n Configuration: The node must be set up with the correct hostname and authentication details for the YOOV Lancode service.
Troubleshooting
Common issues:
- Missing or invalid Worksheet ID: If the Worksheet ID is not provided or incorrect, no views will be returned.
- Authentication errors: Invalid or missing API credentials will result in authentication failures.
- API connectivity issues: Network problems or incorrect base URL configuration can prevent successful API calls.
Error messages:
"error": "<message>"— If an error occurs and "Continue On Fail" is enabled, the error message will appear in the output'serrorfield. Check the message for clues (e.g., "Worksheet not found", "Unauthorized") and verify your input and credentials.