# Data Reconciliation — Duplicate Key Report + IQR Outlier Flags

> Data Reconciliation — Duplicate Key Report + IQR Outlier Flags 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-24).

Analyzes up to 200 reconciliation rows to produce a duplicate key report and IQR-based outlier flags for source_total or target_total values.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-065?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-24
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/data-reconciliation-duplicate-key-report-iqr-outlier-flags-49711d25
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_0j5dD8S-zM8DbbnOz82W9

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-iqr-outlier-flags-49711d25 -d '<json body>'
```

Example prompt: Check my reconciliation data for duplicate row IDs and IQR outlier flags on source_total — I have 4 rows: row-1 on 2026-10-01 with source 10 and target 1 in group-a, row-2 on 2026-10-02 with source 20 and target 2 in group-b, row-3 on 2026-10-03 with source 15 and target 3 in group-a, and row-4 on 2026-10-04 with source 30 and target 4 in group-b.

## When to prefer this

Choose this endpoint when you need two complementary data quality checks — duplicate key detection and IQR-based outlier flagging — run together on reconciliation data (source_total vs target_total) in a single low-cost call. Ideal for ETL pipeline validation, financial reconciliation audits, and pre-reporting data integrity checks on datasets up to 200 rows. It performs purely local computation with no external network calls, making it deterministic and fast. Prefer this over manual scripts or heavier analytics platforms when you need a quick, structured, agent-friendly reconciliation health check.

## Known failure modes

- More than 200 rows submitted — request will be rejected or truncated
- Missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error
- Invalid date format (not YYYY-MM-DD) — schema validation failure
- Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — validation error
- Too few rows to compute meaningful IQR (e.g. single row) — outlier report may be empty or trivial
- Invalid field enum value (not source_total or target_total) — schema rejection

## How this service works

Data reconciliation — Duplicate key report + IQR outlier flags: Duplicate key report + IQR outlier flags 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 across the submitted rows, and (2) an IQR outlier flags report marking rows whose source_total or target_total values fall outside the interquartile range bounds. Both reports are derived entirely from the supplied data using local analytical engines, with no 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"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/data-reconciliation-duplicate-key-report-iqr-outlier-flags-49711d25/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)