{"uid":"cap_FXRtgjfYQpsbTo5x30d8f","slug":"treasury-supplied-balances-exact-row-deduplication-numeric-row-ordering-5055cfdc","name":"Treasury Supplied Balances — Exact Row Deduplication + Numeric Row Ordering","description":"Treasury supplied balances — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering 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-042?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"}}},"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_sXMaJ4L5W6t0uIw8pKR-M","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":"Deduplicates and numerically orders rows of treasury-supplied opening/closing balance data, producing up to 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate and numerically sort these treasury balance records — I have about 50 rows with opening_balance and closing_balance fields across multiple instrument groups and dates — and give me a clean report?","exampleUseCases":[{"title":"Treasury reconciliation data cleanup","prompt":"I have 120 rows of treasury balance data with instrument groups, dates, opening and closing balances, but some entries are exact duplicates and the ordering is off. Can you deduplicate them and sort them numerically, focusing on the opening_balance field?"},{"title":"Month-end closing balance report","prompt":"For month-end reporting, can you take my closing_balance treasury records for October 2026 — about 80 rows across groups A and B — remove any exact duplicate rows, and give me a numerically ordered clean report?"},{"title":"Instrument group balance audit","prompt":"I want to audit our treasury supplied balances for duplicate entries and get them ordered properly. I've got rows with row_id, date, instrument_group, and both opening and closing balances. Can you run deduplication and numeric ordering on the closing_balance field for me?"}],"resultDescription":"Returns up to 2 analytical reports covering: (1) exact duplicate rows identified and removed from the supplied treasury balance dataset, and (2) the remaining rows ordered numerically by the selected balance field (opening_balance or closing_balance), for up to 200 input rows.","failureModes":["Exceeding 200 rows will be rejected — cap input at 200 rows per call","Missing required fields (row_id, instrument_group, date, opening_balance, closing_balance) will cause validation errors","Invalid date format (must be YYYY-MM-DD) will cause schema rejection","Balance values outside ±1,000,000,000,000 will be rejected","Empty rows array will fail minItems:1 validation"],"whenToPreferThis":"Choose this endpoint when you have treasury-specific opening/closing balance data that needs exact row deduplication and numeric ordering as a combined operation, up to 200 rows, and you want a lightweight, no-external-lookup analytical report delivered for a flat fee of $0.01 USDC per call (covering 2 reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:37:09.359Z","isFirstParty":false,"canonicalSlug":"treasury-supplied-balances-exact-row-deduplication-numeric-row-ordering-5055cfdc"}