{"uid":"cap_zh7-t7hsB0PscF1xjWtpV","slug":"data-reconciliation-duplicate-key-report-category-frequencies-481aa609","name":"Data Reconciliation — Duplicate Key Report + Category Frequencies","description":"Data reconciliation — Duplicate key report + Category frequencies: Duplicate key report + Category frequencies 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-057?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}}},"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_s1QiEg8rbR0QZUI4VSE4z","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":"Analyzes up to 200 data reconciliation rows to produce a duplicate key report and category frequency breakdown for source and target totals.","exampleAgentPrompt":"Check these reconciliation records for duplicate row IDs and tell me how often each dataset group appears — I have up to 200 rows with row_id, date, dataset_group, source_total, and target_total fields.","exampleUseCases":[{"title":"ETL pipeline duplicate key audit","prompt":"I've got a batch of 150 reconciliation records from our ETL pipeline with row IDs, dates, source totals, and target totals grouped by region. Can you run a duplicate key check and show me the frequency breakdown of each region group?"},{"title":"Monthly finance reconciliation review","prompt":"Here are our monthly finance reconciliation rows — each has a row_id, date, source_total, target_total, and a dataset_group like 'accounts-payable' or 'accounts-receivable'. Find any duplicate keys and tell me how many rows fall into each category."},{"title":"Data migration integrity check","prompt":"We just migrated data from two systems and I want to verify there are no duplicate row IDs and see how the dataset groups are distributed. Can you run the duplicate key report and category frequency analysis on these reconciliation records?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any row_ids that appear more than once across the supplied records, and (2) a category frequency table showing how many rows belong to each distinct dataset_group value. Both reports are computed locally on the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, dataset_group, date, source_total, target_total) cause validation errors","date field not matching YYYY-MM-DD pattern triggers schema validation failure","source_total or target_total values outside ±1,000,000,000,000 range rejected","Empty rows array (minItems: 1 violated) returns an error","row_id or dataset_group exceeding 80 characters causes validation failure"],"whenToPreferThis":"Choose this endpoint when you need a quick, cheap ($0.01 USDC) dual-report analysis of reconciliation data — specifically to surface duplicate row keys and category-level frequencies — without needing any live data lookup, external enrichment, or predictive modeling. Ideal for ETL validation, post-migration audits, or routine data quality checks on batches of up to 200 reconciliation records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:47:08.157Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-duplicate-key-report-category-frequencies-481aa609"}