OIP capability: OWNER_STRIPE_ANALYTICS
This is one executable OIP object. It is the leaf where prose stops and exact invocation begins.
Stripe Sigma/analytics: search query tables, run SQL (Trino) over the account data, run templates. intent is one of execute_query_run, retrieve_query_run, search_query_tables, retrieve_query_table, execute_query_template, retrieve_query_template. On the owner's OWN Stripe account (acct_1UIHUdS9KDxmrGOI, "Miscsubjects", login [OWNER_SURNAME].the owner@gmail.com, LIVE). Not the reta.love/Loop client accounts — those are the STRIPE_* rows.
Parent system: OWNER. Root: /a/oip. Machine doc: /api/dispatch?key=OWNER_STRIPE_ANALYTICS&format=markdown. Invocation history: /api/invocations?object_id=OWNER_STRIPE_ANALYTICS.
Invoke
Example: [OWNER_STRIPE_ANALYTICS]{"intent":"gross volume last 30 days"}[/OWNER_STRIPE_ANALYTICS]
Run URL: https://miscsubjects.com/api/dispatch?invoke=OWNER_STRIPE_ANALYTICS&body=%7B%22intent%22%3A%22gross%20volume%20last%2030%20days%22%7D&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 > OWNER > OWNER_STRIPE_ANALYTICS Capability: OWNER_STRIPE_ANALYTICS — Stripe Sigma/analytics: search query tables, run SQL (Trino) over the account data, run templates. intent is one of execute_query_run, retrieve_query_run, search_query_tables, retrieve_query_table, execute_query_template, retrieve_query_template. On the owner's OWN Stripe account (acct_1UIHUdS9KDxmrGOI, "Miscsubjects", login [OWNER_SURNAME].the owner@gmail.com, LIVE). Not the reta.love/Loop client accounts — those are the STRIPE_* rows. When to use: revenue and subscription questions RUN NOW (open this URL): https://miscsubjects.com/api/dispatch?invoke=OWNER_STRIPE_ANALYTICS&body=%7B%22intent%22%3A%22gross%20volume%20last%2030%20days%22%7D&share=<TOKEN> Example call: [OWNER_STRIPE_ANALYTICS]{"intent":"gross volume last 30 days"}[/OWNER_STRIPE_ANALYTICS]
- type · runner: tool · fn · payments
- run it: Open run_now (URL, fires the example), or POST https://miscsubjects.com/api/dispatch {"key":"OWNER_STRIPE_ANALYTICS","body":"{"intent":"gross volume last 30 days"}"}. From the router: [OWNER_STRIPE_ANALYTICS]{"intent":"gross volume last 30 days"}[/OWNER_STRIPE_ANALYTICS]
- inputs: {"type":"object","properties":{"intent":{"description":"The intent of the tool call.","type":"string","enum":["execute_query_run","retrieve_query_run","search_query_tables","retrieve_query_table","execute_query_template","retrieve_query_template"]},"params":{"type":"object","description":"The parameters for the tool call. Required parameters depend on the intent.","properties":{"sql":{"description":"Used with execute_query_run. The SQL query to execute (Trino 414).","type":"string"},"result_options":{"description":"Used with execute_query_run. Optional settings for the QueryRun results.","type":"object","properties":{"compress_file":{"type":"boolean","description":"Whether to compress the generated results file."}}},"query_run_id":{"description":"Used with retrieve_query_run or retrieve_query_template. The QueryRun ID to retrieve.","type":"string"},"search_string":{"description":"Used with search_query_tables. Keyword to search table names and descriptions.","type":"string"},"table_name":{"description":"Used with retrieve_query_table. The table name.","type":"string"},"metric":{"description":"Used with execute_query_template. The canonical metric name.","type":"string","enum":["gross_volume","subscriber_churn_rate","gross_mrr_churn_rate","churned_subscribers","net_mrr_churn_rate","churned_revenue","new_subscribers","active_subscribers","active_subscriber_growth"]},"dimensions":{"description":"Used with execute_query_template. Dimensions to group by: 'product', 'price'.","type":"array","items":{"type":"string","enum":["product","price"]}},"grains":{"description":"Used with execute_query_template. Time grain: 'day', 'week', or 'month'. Default is 'month'.","type":"array","items":{"type":"string","enum":["day","week","month"]}},"metric_filters":{"description":"Used with execute_query_template. Filters to apply: 'top5' or 'all'. Default is 'all'.","type":"array","items":{"type":"string","enum":["top5"]}}}}},"required":["intent"]}
- 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=OWNER&format=markdown
- append-only ledger: https://miscsubjects.com/api/invocations?object_id=OWNER_STRIPE_ANALYTICS
- receipt pattern: https://miscsubjects.com/api/dispatch?receipt=inv_ID&share=<TOKEN>
- replay: POST /api/dispatch {"replay":"inv_ID"}
- repair: POST /api/dispatch {"key":"OWNER_STRIPE_ANALYTICS","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=OWNER_STRIPE_ANALYTICS
- argument/body mismatch — Read inputs/example_args here, then retry with repairs: inv_ID so lineage closes. · https://miscsubjects.com/api/dispatch?key=OWNER_STRIPE_ANALYTICS
- 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=OWNER_STRIPE_ANALYTICS
- You run it by POSTing to /api/dispatch; in a model turn the router tag is [OWNER_STRIPE_ANALYTICS]args[/OWNER_STRIPE_ANALYTICS]. → https://miscsubjects.com/api/dispatch?registry=1
- Every invocation is ledgered with actor, cost, and material/waste. → https://miscsubjects.com/api/invocations?object_id=OWNER_STRIPE_ANALYTICS
- You can ask the build for capabilities in plain language. → https://miscsubjects.com/api/dispatch?ask=Stripe%20Sigma%2Fanalytics%3A%20search%20query%20tab
- 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=OWNER_STRIPE_ANALYTICS
- 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-owner-stripe-analytics/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-owner-stripe-analytics/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-owner-stripe-analytics?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-owner-stripe-analytics/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