# Data Reconciliation — Exact Row Deduplication + Equal-Width Histogram

> Data Reconciliation — Exact Row Deduplication + Equal-Width Histogram 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 computes an equal-width histogram over source_total or target_total values from supplied reconciliation data, returning two analytical reports in a single call.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-048?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-equal-width-histogram-c04a5c70
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_ah2I8pmZfHEreyy_5uFo0

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-equal-width-histogram-c04a5c70 -d '<json body>'
```

Example prompt: Deduplicate these reconciliation rows and give me an equal-width histogram with 10 bins over the source_total field — here are my records: row-1, group-a, 2024-01-01, source=500, target=480; row-2, group-b, 2024-01-02, source=600, target=610; row-3, group-a, 2024-01-01, source=500, target=480 (duplicate of row-1).

## When to prefer this

Choose this endpoint when you need both exact row deduplication and a frequency histogram over reconciliation totals in a single low-cost call (up to 200 rows). It is ideal for data quality checks before reporting, ETL validation, or audit workflows where you want to understand the distribution of source or target values while simultaneously cleaning duplicates. Prefer it over general-purpose analytics tools when working specifically with source_total/target_total reconciliation records and needing two reports for $0.01.

## Known failure modes

- More than 200 rows submitted — request rejected, maxItems limit exceeded
- Missing required fields (row_id, dataset_group, date, source_total, target_total) on any row — validation error
- Date format not matching YYYY-MM-DD pattern — schema validation failure
- bins value outside 1–30 range — rejected by schema
- All values are null for the chosen field — histogram cannot be computed
- Malformed JSON body — parse error returned

## How this service works

Data reconciliation — Exact row deduplication + Equal-width histogram: Exact row deduplication + Equal-width histogram 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 reports: (1) a deduplicated list of rows with exact duplicates removed, and (2) an equal-width histogram of the chosen field (source_total or target_total) divided into the specified number of bins, showing bin ranges and record counts. Both reports are computed locally from the supplied data with no external lookups.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "bins": {
   "type": "integer",
   "default": 5,
   "maximum": 30,
   "minimum": 1
  },
  "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-equal-width-histogram-c04a5c70/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)