{"uid":"cap_47VIfm4S7VcG841NU3sLo","slug":"data-reconciliation-numeric-row-ordering-date-by-category-pivot-bdb6a9b8","name":"Data Reconciliation — Numeric Row Ordering + Date by Category Pivot","description":"Data reconciliation — Numeric row ordering + Date by category pivot: Numeric row ordering + Date by category pivot 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-122?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_L-OeoY9jxU2Vh2yRkYn-q","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":"Generates two analytical reports (numeric row ordering and date-by-category pivot) for data reconciliation records comparing source and target totals, supporting up to 200 rows.","exampleAgentPrompt":"I have reconciliation data for 4 rows across two groups — group-a and group-b — with dates from 2026-10-01 to 2026-10-04 and source/target totals. Can you run numeric row ordering and a date-by-category pivot on the source_total field and give me both reports?","exampleUseCases":[{"title":"ETL pipeline discrepancy review","prompt":"I have 50 reconciliation rows from our ETL run, each with a source_total and target_total across groups 'warehouse' and 'staging' for dates in Q3. Can you rank them by source_total and also pivot the data by date and group so I can see where the mismatches cluster?"},{"title":"Month-end financial close reconciliation","prompt":"We finished our month-end close and I have 120 ledger reconciliation records with source and target totals across cost centers and dates in October. Run numeric row ordering and a date-by-category pivot on the target_total field so I can review the reports."},{"title":"Data migration validation analysis","prompt":"After our database migration, I have 80 comparison rows with source_total and target_total values tagged by migration batch group and date. Can you produce both the numeric row ordering and date-by-category pivot reports using source_total so I can verify everything transferred correctly?"}],"resultDescription":"Two independent analytical reports computed locally from the supplied rows: (1) a numeric row ordering report ranking records by the chosen field (source_total or target_total), and (2) a date-by-category pivot report cross-tabulating totals by date and dataset_group. No external lookups or predictions are included.","failureModes":["More than 200 rows submitted — request rejected due to maxItems constraint","Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error","Date field not in YYYY-MM-DD format — pattern validation failure","Numeric values outside ±1,000,000,000,000 range — schema rejection","Invalid field enum value (not 'source_total' or 'target_total') — validation error","Empty rows array — minItems constraint failure"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical views — numeric ordering and date-by-category pivot — on a reconciliation dataset of up to 200 rows with source and target totals. It is ideal for ETL validation, financial close reconciliation, or data migration checks where you want ranked row ordering alongside a categorical date pivot in a single low-cost call ($0.01 USDC), without needing external data lookups, predictions, or professional assessments.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:25.760Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-numeric-row-ordering-date-by-category-pivot-bdb6a9b8"}