# Data Reconciliation — Duplicate Key Report + Date by Category Pivot

> Data Reconciliation — Duplicate Key Report + Date by Category Pivot 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).

Generates two analytical reports from supplied reconciliation rows: a duplicate key report and a date-by-category pivot table comparing source and target totals.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-11-068?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-duplicate-key-report-date-by-category-pivot-86d5a551
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_RFiUzMD08Ly08gc0C-1xc

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-date-by-category-pivot-86d5a551 -d '<json body>'
```

Example prompt: Check my reconciliation records for duplicate row IDs and also generate a date-by-category pivot for source_total — here are the rows: row-1, 2026-10-01, group-a, source 10, target 1; row-2, 2026-10-02, group-b, source 20, target 2; row-3, 2026-10-01, group-a, source 15, target 3.

## When to prefer this

Choose this endpoint when you need two specific analytical outputs — a duplicate key report and a date-by-category pivot — from a batch of reconciliation records (up to 200 rows) without any external data lookups. It is ideal for ETL validation, data migration checks, and finance reconciliation workflows where you supply source and target totals and want offline, deterministic analysis at very low cost ($0.01 USDC for both reports).

## Known failure modes

- Missing required fields (row_id, date, dataset_group, source_total, target_total) causes validation error
- More than 200 rows submitted exceeds the maxItems limit and will be rejected
- Invalid date format (not YYYY-MM-DD) fails pattern validation
- Numeric values outside ±1,000,000,000,000 range are rejected
- Empty rows array (minItems: 1) returns an error
- Invalid field enum value (not source_total or target_total) causes schema rejection

## How this service works

Data reconciliation — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot 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 identifying any repeated row_id values across the supplied rows, and (2) a date-by-category pivot table showing the selected field (source_total or target_total) aggregated by date and dataset_group, covering up to 200 input rows.

## 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-date-by-category-pivot-86d5a551/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)