Actions23
- Spreadsheet Actions
- Sheet Filter Actions
- Sheet Filter View Actions
- Filter Condition Filter View Actions
- Sheet Row Column Actions
- Sheet Data Actions
- Sheet Floating Image Actions
Overview
The "Lark Sheets" node provides integration with Lark's spreadsheet service, enabling users to manage and interact with spreadsheets programmatically. Specifically, the "Sheet Filter" resource with the "Obtain Filter" operation allows users to retrieve filter settings applied on a particular sheet within a spreadsheet.
This node is beneficial in scenarios where automated workflows need to read or process filtered data from Lark Sheets, such as generating reports based on filtered views, syncing filtered data with other systems, or triggering actions when certain filters are applied.
For example, a user might configure this node to obtain the current filter criteria on a sales report sheet to dynamically adjust downstream processing or notifications based on those filters.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authenticating API requests. Options: Tenant Token, OAuth2 |
| Spreadsheet Token | The unique token identifying the target spreadsheet |
| Sheet Id | The identifier of the specific sheet within the spreadsheet |
| Options | Additional optional settings |
| - Use Custom Body | Boolean flag indicating whether to send a custom request body instead of default behavior |
Output
The node outputs JSON data representing the filter configuration of the specified sheet. This typically includes details about which columns are filtered, the filter criteria applied, and possibly metadata about the filter state.
If the node supports binary data output (not indicated here), it would represent any associated files or attachments related to the filter operation, but based on the provided code and properties, the output is purely JSON structured data describing the sheet filter.
Dependencies
- Requires authentication via either a tenant token or OAuth2 credentials for Lark Suite API access.
- Depends on connectivity to the Lark Suite Open APIs endpoint (
https://open.larksuite.com/open-apis). - No additional external dependencies beyond standard HTTP requests to Lark's API.
Troubleshooting
- Authentication Errors: Ensure that the correct authentication method is selected and valid credentials are provided. Expired or invalid tokens will cause authorization failures.
- Invalid Spreadsheet Token or Sheet Id: Verify that the spreadsheet token and sheet ID correspond to existing resources accessible by the authenticated user.
- API Rate Limits: Excessive requests may trigger rate limiting; implement retries or backoff strategies if needed.
- Use Custom Body Misconfiguration: If "Use Custom Body" is enabled without providing a proper body structure, the request may fail. Ensure the custom body matches the expected API schema.