{"uid":"cap_nsUfCYoNsoy_Yu8uGnNM2","slug":"data-reconciliation-numeric-distribution-keyed-dataset-comparison-4799f918","name":"Data Reconciliation — Numeric Distribution + Keyed Dataset Comparison","description":"Data reconciliation — Numeric distribution + Keyed dataset comparison: Numeric distribution + 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-084?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_PqRGoDflF8WLwRNXc-5YA","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 local analytical reports on supplied reconciliation data: a numeric distribution analysis and a keyed dataset comparison between source and target totals across up to 200 rows.","exampleAgentPrompt":"Can you run a numeric distribution and keyed dataset comparison on my reconciliation data? I have up to 50 rows with row IDs, dataset groups, dates, and both source_total and target_total values — I want to compare the source_total field across the two datasets.","exampleUseCases":[{"title":"Financial ledger source vs target audit","prompt":"I have daily ledger rows with source_total and target_total amounts for two accounting systems — can you run a numeric distribution and keyed comparison on these 80 rows grouped by ledger_segment to spot where the figures diverge?"},{"title":"ETL pipeline output validation","prompt":"After running our ETL pipeline I have source and target row totals for each pipeline stage — please compare them using a keyed dataset comparison and numeric distribution report for these 120 rows so I can see where values drifted."},{"title":"Monthly sales reconciliation between regions","prompt":"I need to reconcile monthly sales figures between our CRM and ERP systems — I have 60 rows with source_total from the CRM and target_total from the ERP, grouped by region. Can you run a numeric distribution and keyed dataset comparison on them?"}],"resultDescription":"Returns two independent analytical reports: (1) a numeric distribution summary of the selected field across the supplied rows, and (2) a keyed dataset comparison between the two provided datasets matched by row_id, highlighting differences in source_total and target_total values across dataset groups and dates. No external lookups or live data — all computation is performed locally on the supplied data.","failureModes":["More than 200 rows submitted — request exceeds maxItems limit and will be rejected","Missing required fields (row_id, dataset_group, date, source_total, target_total) on any row causes validation failure","Date values not matching YYYY-MM-DD pattern will fail schema validation","source_total or target_total values outside ±1,000,000,000,000 range will be rejected","Empty rows array (minItems: 1 not met) returns an error","Payment of 0.01 USDC not included or declined results in 402 response"],"whenToPreferThis":"Choose this endpoint when you need two complementary reconciliation-focused reports — numeric distribution and keyed dataset comparison — run together on the same batch of source/target data (up to 200 rows) at a single flat cost. Ideal for data engineers or analysts who want to audit discrepancies between two systems' totals without sending data to external services. Prefer alternatives if you need more than 200 rows, live data lookup, predictive analysis, or a single-report output.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:57.682Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-numeric-distribution-keyed-dataset-comparison-4799f918"}