Actions9
- Item Actions
- Worksheet Actions
Overview
The "Get Worksheet" operation for the "Worksheet" resource in this custom n8n node allows users to retrieve detailed information about a specific worksheet from the YOOV Lancode API. This is useful for automating workflows that require access to worksheet metadata, structure, or configuration within the YOOV platform.
Common scenarios:
- Fetching worksheet details to use in subsequent automation steps.
- Integrating worksheet data into reporting or dashboard tools.
- Validating worksheet existence or properties before performing further actions.
Practical example:
A user wants to pull the structure of a worksheet (such as its fields and settings) to dynamically build forms or validate data before inserting new records.
Properties
| Name | Meaning |
|---|---|
| Worksheet ID | The unique identifier of the worksheet to retrieve. Required to specify which worksheet's details to fetch. |
| Use Raw Output | If enabled, returns the raw API response instead of a simplified version. Options: true/false |
Output
- The output is a JSON object containing the worksheet's details as returned by the YOOV Lancode API.
- The structure of the output depends on whether "Use Raw Output" is enabled:
- Raw Output: The full, unprocessed API response.
- Default Output: A simplified or processed version of the worksheet details.
- Typical fields may include worksheet name, ID, components, and other metadata, but the exact structure mirrors the API's response.
Dependencies
- YOOV Lancode API: Requires access to the YOOV Lancode service.
- API Credentials: The node requires valid credentials (
lancodeApi) configured in n8n, including the API hostname. - n8n Configuration: No special environment variables are needed beyond standard credential setup.
Troubleshooting
Common issues:
- Missing or invalid Worksheet ID: If the "Worksheet ID" is not provided or incorrect, the node will not return any data.
- Authentication errors: Invalid or missing API credentials will result in authentication failures.
- API connectivity issues: Network problems or incorrect base URL can cause request failures.
Error messages and resolutions:
"error": "Worksheet ID is required": Ensure you have entered a valid Worksheet ID."error": "Request failed with status code 401": Check your API credentials and permissions."error": "Network Error": Verify network connectivity and the correctness of the API hostname.