json icon

KPI Scorecard

v0.1.0queries

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.

1{
2  "$schema": "http://json-schema.org/draft-07/schema#",
3  "title": "KpiScorecard",
4  "type": "object",
5  "properties": {
6    "publish": {
7      "type": "boolean",
8      "description": "Append a snapshot row to Smartsheet (write; WRITE_MODE-gated)"
9    },
10    "sheetId": {
11      "type": "integer",
12      "exclusiveMinimum": 0,
13      "description": "Target sheet (required when publish=true)"
14    },
15    "asOf": {
16      "type": "string",
17      "description": "ISO date; defaults to today"
18    }
19  }
20}

Details

Format
JSON Schema
Resource
queries
Filename
schema.json

Versions