{"uid":"cap_Qe6TUS2aFKvtwOz1AtdtS","slug":"treasury-supplied-balances-keyed-dataset-comparison-explicit-missing-f534de34","name":"Treasury Supplied Balances — Keyed Dataset Comparison + Explicit Missing-Value Fill","description":"Treasury supplied balances — Keyed dataset comparison + Explicit missing-value fill: Keyed dataset comparison + Explicit missing-value fill for supplied treasury supplied balances records (opening_balance, closing_balance). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-finance-16-190?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","opening_balance","closing_balance"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"closing_balance":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"opening_balance":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","closing_balance":1,"opening_balance":10,"instrument_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","closing_balance":2,"opening_balance":20,"instrument_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","closing_balance":3,"opening_balance":15,"instrument_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","closing_balance":4,"opening_balance":30,"instrument_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["opening_balance","closing_balance"],"type":"string","default":"opening_balance"},"other":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","opening_balance","closing_balance"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"closing_balance":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"opening_balance":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","closing_balance":1,"opening_balance":10,"instrument_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","closing_balance":2,"opening_balance":21,"instrument_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","closing_balance":3,"opening_balance":17,"instrument_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","closing_balance":4,"opening_balance":33,"instrument_group":"group-b"}],"maxItems":200,"minItems":0},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_ucnhS0LaBQCoHTfDSaihD","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Compares two treasury balance datasets by row key and fills missing opening/closing balance values explicitly, producing up to 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"I have two sets of treasury balance records — a primary dataset and a secondary dataset, each with up to 50 rows keyed by row_id, instrument_group, and date — can you compare the opening_balance field across both, highlight any discrepancies, and fill in any missing values?","exampleUseCases":[{"title":"Daily treasury reconciliation between two reports","prompt":"I have two daily treasury balance exports for October 2026 — each with about 30 rows keyed by row ID and instrument group — can you compare their closing_balance fields, flag any rows where the values differ, and fill in any nulls?"},{"title":"Missing opening balance audit for instrument groups","prompt":"My treasury data has some null opening_balance entries across two instrument group reports — up to 80 rows each — can you run a missing-value fill and keyed comparison on both datasets so I can see what's incomplete?"},{"title":"Month-end balance snapshot comparison","prompt":"I need to reconcile two month-end treasury snapshots — primary and secondary — about 120 rows apiece, keyed by row_id and date, comparing opening_balance values; please flag discrepancies and fill any explicit gaps."}],"resultDescription":"Returns up to 2 analytical reports: (1) a keyed dataset comparison showing row-by-row differences between the two supplied treasury balance datasets on the chosen field (opening_balance or closing_balance), and (2) an explicit missing-value fill report identifying and substituting null balance entries. Results are computed locally with no external lookups.","failureModes":["Exceeding 200 rows per dataset returns a validation error","Missing required fields (row_id, instrument_group, date, opening_balance, closing_balance) causes schema rejection","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Balance values outside ±1,000,000,000,000 are rejected","Empty rows array (minItems:1 violated) returns an error","Mismatched row keys between primary and secondary datasets may produce sparse comparison output"],"whenToPreferThis":"Choose this endpoint when you need to compare two treasury balance datasets side-by-side by a shared row key and simultaneously fill in missing (null) balance values — all offline using supplied data only, with no external API calls, live lookups, or predictions. Best for finance teams reconciling two independent balance reports of up to 200 rows at low cost ($0.01 USDC for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:33:12.550Z","isFirstParty":false,"canonicalSlug":"treasury-supplied-balances-keyed-dataset-comparison-explicit-missing-f534de34"}