Result Bitable Reporter

Use this skill to run a deterministic sqlite -> Feishu Bitable pipeline around capture_results.

Workflow

Select rows

stat: print total sqlite row count for one --task-id.
filter: preview upload candidates from capture_results.
Default status filter is reported IN (0,-1).

Report rows

report: batch create to Feishu Bitable and write back sqlite status.
--max-rows <n> sets total cap for one report run.
For per-task workflows, always pass --task-id <TASK_ID> to avoid cross-task uploads.
Success writeback: reported=1, reported_at=now_ms, report_error=NULL.
Failure writeback: reported=-1, reported_at=now_ms, report_error=<truncated error>.

Retry failures

retry-reset: move failed rows (reported=-1) back to pending (reported=0), then rerun report.

Run

npx tsx scripts/result_reporter.ts <subcommand> [flags]

Use npx tsx scripts/result_reporter.ts --help as the CLI source of truth.

Environment Variables

Required for report:

FEISHU_APP_ID
FEISHU_APP_SECRET
RESULT_BITABLE_URL

Optional overrides:

FEISHU_BASE_URL (default https://open.feishu.cn)
TRACKING_STORAGE_DB_PATH (default $HOME/.eval/records.sqlite)
RESULT_SQLITE_TABLE (default capture_results)

Recommended Command Patterns

Task-scoped preview:

npx tsx scripts/result_reporter.ts filter --task-id <TASK_ID> --status 0,-1 --limit 20

Task-scoped report:

export FEISHU_APP_ID=<app_id>
export FEISHU_APP_SECRET=<app_secret>
export RESULT_BITABLE_URL='https://.../wiki/...?...table=tbl_xxx&view=vew_xxx'
npx tsx scripts/result_reporter.ts report --task-id <TASK_ID> --batch-size 100 --max-rows 500

Retry failed rows:

npx tsx scripts/result_reporter.ts retry-reset --app com.tencent.mm --scene onSearch
npx tsx scripts/result_reporter.ts report --task-id <TASK_ID> --status 0,-1

Failure Handling

Use report --dry-run to validate selection before network writes.
Check sqlite report_error for root cause when reported=-1.
Fix root cause, then rerun retry-reset and report.

Resources

scripts/result_reporter.ts: CLI behavior and flags.
references/sqlite-and-field-mapping.md: sqlite schema and field mapping.
references/feishu-api-and-errors.md: Feishu API contract and error triage.

result-bitable-reporter