# Data Reconciliation — Exact Row Deduplication + Secondary-Measure Weighted Mean

> Data Reconciliation — Exact Row Deduplication + Secondary-Measure Weighted Mean 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).

Deduplicates rows exactly and computes a secondary-measure weighted mean across source/target reconciliation records, returning two analytical reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-051?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-exact-row-deduplication-secondary-measure-746b5531
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_tJmz4v9w5dbiRFl1S_GIP

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-exact-row-deduplication-secondary-measure-746b5531 -d '<json body>'
```

Example prompt: Can you run exact row deduplication and a secondary-measure weighted mean on my reconciliation data? I have rows grouped into 'group-a' and 'group-b' with dates in October 2026, source_totals and target_totals for each row — use source_total as the field and give me both reports.

## When to prefer this

Choose this endpoint when you need both exact row deduplication and a secondary-measure weighted mean on reconciliation data (source_total vs target_total) in a single low-cost call. It is ideal for data quality pipelines where duplicate rows must be removed before computing weighted aggregates across dataset groups. Prefer this over general analytics tools when you want two focused reconciliation reports at $0.01 USDC with no external dependencies, live lookups, or professional assessments — purely local, deterministic computation on your supplied rows.

## Known failure modes

- More than 200 rows submitted — request rejected due to maxItems limit
- Missing required fields (row_id, dataset_group, date, source_total, or target_total) — validation error
- Invalid date format (not YYYY-MM-DD pattern) — schema validation failure
- source_total or target_total outside ±1,000,000,000,000 range — value rejected
- Invalid field enum value (not 'source_total' or 'target_total') — rejected
- Empty rows array (minItems: 1 not met) — request fails
- Payment not included or insufficient — x402 payment required error

## How this service works

Data reconciliation — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean 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 analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate rows from the supplied reconciliation data, and (2) a secondary-measure weighted mean computation over the selected field (source_total or target_total), grouped as appropriate. Both reports are produced locally without external lookups or predictions, covering up to 200 input rows.

## 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"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/data-reconciliation-exact-row-deduplication-secondary-measure-746b5531/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)