# Join Coverage Analytics — Exact Row Deduplication + Numeric Row Ordering

> Join Coverage Analytics — Exact Row Deduplication + Numeric Row Ordering 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-12).

Deduplicates exact rows and applies numeric ordering to join coverage records (matched_rows, source_rows) across up to 200 rows, producing 2 analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-042?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-12
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/join-coverage-analytics-exact-row-deduplication-numeric-row-ordering-e5613210
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_blevDkgJ70a0BVP9cUt2l

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-numeric-row-ordering-e5613210 -d '<json body>'
```

Example prompt: Can you deduplicate and numerically order my join coverage records for the matched_rows field? I have rows like: row-1 on 2026-10-01 with matched_rows=10 and source_rows=1 in group-a, row-2 on 2026-10-02 with matched_rows=20 and source_rows=2 in group-b — run the two local analytical reports on those.

## When to prefer this

Choose this endpoint when you have up to 200 join coverage records and need both exact row deduplication and numeric ordering in a single low-cost call ($0.01 USDC for 2 reports). It is ideal for data quality checks, ETL validation, and reconciliation tasks where you supply your own data and need fast, local analytical processing without any external lookups, ML predictions, or live data enrichment.

## Known failure modes

- More than 200 rows submitted — request exceeds 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
- Numeric values exceed allowed range (±1,000,000,000,000) — validation error
- Empty rows array (minItems: 1 not met) — request rejected
- Invalid field enum value (must be matched_rows or source_rows) — schema error

## How this service works

Join coverage — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering 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 on the supplied join coverage rows: one applying exact row deduplication (identifying and collapsing identical rows) and one applying numeric row ordering on the selected field (matched_rows or source_rows), all computed locally without external lookups or predictions.

## 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-analytics-exact-row-deduplication-numeric-row-ordering-e5613210/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)