# Join Coverage Duplicate Key Report and Numeric Distribution

> Join Coverage Duplicate Key Report and Numeric Distribution 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).

Analyzes join coverage data (matched_rows, source_rows) to produce a duplicate key report and numeric distribution summary for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-055?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/join-coverage-duplicate-key-report-and-numeric-distribution-a4cfa27e
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_AYkUSH_o0gN2Qjfk9r-Qx

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-and-numeric-distribution-a4cfa27e -d '<json body>'
```

Example prompt: Run a duplicate key report and numeric distribution on my join coverage data — I have 4 rows with matched_rows and source_rows for groups 'group-a' and 'group-b' across dates 2026-10-01 to 2026-10-04, and I want to analyze the matched_rows field.

## When to prefer this

Choose this endpoint when you need both a duplicate key diagnostic and a numeric distribution analysis on join coverage data in a single paid call. It is purpose-built for ETL and data quality workflows where matched_rows and source_rows are the key metrics, and avoids the need for two separate API calls. Best for datasets up to 200 rows where local analytical computation is sufficient and no live data lookup or external enrichment is needed.

## Known failure modes

- Input array empty or missing — returns validation error
- More than 200 rows submitted — rejected with maxItems error
- Invalid date format (not YYYY-MM-DD) — schema validation failure
- Numeric values outside allowed range (±1,000,000,000,000) — rejected
- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — schema error
- Invalid field enum value (not 'matched_rows' or 'source_rows') — rejected

## How this service works

Join coverage — Duplicate key report + Numeric distribution: Duplicate key report + Numeric distribution 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 independent analytical reports: (1) a duplicate key report identifying any repeated row IDs or key collisions in the supplied join coverage records, and (2) a numeric distribution summary (e.g. min, max, mean, percentiles, histogram bins) for the selected numeric field (matched_rows or source_rows), 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",
     "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"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-duplicate-key-report-and-numeric-distribution-a4cfa27e/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)