{"uid":"cap_TdNt3yU8RSepML4mXjpeW","slug":"data-reconciliation-record-quality-audit-keyed-dataset-comparison-ff8a8385","name":"Data Reconciliation — Record Quality Audit + Keyed Dataset Comparison","description":"Data reconciliation — Record quality audit + Keyed dataset comparison: Record quality audit + 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-018?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_f0o05q2nL4r4U3DQfBf3i","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":"Runs two independent analytical reports on supplied reconciliation data: a record quality audit and a keyed comparison between source_total and target_total across up to 200 rows.","exampleAgentPrompt":"Can you run a record quality audit and keyed dataset comparison on these two sets of reconciliation rows — I have source and target totals for about 50 rows grouped by region and dated from 2025-01-01 to 2025-01-31, and I want to see where they diverge?","exampleUseCases":[{"title":"Monthly finance close reconciliation check","prompt":"I have two sets of 80 rows from our accounting close — each row has a row ID, a date in January 2025, a dataset group like 'accounts-payable' or 'accounts-receivable', and both a source_total from our ERP and a target_total from our data warehouse. Can you audit the record quality and compare the keyed datasets to find any mismatches?"},{"title":"ETL pipeline output validation","prompt":"After running our nightly ETL job, I have 120 rows with source_total from the raw database and target_total from the transformed output, grouped by pipeline stage and dated 2025-03-10. Run a record quality audit and dataset comparison so I can see which rows have bad data or discrepancies."},{"title":"Cross-team dataset discrepancy investigation","prompt":"My team's dataset and the analytics team's dataset both have totals for the same 60 records dated throughout Q1 2025, grouped by product line. Can you compare them as source_total vs target_total and also audit the record quality to flag any nulls or anomalies?"}],"resultDescription":"Returns two independent analytical reports for the supplied data: (1) a record quality audit flagging issues such as nulls, out-of-range values, or malformed entries across the rows, and (2) a keyed dataset comparison highlighting where source_total and target_total diverge, grouped by dataset_group and date. No external data is fetched; all analysis is performed locally on the supplied rows.","failureModes":["More than 200 rows submitted — request exceeds the maxItems limit and will be rejected","Missing required fields (row_id, dataset_group, date, source_total, target_total) on any row — validation error returned","Date values not matching YYYY-MM-DD pattern — schema validation failure","source_total or target_total outside allowed range (-1T to +1T) — value rejected","Empty rows array (minItems: 1 violated) — error returned","Malformed JSON payload — request rejected"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous analytical outputs — a quality audit and a keyed comparison — on a single batch of up to 200 reconciliation rows with source and target totals. It is ideal for ETL validation, financial close reconciliation, or any scenario where you need to both check data quality and compare two numeric columns keyed by row ID, date, and group. It does not perform live lookups, predictions, or external data enrichment — all analysis is purely local and deterministic on the supplied data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:50.611Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-record-quality-audit-keyed-dataset-comparison-ff8a8385"}