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 "Lark Sheets" provides integration with Lark's spreadsheet service, specifically allowing management of sheets and their components. The "Update Filter View" operation under the "Sheet Filter View" resource enables users to modify an existing filter view on a specified sheet within a spreadsheet.
This operation is useful when you want to programmatically update the filtering criteria or metadata (like the name or range) of a filter view without manually opening the spreadsheet UI. For example, automating updates to filter views based on changing data conditions or user preferences in collaborative environments.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authentication to use: either "Tenant Token" or "OAuth2". |
| Spreadsheet Token | The unique token identifying the target spreadsheet where the filter view exists. |
| Sheet Id | The identifier of the specific sheet within the spreadsheet that contains the filter view. |
| Filter View Id | The identifier of the filter view to be updated. |
| Filter View Name | (Optional) New name for the filter view. |
| Range | (Optional) New range string defining the area the filter view applies to. |
| Custom Body | JSON object allowing full customization of the request body sent to the API, overriding defaults. |
| Options > Use Custom Body | Boolean flag indicating whether to send the custom JSON body instead of standard parameters. |
Output
The node outputs JSON data representing the response from the Lark Sheets API after updating the filter view. This typically includes confirmation of the updated filter view details such as its ID, name, range, and any other metadata returned by the API.
If binary data were involved (not indicated here), it would represent file contents or attachments, but this operation deals solely with JSON metadata.
Dependencies
- Requires access to Lark Suite APIs via HTTP requests.
- Needs valid authentication credentials, either a tenant token or OAuth2 token, configured in n8n.
- The base URL for API calls is
https://open.larksuite.com/open-apis. - Proper permissions on the spreadsheet and sheet to update filter views.
Troubleshooting
- Invalid or missing tokens: Ensure the spreadsheet token, sheet ID, and filter view ID are correct and correspond to existing resources.
- Authentication errors: Verify that the selected authentication method is correctly configured and the token has not expired.
- API errors due to malformed input: If using the custom body option, ensure the JSON structure matches the expected API schema.
- Permission denied: The authenticated user must have edit rights on the spreadsheet and sheet.
- Network issues: Confirm connectivity to the Lark Suite API endpoint.
Common error messages might include:
- "Unauthorized" or "Authentication failed": Check credentials.
- "Not Found": Verify IDs for spreadsheet, sheet, and filter view.
- "Bad Request": Inspect the request body for invalid fields or formats.