{"uid":"cap_1XNVebLUwzCVPDoKSX1MM","slug":"record-routing-analytics-exact-row-deduplication-trailing-mean-series-99839a49","name":"Record Routing Analytics — Exact Row Deduplication + Trailing Mean Series","description":"Record routing — Exact row deduplication + Trailing mean series: Exact row deduplication + Trailing mean series 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-045?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"},"window":{"type":"integer","default":2,"maximum":200,"minimum":2}}},"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_AnqWWm2P5MyBwI5kjS_SE","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":"Deduplicates exact rows and computes trailing mean time series for accepted_records and rejected_records in record routing datasets, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate my record routing data and compute a trailing mean series with a window of 3 for the accepted_records field? I have rows for groups A and B from October 2026, up to about 50 rows total.","exampleUseCases":[{"title":"Daily routing data quality check","prompt":"I have 120 rows of record routing logs with accepted and rejected counts per day — can you deduplicate exact duplicate rows and give me a trailing mean series for accepted_records using a window of 5?"},{"title":"Rejected records trend analysis","prompt":"Run deduplication and a rolling mean analysis on my record routing dataset — focus on the rejected_records field with a window of 7, I have about 80 rows across two dataset groups from Q3."},{"title":"ETL pipeline audit for routing records","prompt":"Before I load this batch, can you clean up any exact duplicate rows in my routing records and also show me the trailing mean with window 2 for accepted_records so I can spot anomalies? It's about 40 rows."}],"resultDescription":"Two analytical reports: (1) a deduplicated version of the input rows with exact duplicate rows removed, and (2) a trailing mean time series computed over the specified field (accepted_records or rejected_records) using the given window size, for up to 200 input rows. No external lookups or predictions are made — all processing is local.","failureModes":["Input exceeds 200 rows — request rejected","Missing required fields (row_id, date, accepted_records, rejected_records) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Window size outside [2, 200] range returns schema validation error","All rows are duplicates — dedup report returns empty or single-row result","Insufficient rows for window size — trailing mean series may be sparse or empty"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and trailing mean time series computation on record routing data (accepted/rejected record counts) in a single API call at low cost ($0.01 USDC for two reports). It is ideal for data quality pipelines, ETL auditing, and trend analysis on routing metrics without needing external data sources or live lookups. Prefer this over general-purpose analytics tools when your data fits within 200 rows and you want a lightweight, self-contained, paid micro-analytics service.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-23T18:55:19.273Z","isFirstParty":false,"canonicalSlug":"record-routing-analytics-exact-row-deduplication-trailing-mean-series-99839a49"}