# Duplicate Observations — Exact Row Deduplication + Numeric Interval Filter

> Duplicate Observations — Exact Row Deduplication + Numeric Interval Filter 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-18).

Analyzes supplied duplicate-observation records to perform exact row deduplication and filter rows by a numeric interval on a chosen field, returning two independent analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-04-043?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-18
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/duplicate-observations-exact-row-deduplication-numeric-interval-filter-d2fc7e56
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_ranQHvbzzJSjddtt1YWJU

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 duplicate-observations-exact-row-deduplication-numeric-interval-filter-d2fc7e56 -d '<json body>'
```

Example prompt: I have 4 observation records for groups 'group-a' and 'group-b' with duplicate_rows and total_rows counts — can you deduplicate them exactly and also filter by duplicate_rows between 10 and 25, giving me both reports?

## When to prefer this

Choose this endpoint when you need to perform both exact row deduplication and numeric interval filtering on a set of up to 200 pre-supplied observation records in a single call, without requiring external data lookups or live data sources. It is ideal for data quality workflows, ETL auditing, and batch dataset analysis where the data is already in hand and two distinct analytical reports are needed cheaply ($0.01 USDC).

## Known failure modes

- Input array exceeds 200 rows — request rejected
- Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error
- Invalid date format (must match YYYY-MM-DD) — schema validation failure
- Minimum value greater than maximum value — may return empty filter results
- Null numeric values for duplicate_rows or total_rows — may affect interval filter output
- Payment not completed (x402 protocol) — endpoint not executed

## How this service works

Duplicate observations — Exact row deduplication + Numeric interval filter: Exact row deduplication + Numeric interval filter for supplied duplicate observations records (duplicate_rows, total_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 per call: (1) an exact row deduplication report identifying and removing duplicate records from the supplied observations, and (2) a numeric interval filter report listing rows where the chosen field (duplicate_rows or total_rows) falls within the specified minimum–maximum range. Covers up to 200 input rows.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/duplicate-observations-exact-row-deduplication-numeric-interval-filter-d2fc7e56/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)