# Data Reconciliation — Exact Row Deduplication + Numeric Interval Filter

> Data Reconciliation — Exact Row Deduplication + Numeric Interval Filter 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 filters records by a numeric interval for source/target reconciliation datasets of up to 200 rows, returning two analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-043?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-numeric-interval-filter-7c85c05e
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_81HO2dD1InPyfVOkpsOYV

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-numeric-interval-filter-7c85c05e -d '<json body>'
```

Example prompt: Deduplicate my reconciliation rows exactly and filter source_total between 10 and 500 — here are my records: row-1, group-a, 2026-10-01, source 10, target 1; row-2, group-b, 2026-10-02, source 20, target 2; row-1, group-a, 2026-10-01, source 10, target 1 (duplicate). Give me both the deduplication report and the interval filter report.

## When to prefer this

Choose this endpoint when you need two simultaneous local analytical operations on a reconciliation dataset — exact row deduplication and numeric interval filtering — without any external lookups, predictions, or professional assessments. It is ideal for data quality pipelines, ETL validation steps, and financial reconciliation audits on datasets up to 200 rows where you want both reports in a single $0.01 call.

## Known failure modes

- More than 200 rows submitted — exceeds maxItems limit, request rejected
- Invalid date format (not YYYY-MM-DD) — schema validation error
- source_total or target_total outside ±1,000,000,000,000 — schema validation error
- minimum greater than maximum — may produce empty interval-filter result
- Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error
- Payment not included or insufficient USDC — x402 payment required error

## How this service works

Data reconciliation — Exact row deduplication + Numeric interval filter: Exact row deduplication + Numeric interval filter 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) a deduplicated dataset with exact duplicate rows removed, and (2) a subset of rows where the chosen field (source_total or target_total) falls within the specified numeric interval [minimum, maximum]. Both reports operate on the supplied rows without any live lookups or external data.

## 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"
  },
  "maximum": {
   "type": "number",
   "default": 100,
   "maximum": 1000000000000,
   "minimum": -1000000000000
  },
  "minimum": {
   "type": "number",
   "default": 0,
   "maximum": 1000000000000,
   "minimum": -1000000000000
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/data-reconciliation-exact-row-deduplication-numeric-interval-filter-7c85c05e/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)