# Data Reconciliation — Duplicate Key Report + Trailing Mean Series

> Data Reconciliation — Duplicate Key Report + Trailing Mean Series is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-10-19).

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.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-061?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-19
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/data-reconciliation-duplicate-key-report-trailing-mean-series-f80777b2
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_IjM7iyA_C2fRk3h3DirUj

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability data-reconciliation-duplicate-key-report-trailing-mean-series-f80777b2 -d '<json body>'
```

Example prompt: 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?

## When to prefer this

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.

## Known failure modes

- 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

## How this service works

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.

## Output

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.

## Request schema (JSON Schema)

```json
{
 "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
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/data-reconciliation-duplicate-key-report-trailing-mean-series-f80777b2/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from market.datapackvibe.com](https://www.zero.xyz/host/market.datapackvibe.com/llms.txt)