# Join Coverage Analytics: Record Quality Audit, Exact Row Deduplication & Duplicate Key Report

> Join Coverage Analytics: Record Quality Audit, Exact Row Deduplication & Duplicate Key Report 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).

Runs three local analytical reports on supplied join coverage records (matched_rows, source_rows): a record quality audit, exact row deduplication, and a duplicate key report — all in one call for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-09-209?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-record-quality-audit-exact-row-deduplication-2884ee73
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_oOnypmlTlCAvcUGTyIqEB

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-record-quality-audit-exact-row-deduplication-2884ee73 -d '<json body>'
```

Example prompt: Run a record quality audit, exact row deduplication, and duplicate key report on these join coverage records — I have 4 rows across two dataset groups (group-a and group-b) with matched_rows and source_rows counts for dates in October 2026.

## When to prefer this

Choose this endpoint when you need a bundled, low-cost ($0.01 USDC) batch analysis of join coverage records and want three reports (quality audit, deduplication, duplicate key detection) in a single call without any external API lookups or live data dependencies. Ideal for data engineering pipelines validating join coverage outputs, or analysts who need quick integrity checks on small datasets (up to 200 rows) without spinning up a dedicated analytics environment.

## Known failure modes

- More than 200 rows supplied — request will be rejected or truncated
- Missing required fields (row_id, dataset_group, date, matched_rows, source_rows) cause validation errors
- Date field not matching YYYY-MM-DD pattern causes schema rejection
- Empty rows array returns error
- Numeric values outside the allowed range (-1e12 to 1e12) cause validation failure

## How this service works

Join coverage — Record quality audit + Exact row deduplication + Duplicate key report: Record quality audit + Exact row deduplication + Duplicate key report for supplied join coverage records (matched_rows, source_rows). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.

## Output

Returns three independent reports: (1) a record quality audit flagging issues such as nulls or out-of-range values in matched_rows/source_rows; (2) an exact row deduplication result listing which rows are duplicates; and (3) a duplicate key report identifying repeated row_id or dataset_group/date combinations — all computed locally from the supplied data with no external lookup.

## 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
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/join-coverage-analytics-record-quality-audit-exact-row-deduplication-2884ee73/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)