# Data Reconciliation — Duplicate Key Report + Explicit Missing-Value Fill

> Data Reconciliation — Duplicate Key Report + Explicit Missing-Value Fill 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-15).

Identifies duplicate row keys and fills missing values (via zero, mean, or median) in up to 200 reconciliation records comparing source_total and target_total fields.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-070?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/data-reconciliation-duplicate-key-report-explicit-missing-value-fill-937a2dbe
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_4dC5WkeDb6n59T3YPwV6e

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-explicit-missing-value-fill-937a2dbe -d '<json body>'
```

Example prompt: Check my reconciliation data for duplicate row IDs and fill any missing source_total values using the median — here are the rows: [{"row_id":"row-1","dataset_group":"group-a","date":"2026-10-01","source_total":10,"target_total":null},{"row_id":"row-1","dataset_group":"group-a","date":"2026-10-02","source_total":null,"target_total":2}].

## When to prefer this

Choose this endpoint when you need two specific data quality operations — duplicate key detection and null imputation — applied together to reconciliation data (source vs. target totals) in a single low-cost call. It is ideal for data pipeline validation, pre-audit cleanup, and ETL quality checks on tabular reconciliation records up to 200 rows. It does not perform live lookups, predictions, or external actions, making it suitable for deterministic, offline analytical use cases.

## Known failure modes

- Input array exceeds 200 rows — request will be rejected
- Row missing required fields (row_id, dataset_group, date, source_total, target_total) — validation error
- Invalid date format (not YYYY-MM-DD) — schema validation failure
- source_total or target_total outside allowed range (-1e12 to 1e12) — validation error
- Invalid method or field enum value — schema rejection
- Empty rows array — minItems constraint violation

## How this service works

Data reconciliation — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill 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 reports: (1) a duplicate key report listing all row_ids that appear more than once in the input, and (2) a missing-value fill report showing the original and imputed values for any null entries in the specified field (source_total or target_total), filled using the chosen method (zero, mean, or median). Covers up to 200 input rows per call.

## 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"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/data-reconciliation-duplicate-key-report-explicit-missing-value-fill-937a2dbe/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)