{"uid":"cap_iYyI4oWzbCnwHIJ6Vz8F2","slug":"treasury-supplied-balances-record-quality-audit-explicit-missing-64fca2f9","name":"Treasury Supplied Balances — Record Quality Audit + Explicit Missing-Value Fill","description":"Treasury supplied balances — Record quality audit + Explicit missing-value fill: Record quality audit + 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-019?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"},"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_uVniRtg8YRECd7HUiu3Uv","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":"Audits data quality and fills missing values (opening_balance or closing_balance) in treasury balance records using zero, mean, or median imputation, for up to 200 rows.","exampleAgentPrompt":"Can you run a record quality audit and fill any missing opening_balance values using median imputation on my treasury balance data — here are up to 50 rows with fields row_id, instrument_group, date, opening_balance, and closing_balance?","exampleUseCases":[{"title":"Month-end treasury balance QA","prompt":"I have 120 rows of month-end treasury balance records with some null opening_balance entries — can you run a quality audit and fill those missing values using median imputation so I can finalize the report?"},{"title":"Instrument group closing balance cleanup","prompt":"My closing_balance column has a bunch of nulls across several instrument groups — can you audit the data quality and fill the missing closing_balance values using mean imputation for these 80 treasury records?"},{"title":"Zero-fill missing balances before reconciliation","prompt":"Before I run reconciliation, I need to check data quality and zero-fill any missing opening_balance fields in this set of 30 treasury supplied balance rows — can you do that for me?"}],"resultDescription":"Returns two independent analytical reports: (1) a record quality audit identifying issues such as nulls, out-of-range values, or malformed rows across the supplied treasury balance records; and (2) an explicit missing-value fill report showing the imputed values for the target field (opening_balance or closing_balance) using the chosen method (zero, mean, or median). Covers up to 200 input rows. No external data or live lookups are used.","failureModes":["Input array is empty or exceeds 200 rows — rejected with validation error","Invalid date format (not YYYY-MM-DD) causes row rejection","Balance values outside ±1,000,000,000,000 range fail schema validation","Invalid enum value for 'method' or 'field' causes request rejection","Rows missing required fields (row_id, instrument_group, date) are rejected"],"whenToPreferThis":"Choose this endpoint when you need both a data quality audit and missing-value imputation for treasury balance records (opening_balance or closing_balance) in a single low-cost call. It is ideal for pre-reconciliation cleanup, month-end reporting pipelines, or any workflow where nulls in treasury balance fields must be flagged and filled using simple statistical methods (zero, mean, or median) without any external lookups or predictions. It is not appropriate for real-time balance retrieval, forecasting, or auditing non-treasury financial record types.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:54:39.933Z","isFirstParty":false,"canonicalSlug":"treasury-supplied-balances-record-quality-audit-explicit-missing-64fca2f9"}