# Validation Rule Results — Exact Row Deduplication + Explicit Missing-Value Fill

> Validation Rule Results — Exact Row Deduplication + Explicit Missing-Value Fill 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-11).

Deduplicates exact duplicate rows and fills missing values in validation rule result records (passed_rules, total_rules) using a chosen fill strategy, producing 2 analytical reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-08-054?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-11
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/validation-rule-results-exact-row-deduplication-explicit-missing-8ea1f971
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_1C_YShokhwmMG5Ej3X0L8

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 validation-rule-results-exact-row-deduplication-explicit-missing-8ea1f971 -d '<json body>'
```

Example prompt: Can you deduplicate my validation rule results and fill any missing passed_rules values using median — here are up to 200 rows with row_id, dataset_group, date, passed_rules, and total_rules fields?

## When to prefer this

Choose this endpoint when you have validation rule result records (passed_rules, total_rules) that contain exact duplicate rows or missing numeric values and you need lightweight, local data cleaning without any external lookups, predictions, or side effects. It is ideal for pre-processing data quality metrics before reporting or downstream analysis, especially when you need both deduplication and missing-value imputation in a single call for up to 200 rows at minimal cost.

## Known failure modes

- Fewer than 1 row supplied — request rejected
- More than 200 rows supplied — request rejected
- Invalid date format (not YYYY-MM-DD) — validation error
- Missing required fields (row_id, dataset_group, date) — schema error
- Numeric values outside allowed range — validation error
- Invalid fill method enum value — schema error
- Invalid field enum value — schema error

## How this service works

Validation rule results — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied validation rule results records (passed_rules, total_rules). 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 analytical reports covering the supplied validation rule result records: one for passed_rules and one for total_rules. Each report reflects the dataset after exact duplicate rows have been removed and missing values in the specified field have been filled using the chosen method (zero, mean, or median). No external lookups or predictions are performed; all processing uses local analytical engines.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "dataset_group",
     "date",
     "passed_rules",
     "total_rules"
    ],
    "properties": {
     "date": {
      "type": "string",
      "default": "",
      "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
      "maxLength": 10
     },
     "row_id": {
      "type": "string",
      "default": "",
      "maxLength": 80,
      "minLength": 1
     },
     "total_rules": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "passed_rules": {
      "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",
     "total_rules": 1,
     "passed_rules": 10,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "total_rules": 2,
     "passed_rules": 20,
     "dataset_group": "group-b"
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "total_rules": 3,
     "passed_rules": 15,
     "dataset_group": "group-a"
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "total_rules": 4,
     "passed_rules": 30,
     "dataset_group": "group-b"
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "passed_rules",
    "total_rules"
   ],
   "type": "string",
   "default": "passed_rules"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/validation-rule-results-exact-row-deduplication-explicit-missing-8ea1f971/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)