{"uid":"cap_4S5lSkdA_usYraAVjNNiJ","slug":"record-routing-analytics-duplicate-key-report-numeric-distribution-faf9248a","name":"Record Routing Analytics: Duplicate Key Report + Numeric Distribution","description":"Record routing — Duplicate key report + Numeric distribution: Duplicate key report + Numeric distribution for supplied record routing records (accepted_records, rejected_records). 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-19-055?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","accepted_records","rejected_records"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"accepted_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"rejected_records":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","accepted_records":10,"rejected_records":1},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","accepted_records":20,"rejected_records":2},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","accepted_records":15,"rejected_records":3},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","accepted_records":30,"rejected_records":4}],"maxItems":200,"minItems":1},"field":{"enum":["accepted_records","rejected_records"],"type":"string","default":"accepted_records"}}},"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_7QNF0JZJzLVzSPROUOSYb","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 record routing rows to produce a duplicate key report and a numeric distribution report for accepted_records or rejected_records fields.","exampleAgentPrompt":"Can you run a duplicate key report and numeric distribution on my record routing data — here are 5 rows with row_id, dataset_group, date, accepted_records, and rejected_records — and analyze the accepted_records field?","exampleUseCases":[{"title":"ETL pipeline duplicate key audit","prompt":"I have 150 rows from our nightly ETL record routing job with row_id, dataset_group, date, accepted_records, and rejected_records. Can you run a duplicate key check and show me the numeric distribution for the accepted_records field so I can catch any repeated identifiers?"},{"title":"Rejected records distribution analysis","prompt":"Here are 80 rows of our data ingestion routing logs — each has a row_id, dataset_group, date, accepted_records, and rejected_records. Please give me the duplicate key report and numeric distribution for the rejected_records field so I can see how failure counts are spread."},{"title":"Data quality check before reporting","prompt":"Before I finalize our weekly routing report, can you run a duplicate key report and numeric distribution on these 200 routing records — using the accepted_records field — so I can confirm there are no repeated row IDs and understand the spread of accepted counts?"}],"resultDescription":"Returns two independent analytical reports for the supplied routing data: (1) a duplicate key report identifying repeated row_id or key values within the dataset, and (2) a numeric distribution report showing the frequency or spread of values in the selected field (accepted_records or rejected_records). Results cover up to 200 rows and are computed locally without external lookups.","failureModes":["More than 200 rows submitted — only up to 200 rows are supported","Missing required fields (row_id, dataset_group, date, accepted_records, rejected_records) cause validation errors","Invalid date format (must be YYYY-MM-DD) triggers schema rejection","Numeric values outside the allowed range (-1,000,000,000,000 to 1,000,000,000,000) are rejected","Empty rows array (minItems: 1) causes request failure","Invalid field enum value (must be accepted_records or rejected_records) causes error","Payment not attached or insufficient USDC balance causes x402 rejection"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key report and a numeric distribution on record routing data in a single call for up to 200 rows. It is ideal for data quality checks on ETL or ingestion pipelines where you want to identify repeated identifiers and understand value spread without external lookups or predictions. Prefer it over general analytics tools when working specifically with accepted_records/rejected_records routing metrics and when cost efficiency ($0.01 for two reports) matters.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:53:35.278Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-duplicate-key-report-numeric-distribution-faf9248a"}