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 node provides integration with Lark Sheets, specifically allowing management of sheet filter views. The "Delete Filter View" operation enables users to remove a specific filter view from a given sheet within a spreadsheet. This is useful in scenarios where outdated or unnecessary filter views need to be cleaned up programmatically, such as automating maintenance of shared spreadsheets or dynamically adjusting views based on workflow conditions.
Practical examples:
- Automatically deleting temporary filter views created during data processing workflows.
- Cleaning up user-created filter views after a reporting period ends.
- Managing access and visibility by removing filter views no longer relevant to collaborators.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authentication to use: either "Tenant Token" or "OAuth2". |
| Spreadsheet Token | The unique token identifying the target spreadsheet. |
| Sheet Id | The identifier of the specific sheet within the spreadsheet where the filter view exists. |
| Filter View Id | The identifier of the filter view to delete. |
| Options | Additional options for the request. Currently supports: |
| - Use Custom Body | Boolean flag indicating whether to send a custom request body (not typically needed). |
Output
The node outputs JSON data representing the response from the Lark Sheets API after attempting to delete the specified filter view. Typically, this will include status information confirming success or details about any error encountered.
No binary data output is involved in this operation.
Dependencies
- Requires an active connection to Lark Suite APIs.
- Needs either a Tenant Token or OAuth2 credentials configured in n8n for authentication.
- Network access to
https://open.larksuite.com/open-apisis necessary.
Troubleshooting
Common issues:
- Invalid or expired authentication tokens leading to authorization errors.
- Incorrect spreadsheet, sheet, or filter view IDs causing "not found" errors.
- Insufficient permissions for the authenticated user to modify the sheet.
Error messages and resolutions:
- 401 Unauthorized: Check that the provided authentication token is valid and has not expired.
- 404 Not Found: Verify that the spreadsheet token, sheet ID, and filter view ID are correct.
- 403 Forbidden: Ensure the authenticated user has permission to delete filter views on the target sheet.