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
This node interacts with Lark Sheets, specifically focusing on managing filter conditions within a filter view of a spreadsheet. The "Query Filter Conditions" operation under the "Filter Condition Filter View" resource allows users to retrieve the filter conditions applied in a particular filter view of a sheet.
Common scenarios for this node include:
- Automating the retrieval of filter criteria from a shared spreadsheet to dynamically adjust data processing workflows.
- Auditing or logging current filter settings applied by collaborators in a spreadsheet.
- Integrating filter condition data into other systems for reporting or validation purposes.
For example, a user might want to fetch all active filter conditions on a sales report sheet to generate customized summaries or alerts based on filtered data.
Properties
| Name | Meaning |
|---|---|
| Authentication | Method of authenticating API requests; options are "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 whose filter conditions are being queried. |
| Options | Additional optional settings: |
| - Use Custom Body | Boolean flag indicating whether to send a custom request body (true/false). |
Output
The node outputs JSON data representing the filter conditions retrieved from the specified filter view. This typically includes details such as the columns involved, the type of filters applied (e.g., text contains, number greater than), and the values or ranges used in those filters.
If binary data were involved (not indicated here), it would represent file contents or attachments, but this node focuses solely on JSON structured filter condition data.
Dependencies
- Requires access to the Lark Suite API endpoint at
https://open.larksuite.com/open-apis. - Needs an API authentication credential, either a Tenant Token or OAuth2 token, configured in n8n.
- Proper permissions on the target spreadsheet to read filter views and their conditions.
Troubleshooting
- Authentication errors: Ensure that the selected authentication method is correctly configured with valid credentials and has permission to access the spreadsheet.
- Invalid Spreadsheet Token, Sheet Id, or Filter View Id: Double-check these identifiers for typos or outdated values. They must correspond exactly to existing resources in Lark Sheets.
- API rate limits or connectivity issues: If requests fail intermittently, verify network connectivity and consider API usage limits imposed by Lark Suite.
- Use Custom Body option misuse: Setting "Use Custom Body" to true without providing a proper body may cause request failures. Only enable if you intend to customize the request payload.