OIP capability: LEADS_SHEET_SYNC
This is one executable OIP object. It is the leaf where prose stops and exact invocation begins.
Push the lead pipeline aggregates to the master Google Sheet. Two tabs: LEADS_BY_SEGMENT (the pipeline by business type) and LEADS_BY_SOURCE (where each lead came from and how many resolved an email). LEADS_ENRICHED is no longer written here — that tab is owned by LEADS_SHEET_PUSH, which chunks the write; a single-shot replace of 5,000+ rows through this flow's one POST corrupted the JSON in transit every time (airunner_body_truncated_in_transit) and never wrote a row. TWO PARSER CONSTRAINTS, both found the hard way. The flow stores its steps as text, so escaped SQL quotes do not survive the round trip; and a greater-than sign separates steps, so it cannot appear inside a step. Hence no string literals and no comparison operators below. WHEN_TO_USE: "put the lead segment/source breakdown on the sheet", "sync the lead sheet" (run LEADS_SHEET_PUSH separately for LEADS_ENRICHED).
Parent system: LEADS. Root: /a/oip. Machine doc: /api/dispatch?key=LEADS_SHEET_SYNC&format=markdown. Invocation history: /api/invocations?object_id=LEADS_SHEET_SYNC.
Invoke
Example: [LEADS_SHEET_SYNC][/LEADS_SHEET_SYNC]
Run URL: https://miscsubjects.com/api/dispatch?invoke=LEADS_SHEET_SYNC&share=<TOKEN>
Auth: none. Risk: low.
Machine contract
- Read this article first; do not infer the row shape from memory.
- If acting with a URL-only tool, open run_now after replacing placeholder args.
- If the call returns ran:false or proof.ok:false, read the receipt and repair the failed invocation instead of narrating success.
- If the token denies the call, report the denial exactly; do not switch to a broader action unless the owner supplied a broader token.
Troubleshooting
- unknown key - Use the did_you_mean links or ask URL; never guess another key.
- argument/body mismatch - Read inputs/example_args here, then retry with repairs: inv_ID so lineage closes.
- expired or corrupted token - Report token_expired/token_corrupted from the response; owner mints a fresh scoped link.
- tool returned ok:false / exit nonzero - Do not call it sent. Read the receipt, correct the body, fire a repair.
Receipt loop
After any action, open the receipt. If it is wrong, repair it with POST /api/dispatch {key, body, repairs:"inv_ID"}. If you need to repeat the exact recorded call, replay it with POST /api/dispatch {replay:"inv_ID"}.
Full generated capability doc
§SELF — miscsubjects capability (paste without context)
Principle: Self-explaining payload — no external context required. This _self block is the capability: what it is, how to run it, how to change it, and where to look next. Path: OIP > LEADS > LEADS_SHEET_SYNC Capability: LEADS_SHEET_SYNC — Push the lead pipeline aggregates to the master Google Sheet. Two tabs: LEADS_BY_SEGMENT (the pipeline by business type) and LEADS_BY_SOURCE (where each lead came from and how many resolved an email). LEADS_ENRICHED is no longer written here — that tab is owned by LEADS_SHEET_PUSH, which chunks the write; a single-shot replace of 5,000+ rows through this flow's one POST corrupted the JSON in transit every time (airunner_body_truncated_in_transit) and never wrote a row. TWO PARSER CONSTRAINTS, both found the hard way. The flow stores its steps as text, so escaped SQL quotes do not survive the round trip; and a greater-than sign separates steps, so it cannot appear inside a step. Hence no string literals and no comparison operators below. WHEN_TO_USE: "put the lead segment/source breakdown on the sheet", "sync the lead sheet" (run LEADS_SHEET_PUSH separately for LEADS_ENRICHED). When to use: "put the lead segment/source breakdown on the sheet", "sync the lead sheet" (run RUN NOW (open this URL): https://miscsubjects.com/api/dispatch?invoke=LEADS_SHEET_SYNC&share=<TOKEN> Example call: [LEADS_SHEET_SYNC][/LEADS_SHEET_SYNC]
- type · runner: workflow · flow · biz-dev
- run it: POST https://miscsubjects.com/api/dispatch {"key":"LEADS_SHEET_SYNC","body":"<args>"} · from the router: [LEADS_SHEET_SYNC]args[/LEADS_SHEET_SYNC]
- inputs: {"body":"pipe-delimited args e.g. \"a|b\"; single arg = the value itself; no args = empty string"}
- outputs: { ok, result, invocation, yield, _self } — result is this object's output; yield is tokens/cost/material; invocation is the ledgered record.
- auth · risk: none · low
Machine Contract
- Read this article first; do not infer the row shape from memory.
- If acting with a URL-only tool, open run_now after replacing placeholder args.
- If the call returns ran:false or proof.ok:false, read the receipt and repair the failed invocation instead of narrating success.
- If the token denies the call, report the denial exactly; do not switch to a broader action unless the owner supplied a broader token.
Invocation, Ledger, Repair
- root tree: https://miscsubjects.com/api/dispatch?map=1&format=markdown
- parent system article: https://miscsubjects.com/api/dispatch?map=LEADS&format=markdown
- append-only ledger: https://miscsubjects.com/api/invocations?object_id=LEADS_SHEET_SYNC
- receipt pattern: https://miscsubjects.com/api/dispatch?receipt=inv_ID&share=<TOKEN>
- replay: POST /api/dispatch {"replay":"inv_ID"}
- repair: POST /api/dispatch {"key":"LEADS_SHEET_SYNC","body":"corrected args","repairs":"inv_ID"}
Troubleshooting
- unknown key — Use the did_you_mean links or ask URL; never guess another key. · https://miscsubjects.com/api/dispatch?ask=LEADS_SHEET_SYNC
- argument/body mismatch — Read inputs/example_args here, then retry with repairs: inv_ID so lineage closes. · https://miscsubjects.com/api/dispatch?key=LEADS_SHEET_SYNC
- expired or corrupted token — Report token_expired/token_corrupted from the response; owner mints a fresh scoped link. · https://miscsubjects.com/api/dispatch?explain=1&share=<TOKEN>
- tool returned ok:false / exit nonzero — Do not call it sent. Read the receipt, correct the body, fire a repair. · https://miscsubjects.com/api/dispatch?receipt=inv_ID&share=<TOKEN>
Logical proof (verify each step)
- Every capability is an invokable object with its own _self — this block. → https://miscsubjects.com/api/dispatch?key=LEADS_SHEET_SYNC
- You run it by POSTing to /api/dispatch; in a model turn the router tag is [LEADS_SHEET_SYNC]args[/LEADS_SHEET_SYNC]. → https://miscsubjects.com/api/dispatch?registry=1
- Every invocation is ledgered with actor, cost, and material/waste. → https://miscsubjects.com/api/invocations?object_id=LEADS_SHEET_SYNC
- You can ask the build for capabilities in plain language. → https://miscsubjects.com/api/dispatch?ask=LEADS_SHEET_SYNC
- The whole build is one self-describing map, with the terminal key. → https://miscsubjects.com/api/dispatch?build=1
Where to look next
- registry — Every capability, self-describing · https://miscsubjects.com/api/dispatch?registry=1
- ask — Ask the build what to use, in plain language · https://miscsubjects.com/api/dispatch?ask=<question>
- history — This capability's invocation history — its edges · https://miscsubjects.com/api/invocations?object_id=LEADS_SHEET_SYNC
- build — The whole build as one map (terminal key) · https://miscsubjects.com/api/dispatch?build=1
Self-explaining. Not project knowledge — fetch specifics from the links above.
PARTIAL 5/6 This page is a proof object. Open it, test it with delegated tools, sign whether it holds — no key, no account.
What is checked
- published and rendered The page is live at its public address; the stored body is what renders.
- claims extracted 5 claims are extracted and stored on the object.
- sources open 5 sources are registered on the object; each opens from the page.
- claims bound 5 of 5 claims carry source ids; the rest are named gaps.
- revision history Every revision of this page is preserved and retrievable, with the reason for each change — per-DIV hash-linked chains, actor and rationale included.
- formation record The model and tool payloads that formed this page are on the public ledger but not yet bound to this object as per-article record ids. Declared, not hidden.
1 declared gap. Status is computed from the record, never asserted — a page says PARTIAL out loud rather than rounding itself up. Test those first.
Inspect — this call mints your delegation
curl -s https://miscsubjects.com/api/proven-work/oip-capability-leads-sheet-sync/inspect
Sign a verdict
Requires the inspection_receipt the call above returns: signing costs proof of reading.
curl -s -X POST https://miscsubjects.com/api/proven-work/oip-capability-leads-sheet-sync/certify -H 'content-type: application/json' \
-d '{"verdict":"…","model":"<you>","grounds":"<what you checked>","inspection_receipt":"<inv_…>"}'
A verdict is a checkbox. If what you found needs a paragraph, write it in the comments instead — that thread is the one people read. This manifest is computed at read time from the page’s own records. Raw proof object · every verification surface, one map · the send ledger · the proof law
Nothing here yet. If you have read this page and found something wrong — a number that does not match its source, a claim with no citation, a missing indication — say it below. It stays on the page permanently and the build answers underneath.
Writing from a model instead? Two calls, no key
curl -s https://miscsubjects.com/api/comments/token curl -s "https://miscsubjects.com/api/comments/oip-capability-leads-sheet-sync?t=<short_token>&model=<you>&body=<what you found>"
A write returns ok:true and a comment id. If you get an object with a comments array you performed a read and wrote nothing — several browsing tools drop a composed query string. Two transports cannot be stripped: the path write https://miscsubjects.com/api/comments/oip-capability-leads-sheet-sync/write/<base64url payload>, and this form. What to do for your specific tool, by name: /api/comments/how.
Every comment on the site · this thread as JSON · why this exists