{"receipt":{"id":"cmry4ew8l000209jlmu6obtko","type":"brain.analytics","orgSlug":"wipro-hps","createdAt":"2026-07-23T23:06:36.597Z","bodyHash":"90761010bdec7af8dd2438ca094363359fb9df2df53dfebff6169f94d85d83eb","prevHash":"d7cb5d4d5fc7255d233171ec843de876f411fef631edf657d21d6554303a3df3","signature":"13434dbde84823b3e17f6c18636e161ab5ee5733d9ad0364b3589d63289dea69acf5a458daa757b6cb77005fd60f585bbd839cdb0e458c877354a60a95459901","body":{"org":"wipro-hps","sql":"SELECT ROUND(SUM(amount), 2) AS total_contractor_spend_2025 FROM kbdata.\"t_1eb80674acdadda1\" WHERE category ILIKE '%contractor%' AND year = 2025 LIMIT 200","dataset":"Representative IT Budget (demo)","surface":"second-brain","readOnly":true,"computedBy":"postgresql","resultSha256":"05b42da733698dd27cc0578ff76081bc989ce45ded13fb4e2207f78b3c1fcc05","rowsReturned":1,"sourceSha256":"f1202ffb79006d34640aef01496f134ac36f33976bbe53003b334965795fe7bc","questionSha256":"3d3dec9b9de901235b6e1f1c0c5c923700cec69ac5f378d6d77e00e0ea539230"}},"verification":{"bodyIntact":true,"signatureValid":true,"publicKeyPem":"-----BEGIN PUBLIC KEY-----\nMCowBQYDK2VwAyEA0WH2nutx59q3kf36i7DsAp/QvHq+FgLXVv5k8zecwuM=\n-----END PUBLIC KEY-----\n","fingerprint":"359c5d5373bba0a8","algorithm":"Ed25519","canonicalization":"RFC8785-style JCS","howToVerifyOffline":"1) Canonicalize `receipt.body` (JCS: sorted keys, no whitespace, undefined dropped). 2) SHA-256 it and compare to `bodyHash`. 3) Verify the Ed25519 signature over the UTF-8 string `${prevHash}.${bodyHash}` against `publicKeyPem`. The prevHash link binds the receipt to its position in the org's chain."}}