# Join Coverage — Duplicate Key Report + Base-100 Series

> Join Coverage — Duplicate Key Report + Base-100 Series 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-23).

Analyzes join coverage data (matched_rows, source_rows) to produce a duplicate key report and a Base-100 indexed series for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-063?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-23
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/join-coverage-duplicate-key-report-base-100-series-23fbbd07
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_iVrigtIbPy_JJbeiAnKA4

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 join-coverage-duplicate-key-report-base-100-series-23fbbd07 -d '<json body>'
```

Example prompt: Run a duplicate key report and base-100 series on my join coverage data — field is matched_rows, start the index at row 0 — here are my rows: group-a had 10 matched out of 1 source on 2026-10-01, group-b had 20 matched out of 2 source on 2026-10-02, group-a had 15 matched out of 3 source on 2026-10-03.

## When to prefer this

Choose this endpoint when you need both a duplicate key audit and a Base-100 normalization series on join coverage data in a single call. It is ideal for data engineers validating ETL join results, analysts checking for key duplication before aggregation, or pipelines that need indexed join metrics without external lookups. Prefer this over single-report endpoints when you need both reports at once for up to 200 rows at minimal cost.

## Known failure modes

- More than 200 rows supplied — request rejected due to maxItems limit
- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error
- date field does not match YYYY-MM-DD pattern — schema validation failure
- base_index out of range (≥ number of rows supplied) — computation error
- All numeric values are null — base-100 series cannot be computed
- Payment not attached or insufficient — x402 payment required error

## How this service works

Join coverage — Duplicate key report + Base-100 series: Duplicate key report + Base-100 series for supplied join coverage records (matched_rows, source_rows). 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 duplicate key report identifying row IDs or keys that appear more than once in the supplied join coverage records, and (2) a Base-100 series that normalizes the selected numeric field (matched_rows or source_rows) relative to the row at the specified base_index. Both reports are computed locally on the supplied data with no external lookups.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "dataset_group",
     "date",
     "matched_rows",
     "source_rows"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "source_rows": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "matched_rows": {
      "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_rows": 1,
     "matched_rows": 10,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "source_rows": 2,
     "matched_rows": 20,
     "dataset_group": "group-b"
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "source_rows": 3,
     "matched_rows": 15,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "source_rows": 4,
     "matched_rows": 30,
     "dataset_group": "group-b"
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "matched_rows",
    "source_rows"
   ],
   "type": "string",
   "default": "matched_rows"
  },
  "base_index": {
   "type": "integer",
   "default": 0,
   "maximum": 199,
   "minimum": 0
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-duplicate-key-report-base-100-series-23fbbd07/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)