{"uid":"cap_IjM7iyA_C2fRk3h3DirUj","slug":"data-reconciliation-duplicate-key-report-trailing-mean-series-f80777b2","name":"Data Reconciliation — Duplicate Key Report + Trailing Mean Series","description":"Data reconciliation — Duplicate key report + Trailing mean series: Duplicate key report + Trailing mean series 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-061?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},"field":{"enum":["source_total","target_total"],"type":"string","default":"source_total"},"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_4NMi3EPStpeF8sVyuWzWQ","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":"Generates two local analytical reports for data reconciliation rows: a duplicate key report and a trailing mean series, for up to 200 source/target records.","exampleAgentPrompt":"I have a set of reconciliation rows with row IDs, dates, dataset groups, source totals, and target totals — can you run a duplicate key report and a trailing mean series (window of 3) on the source_total field for these up to 50 rows?","exampleUseCases":[{"title":"ETL pipeline reconciliation quality check","prompt":"I just ran an ETL job and have 120 reconciliation records with row IDs, dates, groups, and source vs target totals — can you generate a duplicate key report and a trailing mean series with a window of 5 on source_total so I can spot repeated keys and smooth out the trend?"},{"title":"Finance team daily source-target variance review","prompt":"Here are 80 daily finance reconciliation rows across two dataset groups — run a duplicate key report and compute a trailing mean series with window size 7 on target_total so we can review rolling averages and catch any duplicate entries."},{"title":"Data audit before month-end close","prompt":"Before we close the books, I need to audit these 150 reconciliation records — please generate a duplicate key report and a trailing mean series using a window of 10 on source_total to check for repeated row IDs and see the smoothed trend over time."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any row_id values that appear more than once in the submitted data, and (2) a trailing mean series showing the rolling average of the selected field (source_total or target_total) over the specified window size, computed locally without any external lookups or predictions.","failureModes":["Fewer than 1 row submitted — minItems constraint violated","More than 200 rows submitted — maxItems constraint violated","Invalid date format (not YYYY-MM-DD) — pattern validation failure","source_total or target_total outside ±1,000,000,000,000 range — schema validation error","row_id missing or empty string — minLength constraint violated","window value less than 2 or greater than 200 — schema validation error","field value not 'source_total' or 'target_total' — enum validation error"],"whenToPreferThis":"Choose this endpoint when you need both duplicate key detection and a trailing/rolling mean time series computed together on reconciliation data in a single low-cost call ($0.01 USDC for both reports). It is ideal for ETL quality checks, finance reconciliation audits, and data pipeline validation where you have up to 200 rows with source and target totals and need purely local analytical computation — no external data lookups, predictions, or live integrations are involved.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T12:43:00.221Z","isFirstParty":false,"canonicalSlug":"data-reconciliation-duplicate-key-report-trailing-mean-series-f80777b2"}