feishu-api-bitable飞书多维表格(Bitable)API技能。用于创建、读取、更新和删除飞书多维表格的数据表、记录和字段。
Install via ClawdBot CLI:
clawdbot install StevenLikeWatermelon/feishu-api-bitable用于操作飞书多维表格的完整技能,支持数据表、记录和字段的CRUD操作。
# 飞书应用ID
export FEISHU_APP_ID=cli_xxxxxx
# 飞书应用密钥(或密钥文件路径)
export FEISHU_APP_SECRET=your_app_secret
# 或
export FEISHU_APP_SECRET_PATH=~/.clawdbot/secrets/feishu_app_secret
cd skills/feishu-bitable
npm install
export FEISHU_APP_ID=cli_xxxxxx
export FEISHU_APP_SECRET=your_app_secret
# 获取帮助
node bitable-cli.js --help
# 列出所有数据表
node bitable-cli.js list-tables --app-token basxxxxxx
# 创建新记录
node bitable-cli.js create-record --app-token basxxxxxx --table-id tblxxxxxx --data '{"字段1": "值1", "字段2": "值2"}'
# 查询记录
node bitable-cli.js list-records --app-token basxxxxxx --table-id tblxxxxxx
GET /bitable/v1/apps/{app_token}/tables - 获取数据表列表POST /bitable/v1/apps/{app_token}/tables - 创建数据表GET /bitable/v1/apps/{app_token}/tables/{table_id} - 获取数据表详情DELETE /bitable/v1/apps/{app_token}/tables/{table_id} - 删除数据表POST /bitable/v1/apps/{app_token}/tables/{table_id}/records - 新增记录GET /bitable/v1/apps/{app_token}/tables/{table_id}/records - 获取记录列表PUT /bitable/v1/apps/{app_token}/tables/{table_id}/records/{record_id} - 更新记录DELETE /bitable/v1/apps/{app_token}/tables/{table_id}/records/{record_id} - 删除记录POST /bitable/v1/apps/{app_token}/tables/{table_id}/records/batch_create - 批量新增记录POST /bitable/v1/apps/{app_token}/tables/{table_id}/records/batch_update - 批量更新记录POST /bitable/v1/apps/{app_token}/tables/{table_id}/records/batch_delete - 批量删除记录GET /bitable/v1/apps/{app_token}/tables/{table_id}/fields - 获取字段列表POST /bitable/v1/apps/{app_token}/tables/{table_id}/fields - 创建字段PUT /bitable/v1/apps/{app_token}/tables/{table_id}/fields/{field_id} - 更新字段GET /bitable/v1/apps/{app_token}/tables/{table_id}/views - 获取视图列表GET /bitable/v1/apps/{app_token}/tables/{table_id}/views/{view_id} - 获取视图详情node bitable-cli.js create-table \
--app-token basxxxxxx \
--name "任务管理" \
--fields '[{"field_name": "任务名称", "type": "text"}, {"field_name": "状态", "type": "select", "property": {"options": [{"name": "待办"}, {"name": "进行中"}, {"name": "已完成"}]}}]'
node bitable-cli.js create-record \
--app-token basxxxxxx \
--table-id tblxxxxxx \
--data '{"任务名称": "完成API开发", "状态": "进行中", "优先级": "高", "截止日期": "2024-12-31"}'
node bitable-cli.js list-records \
--app-token basxxxxxx \
--table-id tblxxxxxx \
--filter '{"conjunction": "and", "conditions": [{"field_name": "状态", "operator": "is", "value": ["进行中"]}]}' \
--sort '["-创建时间"]' \
--page-size 50
node bitable-cli.js batch-create \
--app-token basxxxxxx \
--table-id tblxxxxxx \
--data-file records.json
飞书多维表格支持以下字段类型:
text - 文本number - 数字single_select - 单选multi_select - 多选date - 日期person - 人员checkbox - 复选框url - 链接phone - 电话email - 邮箱attachment - 附件formula - 公式created_time - 创建时间modified_time - 修改时间created_by - 创建人modified_by - 修改人技能包含完整的错误处理机制:
bitable:record:readonly和bitable:record:write权限skills/feishu-bitable 目录用户: "帮我在飞书多维表格中添加一个任务"
Clawdbot:
# 使用技能添加任务
node skills/feishu-bitable/bin/cli.js create-record \
--app-token basxxxxxx \
--table-id tblxxxxxx \
--data '{"任务名称": "新任务", "状态": "待办", "优先级": "中"}'
你可以创建自动化工作流,例如:
如需扩展功能,请参考:
src/api.js - API客户端src/cli.js - 命令行接口src/utils.js - 工具函数src/api.js 的 FeishuBitableAPI 类中添加新方法bin/cli.js 中添加对应的命令try-catch 包装所有API调用Generated Mar 1, 2026
Automates task tracking and status updates in Feishu Bitable for project teams. Teams can create, update, and query tasks via CLI commands, integrating with workflows to sync data from tools like Jira or Trello, reducing manual entry and improving real-time visibility.
Manages customer data, interactions, and sales pipelines using Feishu Bitable as a lightweight CRM. Sales teams can add leads, update deal stages, and generate reports through API calls, enabling seamless data import from forms or email campaigns for centralized tracking.
Tracks inventory levels, orders, and shipments in Feishu Bitable for small to medium businesses. Users can create records for stock items, update quantities via batch operations, and set up automated alerts for low stock, facilitating real-time monitoring and reducing errors.
Streamlines HR processes by managing employee records, onboarding tasks, and performance reviews in Feishu Bitable. HR departments can create tables for new hires, update statuses, and automate data sync with other systems, improving efficiency and compliance tracking.
Handles event registrations, attendee lists, and feedback collection using Feishu Bitable. Organizers can create records for participants, update attendance via API, and export data for analysis, integrating with ticketing platforms to automate data flow and reduce manual work.
Offers a service that integrates Feishu Bitable with other SaaS platforms like CRM or ERP systems. Businesses pay a subscription fee for automated data sync, custom API endpoints, and support, generating recurring revenue from clients seeking streamlined workflows.
Provides consulting and development services to help companies implement and customize Feishu Bitable automation. Revenue comes from project-based fees for setting up tables, workflows, and CLI tools, targeting enterprises needing tailored solutions for specific use cases.
Sells training workshops and support packages to educate teams on using the Feishu Bitable skill effectively. Revenue is generated from one-time training fees or ongoing support contracts, appealing to organizations adopting the tool for internal automation and data management.
💬 Integration Tip
Set up environment variables securely and test API calls with sample data before scaling to avoid rate limits and ensure proper permissions.
CLI to manage emails via IMAP/SMTP. Use `himalaya` to list, read, write, reply, forward, search, and organize emails from the terminal. Supports multiple accounts and message composition with MML (MIME Meta Language).
Read and send email via IMAP/SMTP. Check for new/unread messages, fetch content, search mailboxes, mark as read/unread, and send emails with attachments. Works with any IMAP/SMTP server including Gmail, Outlook, 163.com, vip.163.com, 126.com, vip.126.com, 188.com, and vip.188.com.
Gmail API integration with managed OAuth. Read, send, and manage emails, threads, labels, and drafts. Use this skill when users want to interact with Gmail. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
Automatically logs into email accounts (Gmail, Outlook, QQ Mail, etc.) and generates daily email summaries. Use when the user wants to get a summary of their emails, check important messages, or create daily email digests.
Fetch content from Feishu (Lark) Wiki, Docs, Sheets, and Bitable. Automatically resolves Wiki URLs to real entities and converts content to Markdown.
Manage Feishu (Lark) calendars by listing, searching, checking schedules, syncing events, and marking tasks with automated date extraction.