{"uid":"cap_Hagj4cVUdDlHigY_H-v_T","slug":"data-reconciliation-grouped-numeric-summary-numeric-row-ordering-efdd6a8b","name":"Data Reconciliation — Grouped Numeric Summary + Numeric Row Ordering","description":"Data reconciliation — Grouped numeric summary + Numeric row ordering: Grouped numeric summary + Numeric row ordering for supplied data reconciliation records (source_total, target_total). 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-analytics-11-087?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","source_total","target_total"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"source_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"target_total":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"dataset_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","source_total":10,"target_total":1,"dataset_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","source_total":20,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":15,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":30,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"}}},"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_atY54MYhx42DS_4i48QEV","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":"Computes a grouped numeric summary and a numeric row ordering for up to 200 data reconciliation records comparing source and target totals.","exampleAgentPrompt":"I have 4 reconciliation rows — row-1 on 2026-10-01 in group-a with source 10 and target 1, row-2 on 2026-10-02 in group-b with source 20 and target 2, row-3 on 2026-10-03 in group-a with source 15 and target 3, row-4 on 2026-10-04 in group-b with source 30 and target 4 — can you give me a grouped numeric summary and rank them by source_total?","exampleUseCases":[{"title":"Daily ETL pipeline audit","prompt":"I've got 50 reconciliation records from yesterday's ETL run across groups 'sales', 'returns', and 'adjustments' — each with a source_total and target_total — can you group them and summarize the totals per group, then rank all rows by source_total so I can spot the biggest discrepancies?"},{"title":"Month-end financial close check","prompt":"Here are 120 reconciliation entries from our month-end close across 5 ledger groups, with source and target totals for each date. Run me a grouped numeric summary across those groups and then order all the rows by target_total so we can prioritize the largest items."},{"title":"Cross-system data comparison","prompt":"I'm comparing records between two systems — I have 80 rows each tagged with a dataset_group, date, source_total, and target_total. Give me a grouped summary of the source_total values and a numeric row ordering by source_total so I can see which groups are most out of balance."}],"resultDescription":"Returns two analytical reports: (1) a grouped numeric summary aggregating source_total or target_total values across dataset_group categories, and (2) a numeric row ordering ranking all supplied rows by the specified numeric field. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, source_total, or target_total) cause validation errors","Dates not matching YYYY-MM-DD pattern will fail schema validation","Numeric values outside ±1,000,000,000,000 range are rejected","Empty rows array causes validation failure","Invalid field enum value (anything other than 'source_total' or 'target_total') is rejected"],"whenToPreferThis":"Choose this endpoint when you need both a grouped aggregate summary AND a ranked row ordering for data reconciliation records in a single API call. Ideal for ETL audits, financial close reconciliations, or any workflow comparing source vs. target totals across named groups with up to 200 rows. Prefer this over generic analytics tools when you want two distinct reconciliation-oriented reports cheaply ($0.01 USDC) without sending data to an external prediction or lookup service.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:18.782Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-grouped-numeric-summary-numeric-row-ordering-efdd6a8b"}