# Data Reconciliation: Category Frequencies + Keyed Dataset Comparison

> Data Reconciliation: Category Frequencies + 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).

Compares two datasets of up to 200 rows, producing category frequency distributions and a keyed row-level comparison report to surface reconciliation discrepancies between source and target totals.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-111?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-category-frequencies-keyed-dataset-comparison-1f28d65a
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_r-OZIY46vgR1ib0CmGUtB

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-category-frequencies-keyed-dataset-comparison-1f28d65a -d '<json body>'
```

Example prompt: I have two sets of reconciliation records — each with row IDs, dataset groups, dates, and source and target totals — can you run a category frequency breakdown and a keyed row-by-row comparison to find discrepancies between them? Here's the first dataset with 4 rows across group-a and group-b for October 2026, and a second dataset with slightly different source totals for the same rows.

## When to prefer this

Choose this endpoint when you need to simultaneously audit the categorical composition of a reconciliation dataset AND perform a row-keyed comparison between source and target totals — for up to 200 rows — without requiring any external data lookup or live system access. It is ideal for ETL validation, financial close reconciliation, and data migration integrity checks where you already have both source and target figures in hand and want two complementary analytical perspectives in a single low-cost call.

## Known failure modes

- Input array exceeds 200 rows — request will be rejected
- Missing required fields (row_id, dataset_group, date, source_total, target_total) in any row — validation error
- Date fields not matching YYYY-MM-DD pattern — schema validation failure
- source_total or target_total outside ±1,000,000,000,000 range — rejected
- Empty rows array (minItems:1 not satisfied) — error returned
- Payment of 0.01 USDC not completed — endpoint returns 402

## How this service works

Data reconciliation — Category frequencies + Keyed dataset comparison: Category frequencies + 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

Returns two analytical reports: (1) a category frequency distribution showing how often each dataset_group appears across the submitted rows, and (2) a keyed dataset comparison that aligns rows from both datasets by row_id and highlights differences between source_total and target_total values. Both reports are computed locally without external lookups.

## 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-category-frequencies-keyed-dataset-comparison-1f28d65a/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)