# Water Service Coverage — Record Quality Audit + Duplicate Key Report

> Water Service Coverage — Record Quality Audit + 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-11-02).

Runs two local analytical reports on water service coverage data: a record quality audit and a duplicate key detection report, for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-economics-19-003?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-02
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/water-service-coverage-record-quality-audit-duplicate-key-report-6bb06280
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_eIAUxL7tF178DEBhMrXGD

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 water-service-coverage-record-quality-audit-duplicate-key-report-6bb06280 -d '<json body>'
```

Example prompt: Can you audit this water service coverage dataset for record quality issues and flag any duplicate row IDs? I have up to 50 rows with fields like row_id, region, date, served_households, and total_households that I want checked.

## When to prefer this

Choose this endpoint when you need to validate water service coverage records (served_households, total_households) for data quality and duplicate keys in a single low-cost call. It is best suited for batch validation of up to 200 rows before ingestion, reporting, or migration, where no live data lookup or external enrichment is needed and you want two distinct diagnostic reports for a flat $0.01 USDC fee.

## Known failure modes

- Rows array is empty or missing — minimum 1 row required
- More than 200 rows submitted — maxItems limit exceeded
- row_id field is missing or blank — minLength 1 required
- date field does not match YYYY-MM-DD pattern — pattern validation failure
- served_households or total_households values outside ±1,000,000,000,000 range
- Additional properties included in row objects — additionalProperties: false enforced
- Payment not included or insufficient — endpoint requires $0.01 USDC via x402

## How this service works

Water service coverage — Record quality audit + Duplicate key report: Record quality audit + Duplicate key report for supplied water service coverage records (served_households, total_households). 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

Two independent analytical reports: (1) a record quality audit covering completeness, format validity, and value range issues for each row; and (2) a duplicate key report identifying rows with repeated row_id values or other key collisions — all computed locally without any external lookups or live data access.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "region",
     "date",
     "served_households",
     "total_households"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "region": {
      "type": "string",
      "default": "",
      "maxLength": 80
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "total_households": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "served_households": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "region": "group-a",
     "row_id": "row-1",
     "total_households": 1,
     "served_households": 10
    },
    {
     "date": "2026-10-02",
     "region": "group-b",
     "row_id": "row-2",
     "total_households": 2,
     "served_households": 20
    },
    {
     "date": "2026-10-03",
     "region": "group-a",
     "row_id": "row-3",
     "total_households": 3,
     "served_households": 15
    },
    {
     "date": "2026-10-04",
     "region": "group-b",
     "row_id": "row-4",
     "total_households": 4,
     "served_households": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/water-service-coverage-record-quality-audit-duplicate-key-report-6bb06280/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)