{"uid":"cap_iiU58w3qW_7URIMlrbmAr","slug":"record-routing-analytics-exact-row-deduplication-secondary-measure-67c95031","name":"Record Routing Analytics: Exact Row Deduplication + Secondary-Measure Weighted Mean","description":"Record routing — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean 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-051?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_m6JfeZSkmv5rRYJ0lY9bH","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":"Performs exact row deduplication and secondary-measure weighted mean analysis on record routing data (accepted_records, rejected_records) for up to 200 rows, returning two analytical reports.","exampleAgentPrompt":"Deduplicate my record routing rows and compute a weighted mean for accepted_records across these entries — I have 4 rows for dates 2026-10-01 through 2026-10-04 with group-a and group-b, accepted counts of 10, 20, 15, 30 and rejected counts of 1, 2, 3, 4.","exampleUseCases":[{"title":"Deduplicating daily routing pipeline logs","prompt":"I have a week of record routing logs with possible duplicate rows — can you run exact deduplication and a weighted mean on accepted_records across these 50 rows grouped by dataset group and date?"},{"title":"Quality audit on rejected record counts","prompt":"Run deduplication and compute the weighted mean for rejected_records across my 120 record routing entries — I want to see which rows are exact duplicates and what the weighted average rejection rate looks like per group."},{"title":"Comparing routed record metrics across groups","prompt":"I have two dataset groups, group-a and group-b, each with about 80 record routing rows. Can you deduplicate them and give me a weighted mean on accepted_records so I can compare throughput between groups?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying duplicate rows in the submitted record routing dataset, and (2) a secondary-measure weighted mean report computing the weighted average of the selected field (accepted_records or rejected_records) across the submitted rows — all computed locally without external lookups.","failureModes":["Missing required fields (row_id, date, dataset_group, accepted_records, rejected_records) cause validation errors","Date strings not matching YYYY-MM-DD pattern are rejected","Submitting more than 200 rows exceeds the row limit and returns an error","Null values in both accepted_records and rejected_records may produce undefined weighted mean output","Empty rows array (minItems: 1 violated) returns a schema validation error"],"whenToPreferThis":"Choose this endpoint when you need both exact row-level deduplication and a weighted mean computation on record routing data in a single low-cost call. It is ideal for data pipeline quality checks where you want to flag duplicate routing records and summarize accepted or rejected record metrics by group. Prefer it over general-purpose analytics when your dataset is small (≤200 rows), your fields map to accepted_records and rejected_records, and you want two bundled reports at minimal cost without requiring external lookups or predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:46:57.138Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-exact-row-deduplication-secondary-measure-67c95031"}