# Join Coverage Analytics — Exact Row Deduplication and Keyed Dataset Comparison

> Join Coverage Analytics — Exact Row Deduplication and 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).

Performs exact row deduplication and keyed dataset comparison on two sets of join coverage records (matched_rows, source_rows), returning two independent analytical reports for up to 200 rows each.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-053?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-analytics-exact-row-deduplication-and-keyed-dataset-5fc0c9ed
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_tckrZ8wzINfOQYoEVHInd

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-analytics-exact-row-deduplication-and-keyed-dataset-5fc0c9ed -d '<json body>'
```

Example prompt: I have two sets of join coverage records — one from last week's pipeline run and one from this week's — each with row_id, dataset_group, date, matched_rows, and source_rows fields. Can you deduplicate each set and compare them by key so I can see what changed between the two runs?

## When to prefer this

Choose this endpoint when you need offline, supply-data-only deduplication and keyed comparison of join coverage records (matched_rows, source_rows) with no external data fetching. Ideal for data engineers auditing ETL pipeline outputs, validating join coverage consistency between pipeline runs, or checking dataset snapshots for duplicate or divergent rows. Best suited for small-to-medium datasets (up to 200 rows per call) where two simultaneous analytical reports are needed cheaply at $0.01 USDC.

## Known failure modes

- Input array exceeds 200 rows — request rejected
- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) — validation error
- Malformed date format not matching YYYY-MM-DD pattern — schema validation failure
- Empty rows array (minItems: 1 violated) — validation error
- Numeric values outside allowed range (-1,000,000,000,000 to 1,000,000,000,000) — validation error
- row_id exceeds 80-character maxLength — validation error

## How this service works

Join coverage — Exact row deduplication + Keyed dataset comparison: Exact row deduplication + Keyed dataset comparison 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) an exact row deduplication report identifying duplicate rows within each supplied dataset, and (2) a keyed dataset comparison report highlighting differences between the two input datasets by row_id, dataset_group, and date fields including discrepancies in matched_rows and source_rows values. No external lookups or predictions are made; all analysis uses the supplied data only.

## 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
  },
  "other": {
   "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": [
    {
     "da
… (truncated)
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-analytics-exact-row-deduplication-and-keyed-dataset-5fc0c9ed/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)