Feishu Data

Feishu Data Tool

Unified read/write tool for Feishu spreadsheets and bitables. Complements the feishu-mcp (which handles docx/wiki/whiteboard/folder/image).

Capability Map

Prerequisites

• Python 3.8+, requests library
• Environment variables: FEISHU_APP_ID and FEISHU_APP_SECRET

Subcommands

read — Read sheet or bitable content

python scripts/feishu_data.py read --url "https://befriends.feishu.cn/wiki/xxxxx"
python scripts/feishu_data.py read --url "https://befriends.feishu.cn/sheets/shtcnXXX"
python scripts/feishu_data.py read --url "https://befriends.feishu.cn/wiki/xxx" --table tblXXX
python scripts/feishu_data.py read --url "..." -o result.md

Output: markdown tables with record_id column for bitables.

list-tables — List tables in a bitable

python scripts/feishu_data.py list-tables --url "https://befriends.feishu.cn/wiki/xxxxx"

Output: table of table_id | name | revision.

search — Search records with filter

python scripts/feishu_data.py search --url "..." --table tblXXX \
  --filter '{"conjunction":"and","conditions":[{"field_name":"状态","operator":"is","value":["进行中"]}]}'

Filter format follows Feishu Bitable Search API.

create — Batch create records

# Single record
python scripts/feishu_data.py create --url "..." --table tblXXX \
  --records '{"任务名称":"测试任务","状态":"待开始"}'

# Multiple records
python scripts/feishu_data.py create --url "..." --table tblXXX \
  --records '[{"任务名称":"任务A"},{"任务名称":"任务B"}]'

Field names must match the bitable column names exactly.

update — Update a single record

python scripts/feishu_data.py update --url "..." --table tblXXX \
  --record-id recXXXXX \
  --fields '{"状态":"已完成","备注":"done"}'

delete — Batch delete records

python scripts/feishu_data.py delete --url "..." --table tblXXX \
  --record-ids "recAAA,recBBB,recCCC"

Wiki-mounted Bitables

For bitables accessed via wiki URLs (/wiki/xxx), the tool automatically resolves the wiki node to get the underlying obj_token (app_token). No extra steps needed.

Troubleshooting

Integration Notes

• feishu_data.py is the unified entry point with subcommands
• Auth via FEISHU_APP_ID + FEISHU_APP_SECRET environment variables
• Companion to feishu-mcp npm package (handles docx/wiki/folder/image)