query

KPI Scorecard

Workflow #9 — the L10 cross-system scorecard: 7 KPIs (cash, AR, AP, pipeline, open SO/PO, NWC) with target/status. Optional bounded publish to Smartsheet.

QueryQuery — direct request/responsetool: kpi_scorecard

Overview

MCP tool kpi_scorecard — agent-callable, read-only. Handled by ScorecardService — KPI scorecard workflowScorecardService — KPI scorecard workflowServicev0.1.0Workflow #9 — the L10 scorecard: 7 KPIs assembled from QBO, Fishbowl and ClaritySoft, with an optional bounded publish (...Publishesaccounting-read, inventory-read +3Subscribeskpi-scorecardOwnervisionary-engineeringMapRepoView docs — its page shows this workflow’s exact vendor fan-out. Watch the full lifecycle: KPI Scorecard — tool-call lifecycleKPI Scorecard — tool-call lifecycleFlowv0.1.0One kpi_scorecard call end to end: four sources fold into 7 KPIs; with publish: true the service performs the one direct...Ownervisionary-engineeringView flowView docs.

Read-only by default; returns ScorecardView (Kpi entries with source and green/yellow/red status). While Fishbowl is absent the two order-book KPIs are omitted (never zero-filled) and unavailableSources marks the gap.

With publish: true it appends a dated snapshot row to Smartsheet via Smartsheet Append Scorecard RowSmartsheet Append Scorecard RowCommandv0.1.0Appends a dated KPI snapshot row to the scorecard sheet, preserving formula columns. The one write that does NOT route t...Ownervisionary-engineeringMapView docs — a direct bounded write throttled by WRITE_MODE but not routed through the approval bus (flagged in the pre-showtime audit as the one CQRS seam to close or declare).

Reading this page: a message page renders its contract and its one hop — who sends it, who receives it (that is EventCatalog’s grain: message = contract). The service page shows this workflow’s full fan-out (its sends); the flow shows the lifecycle step by step.

Input schema

Architecture diagram

Input (from the zod tool schema)

3 properties
publishboolean

Append a snapshot row to Smartsheet (write; WRITE_MODE-gated)

sheetIdinteger

Target sheet (required when publish=true)

asOfstring

ISO date; defaults to today