{"uid":"cap_iB0xR7dPBeIcQxn_jeccT","slug":"data-reconciliation-numeric-row-ordering-keyed-dataset-comparison-01b5f412","name":"Data Reconciliation: Numeric Row Ordering + Keyed Dataset Comparison","description":"Data reconciliation — Numeric row ordering + Keyed dataset comparison: Numeric row ordering + Keyed dataset comparison 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-123?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"},"other":{"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":21,"target_total":2,"dataset_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","source_total":17,"target_total":3,"dataset_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","source_total":33,"target_total":4,"dataset_group":"group-b"}],"maxItems":200,"minItems":0}}},"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_sv2aXy-MnddGgz38ZCOWV","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":"Performs two analytical reports on reconciliation data: numeric row ordering and keyed dataset comparison between source and target totals, for up to 200 rows.","exampleAgentPrompt":"I have two sets of reconciliation records — rows from our source system and rows from our target system, each with a row_id, dataset_group, date, source_total, and target_total — can you run numeric row ordering and a keyed dataset comparison on both sets (up to 200 rows each) to show me where they diverge?","exampleUseCases":[{"title":"Daily financial pipeline reconciliation","prompt":"We ran our ETL yesterday and ended up with two snapshots of transaction totals — one from the source database and one from the target warehouse. Can you rank them by source_total and do a keyed comparison between the two snapshots to find which row_ids have mismatches?"},{"title":"Month-end ledger discrepancy audit","prompt":"I've got two lists of ledger rows for October with source_total and target_total values — can you order them numerically and compare the two datasets key-by-key so I can see exactly which entries don't reconcile?"},{"title":"Cross-system data validation for two groups","prompt":"Our group-a and group-b datasets went through different pipelines and I need to verify they align. Can you take both arrays of up to 200 rows each, sort them by source_total, and run a keyed comparison so I know which row_ids are missing or have different values?"}],"resultDescription":"Returns two analytical reports: (1) a numeric row ordering report ranking the submitted rows by the selected field (source_total or target_total), and (2) a keyed dataset comparison report identifying matching, mismatched, and unmatched row_ids between the two supplied datasets. No external data sources or predictions are used — all analysis is performed on the supplied rows only.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","Numeric values outside ±1,000,000,000,000 range — rejected","Empty rows array (minItems: 1 not met) — error","Payment of 0.01 USDC not completed — 402 Payment Required response"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical outputs — numeric ordering and keyed comparison — on reconciliation data with source and target totals, without requiring any external lookups or live data. It is ideal for batch auditing of ETL pipelines, financial reconciliation workflows, or data quality checks where you have both a primary and a secondary dataset to compare. Prefer this over single-report endpoints when you need both ordering and key-based diffing in one API call for cost efficiency ($0.01 for both reports).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:57.977Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-numeric-row-ordering-keyed-dataset-comparison-01b5f412"}