Table, row, and report commands

Identity

API-backed tables, rows, and api command groups.

Contract

• rows list <table> accepts --limit, --page, --sort, --q, and JSON --where.
• rows get <table> <id> reads one visible row.
• rows count <table> counts visible rows without loading complete records. It accepts JSON --where and optional --group-by <column>. Grouped counts accept --order asc|desc and --limit <number>; both options require --group-by.
• rows create <table> --values <json> accepts one object or an array.
• rows update <table> <id> --values <json> updates one visible row; rows delete removes one.
• A scalar count renders one count column. A grouped count renders value and count columns. JSON output preserves the HTTP result’s discriminated total or grouped envelope.
• Report routes are called through api get or api post; there is no separate reports command group.

Related documentation

• Use the agent data console
• Count visible rows