Actions31
- Option Set Actions
- Public Query Actions
- Record Actions
- Role Actions
- Workflow Actions
- Worksheet Actions
Overview
This node interacts with the HAP (Hyper Application Platform) API to retrieve the structure of a specific worksheet. It is useful when you need to understand or manipulate the schema, fields, or configuration of a worksheet within the HAP system. For example, you might use this node to fetch the layout and metadata of a worksheet before performing data operations or generating reports based on its structure.
Properties
| Name | Meaning |
|---|---|
| Worksheet ID | The ID of the worksheet to get the structure for |
Output
The node outputs JSON data representing the structure of the specified worksheet. This typically includes details such as field definitions, data types, layout information, and other configuration metadata that describe how the worksheet is organized. The output does not include binary data.
Dependencies
- Requires an API key credential to authenticate with the HAP API.
- The node expects the HAP API endpoint to be accessible and properly configured in n8n.
- No additional external dependencies are indicated.
Troubleshooting
Common issues:
- Invalid or missing Worksheet ID: Ensure the Worksheet ID provided is correct and exists in the HAP system.
- Authentication errors: Verify that the API key credential is valid and has sufficient permissions.
- Network or API availability issues: Confirm that the HAP API service is reachable from your n8n instance.
Error messages:
- "Unauthorized" or "Authentication failed": Check API credentials.
- "Worksheet not found": Verify the Worksheet ID.
- Timeout or connection errors: Check network connectivity and API status.
Links and References
- HAP (Hyper Application Platform) official documentation (example placeholder link)