# Data Reconciliation — Exact Row Deduplication + Keyed Dataset Comparison

> Data Reconciliation — Exact Row Deduplication + Keyed Dataset Comparison 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 and compares two keyed datasets to identify discrepancies between source and target totals, producing two independent reconciliation reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-053?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-keyed-dataset-comparison-a9d376b0
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_hMRZ-YFqz-5wRXmaBSGfQ

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-keyed-dataset-comparison-a9d376b0 -d '<json body>'
```

Example prompt: I have two datasets of up to 200 rows each with row_id, date, dataset_group, source_total, and target_total — can you deduplicate each dataset and compare them side by side to show me where the source and target totals diverge?

## When to prefer this

Choose this endpoint when you need both exact row deduplication and a keyed comparison of two datasets (source vs target totals) in a single $0.01 call, without needing live data lookups, predictions, or external integrations. It is well-suited for financial reconciliation, ETL output validation, and audit workflows where datasets are small enough to supply inline (up to 200 rows each) and where deterministic, local analytical computation is sufficient.

## Known failure modes

- Input array exceeds 200 rows — request will be rejected
- Missing required fields (row_id, dataset_group, date, source_total, target_total) on any row — validation error
- date field does not match YYYY-MM-DD pattern — schema validation failure
- source_total or target_total outside allowed range (-1e12 to 1e12) — schema validation failure
- Empty rows array (minItems:1 not met) — validation error
- Payment not processed — x402 payment required before response is returned

## How this service works

Data reconciliation — Exact row deduplication + Keyed dataset comparison: Exact row deduplication + Keyed dataset comparison 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

Two independent analytical reports: (1) an exact row deduplication report identifying duplicate rows within the supplied dataset, and (2) a keyed dataset comparison report showing matches, mismatches, and discrepancies between source_total and target_total values across both datasets, keyed by row_id, date, and dataset_group. No external lookups or live data are used.

## 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
  },
  "other": {
   "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": [
    {

… (truncated)
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/data-reconciliation-exact-row-deduplication-keyed-dataset-comparison-a9d376b0/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)