Reproducible query — Product (shared drive)
SUM SECTIONS SECTION_INDEX
Anyone opening this link re-runs the same query against epoch 1, so it returns the same answer — that is what makes a number in a report checkable later.
50total SECTION_INDEX across 36 of 36 rows
epoch 1source gdrive:sectionsas of 2026-09-14T21:44:11Ztransforms type-coercioncache hit
Raw envelope — what an app or agent receives
{
"ok": true,
"query": null,
"verb": "SUM",
"subject": "SECTIONS",
"data": {
"sum": 50,
"field": "SECTION_INDEX",
"rows_considered": 36,
"rows_contributing": 36,
"rows_missing_value": 0
},
"_meta": {
"epoch": 1,
"provenance": {
"source": "gdrive:sections",
"sync_id": "sync-fbaf01faca",
"source_freshness": "2026-09-14T21:44:11Z",
"representation_freshness": "2026-09-14T21:44:11Z",
"resolved_fields": [],
"transforms": [
"type-coercion"
]
},
"related": [
"COUNT SECTIONS BY ID"
],
"hints": [],
"completeness": {
"rows_considered": 36,
"rows_contributing": 36,
"rows_missing_value": 0,
"complete": true
},
"cache": "hit"
}
}