feishu-bitable-query
Query Feishu Bitable (多维表格) with server-side filter, sort, field selection, and multiple output formats. Activate when querying bitable records with conditions, filtering multidimensional table data, or when data volume is large and client-side filtering is inefficient. Preferred over feishu_bitable_list_records tool when filter expressions or full pagination is needed.
Why use this skill?
Efficiently query and filter large Feishu Bitable datasets with this OpenClaw skill. Supports server-side filtering, custom formats, and automated pagination.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/deadblue22/feishu-bitable-queryWhat This Skill Does
The feishu-bitable-query skill provides a powerful command-line interface to interact with Feishu Bitable (多维表格) records. Unlike simple reading tools, this skill is specifically engineered for high-performance data operations. It supports server-side filtering, automatic pagination for large datasets, and multiple output formats including TSV and JSONL, making it ideal for processing tables with hundreds or thousands of rows without overwhelming the AI context window.
Installation
You can install this skill directly using the OpenClaw CLI:
clawhub install openclaw/skills/skills/deadblue22/feishu-bitable-query
Use Cases
- Bulk Data Analysis: Extracting large datasets from Bitable for downstream analysis in Python or shell scripts.
- Complex Filtering: Executing server-side logic (via filter expressions or JSON search objects) to retrieve only relevant records.
- Format Conversion: Quickly converting Bitable views into machine-readable JSONL or human-readable TSV format.
- Automated Reporting: Piping filtered record lists into other automation pipelines or reporting bots.
Example Prompts
- "Query the 'Project Tasks' table for all items where the status is 'In Progress' and export the results in TSV format."
- "Get a count of all records in the 'Inventory' table that were updated within the last 7 days."
- "Find all records in the 'Bug Tracker' table assigned to 'John Doe' where the 'Priority' is 'High' and output as JSONL."
Tips & Limitations
- Efficiency: Use the built-in view ID whenever possible to leverage existing sorting and filtering configurations set within the Feishu UI.
- Filtering Strategies: Use
--filterif you need to access full text for Link-type fields. Switch to--filter-json(POST Search API) when performing high-performance operations on large datasets where date-range filtering is required, keeping in mind that Link fields may return IDs instead of text. - Time Filters: Since the native Feishu API has limitations regarding date range comparisons, utilize the
--time-filterparameter for local, secondary filtering of date fields after the data has been retrieved. - Pagination: Always utilize the
--all-pagesflag when you need complete datasets, as the default behavior is capped to a single page per request.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-deadblue22-feishu-bitable-query": {
"enabled": true,
"auto_update": true
}
}
}Tags(AI)
Flags: external-api, network-access
Related Skills
feishu-comments
Read comments from Feishu documents. Use when: user asks to check/read/fetch comments on a Feishu doc, review feedback on a document, or collaborate on document revisions via comments.
feishu-api-lookup
Look up Feishu Open API documentation. Activate when: needing to find a specific Feishu API endpoint, understanding API parameters/response, writing scripts that call Feishu APIs, or troubleshooting Feishu API errors. Uses web_search + web_fetch to find and extract API docs in real-time.
feishu-thread-forward
Forward Feishu thread/topic to a user, group, or topic via REST API. Activate when: forwarding a thread/topic to another chat, sharing a topic post to a different group, or any scenario involving Feishu thread-level forwarding (转发话题). The built-in feishu message tool does NOT support thread forwarding — this skill fills that gap.
feishu-doc-sync
飞书文档增量同步与表格操作指南。覆盖：表格更新策略（delete+insert）、header_row 设置、insert action、列宽算法、三阶段 diff 同步。当需要同步本地文档到飞书、操作飞书表格、或做增量编辑时激活。
feishu-merged-msg
Fetch and parse Feishu merged/forwarded messages (合并转发消息). Activate when a Feishu message shows "Merged and Forwarded Message" with no readable content, or when you need to retrieve sub-messages from a merge_forward message type.