{"uid":"cap_hMRZ-YFqz-5wRXmaBSGfQ","slug":"data-reconciliation-exact-row-deduplication-keyed-dataset-comparison-a9d376b0","name":"Data Reconciliation — Exact Row Deduplication + Keyed Dataset Comparison","description":"Data reconciliation — Exact row deduplication + Keyed dataset comparison: Exact row deduplication + 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-053?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},"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_U3-r9rvzavNXmpsRgk4AA","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 rows and compares two keyed datasets to identify discrepancies between source and target totals, producing two independent reconciliation reports for up to 200 rows.","exampleAgentPrompt":"I have two datasets of up to 200 rows each with row_id, date, dataset_group, source_total, and target_total — can you deduplicate each dataset and compare them side by side to show me where the source and target totals diverge?","exampleUseCases":[{"title":"Monthly financial close reconciliation","prompt":"I need to reconcile my month-end ledger data — here are two sets of records for October 2026, each with row IDs, dates, dataset groups, and source vs target totals. Can you deduplicate both datasets and tell me which rows have mismatches between the source and target figures?"},{"title":"ETL pipeline output validation","prompt":"My ETL pipeline produced two output datasets for the same batch — can you run an exact row deduplication on each and then compare them keyed by row_id and date to find any records that differ in source_total or target_total?"},{"title":"Cross-system balance audit","prompt":"I'm auditing balances from two reporting systems for groups A and B across dates in Q4 2026 — please deduplicate both record sets and show me a keyed comparison report highlighting any rows where the source and target totals don't match."}],"resultDescription":"Two independent analytical reports: (1) an exact row deduplication report identifying duplicate rows within the supplied dataset, and (2) a keyed dataset comparison report showing matches, mismatches, and discrepancies between source_total and target_total values across both datasets, keyed by row_id, date, and dataset_group. No external lookups or live data are used.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, dataset_group, date, source_total, target_total) on any row — validation error","date field does not match YYYY-MM-DD pattern — schema validation failure","source_total or target_total outside allowed range (-1e12 to 1e12) — schema validation failure","Empty rows array (minItems:1 not met) — validation error","Payment not processed — x402 payment required before response is returned"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a keyed comparison of two datasets (source vs target totals) in a single $0.01 call, without needing live data lookups, predictions, or external integrations. It is well-suited for financial reconciliation, ETL output validation, and audit workflows where datasets are small enough to supply inline (up to 200 rows each) and where deterministic, local analytical computation is sufficient.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:00.279Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-exact-row-deduplication-keyed-dataset-comparison-a9d376b0"}