# Result Bitable Reporter

> Filter rows from sqlite capture_results and report to Feishu Bitable with retry-safe sqlite writeback. Use for stat/filter/report/retry-reset workflows, especially task-scoped reporting with --task-id.

- **Type:** Skill
- **Install:** `agentstack add skill-httprunner-skills-result-bitable-reporter`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [httprunner](https://agentstack.voostack.com/s/httprunner)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [httprunner](https://github.com/httprunner)
- **Source:** https://github.com/httprunner/skills/tree/main/result-bitable-reporter

## Install

```sh
agentstack add skill-httprunner-skills-result-bitable-reporter
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Result Bitable Reporter

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

## Workflow

1) 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)`.

2) Report rows
- `report`: batch create to Feishu Bitable and write back sqlite status.
- `--max-rows ` sets total cap for one report run.
- For per-task workflows, always pass `--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=`.

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

## Run

```bash
npx tsx scripts/result_reporter.ts  [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:

```bash
npx tsx scripts/result_reporter.ts filter --task-id  --status 0,-1 --limit 20
```

Task-scoped report:

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

Retry failed rows:

```bash
npx tsx scripts/result_reporter.ts retry-reset --app com.tencent.mm --scene onSearch
npx tsx scripts/result_reporter.ts report --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.

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [httprunner](https://github.com/httprunner)
- **Source:** [httprunner/skills](https://github.com/httprunner/skills)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-httprunner-skills-result-bitable-reporter
- Seller: https://agentstack.voostack.com/s/httprunner
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.