{"uid":"cap_d_K897p2e-gW7cpIHWNFT","slug":"record-routing-analytics-duplicate-key-report-two-measure-correlation-9502cdb6","name":"Record Routing Analytics — Duplicate Key Report + Two-Measure Correlation","description":"Record routing — Duplicate key report + Two-measure correlation: Duplicate key report + Two-measure correlation 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-066?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}}},"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_4Mw39-b-hapvBGbUa50wV","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 two-measure correlation between accepted_records and rejected_records.","exampleAgentPrompt":"Can you run a duplicate key check and a correlation analysis on my record routing data? I have rows with row_id, date, dataset_group, accepted_records, and rejected_records — here are my 50 rows grouped into group-a and group-b across October 2026.","exampleUseCases":[{"title":"ETL pipeline duplicate key audit","prompt":"I need to check my ETL record routing logs for duplicate row IDs — can you run a duplicate key report on these 120 rows? Each row has a row_id, date, dataset_group, accepted_records, and rejected_records."},{"title":"Acceptance vs rejection correlation check","prompt":"Can you calculate the correlation between accepted_records and rejected_records across my routing dataset? I have about 80 rows spanning two dataset groups, group-a and group-b, from November 2026."},{"title":"Data quality validation before ingestion","prompt":"Before I load this batch into the warehouse, can you scan these 200 record routing rows for any duplicate row keys and tell me how strongly the accepted and rejected counts move together?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any repeated row_id values across the submitted rows, and (2) a two-measure correlation report quantifying the statistical relationship between accepted_records and rejected_records across all submitted data.","failureModes":["Rows exceeding 200 items will be rejected — keep input within maxItems limit","Missing required fields (row_id, date, dataset_group, accepted_records, rejected_records) will cause validation errors","Malformed date strings not matching YYYY-MM-DD pattern will fail schema validation","Supplying only one row makes correlation statistically meaningless — at least a few rows are needed for meaningful correlation","null values in accepted_records or rejected_records are allowed but may reduce correlation reliability"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key integrity check and a two-measure correlation between accepted and rejected record counts in a single low-cost call ($0.01 USDC). It is ideal for lightweight, offline data quality validation of record routing batches up to 200 rows, with no external lookups or live data dependencies. Prefer it over general-purpose analytics tools when you need a quick, deterministic, self-contained report on routing record data quality and measure relationships.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:53:18.881Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-duplicate-key-report-two-measure-correlation-9502cdb6"}