{"uid":"cap_r-OZIY46vgR1ib0CmGUtB","slug":"data-reconciliation-category-frequencies-keyed-dataset-comparison-1f28d65a","name":"Data Reconciliation: Category Frequencies + Keyed Dataset Comparison","description":"Data reconciliation — Category frequencies + Keyed dataset comparison: Category frequencies + 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-111?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_DsnEHXBUNkZ2nR9OympKb","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":"Compares two datasets of up to 200 rows, producing category frequency distributions and a keyed row-level comparison report to surface reconciliation discrepancies between source and target totals.","exampleAgentPrompt":"I have two sets of reconciliation records — each with row IDs, dataset groups, dates, and source and target totals — can you run a category frequency breakdown and a keyed row-by-row comparison to find discrepancies between them? Here's the first dataset with 4 rows across group-a and group-b for October 2026, and a second dataset with slightly different source totals for the same rows.","exampleUseCases":[{"title":"ETL pipeline output validation","prompt":"I ran an ETL job and I have the source totals and target totals for 150 rows across several pipeline stages from last month. Can you compare the two datasets row-by-row using their row IDs and also show me how frequently each dataset group appears so I can spot where the mismatches are concentrated?"},{"title":"Monthly financial close reconciliation","prompt":"We're doing our month-end close and I need to reconcile our general ledger source figures against the target figures from our reporting system. I have about 80 rows with dates in November 2025, grouped by cost center. Can you give me a category frequency report and a keyed comparison of the two datasets to flag the differences?"},{"title":"Data migration integrity check","prompt":"After migrating our database, I want to verify the old system source totals match the new system target totals. I have two lists of 200 rows each, identified by row ID and grouped by region and date. Can you produce a frequency breakdown by group and a keyed dataset comparison to see which rows drifted?"}],"resultDescription":"Returns two analytical reports: (1) a category frequency distribution showing how often each dataset_group appears across the submitted rows, and (2) a keyed dataset comparison that aligns rows from both datasets by row_id and highlights differences between source_total and target_total values. Both reports are computed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, dataset_group, date, source_total, target_total) in any row — validation error","Date fields not matching YYYY-MM-DD pattern — schema validation failure","source_total or target_total outside ±1,000,000,000,000 range — rejected","Empty rows array (minItems:1 not satisfied) — error returned","Payment of 0.01 USDC not completed — endpoint returns 402"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously audit the categorical composition of a reconciliation dataset AND perform a row-keyed comparison between source and target totals — for up to 200 rows — without requiring any external data lookup or live system access. It is ideal for ETL validation, financial close reconciliation, and data migration integrity checks where you already have both source and target figures in hand and want two complementary analytical perspectives in a single low-cost call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:21.277Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-category-frequencies-keyed-dataset-comparison-1f28d65a"}