# Duplicate Observations — Exact Row Deduplication + Daily Sum Series

> Duplicate Observations — Exact Row Deduplication + Daily Sum Series 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).

Performs exact row deduplication analysis and computes a daily sum time series for supplied duplicate-observation records, returning two independent analytical reports in a single call.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-analytics-04-044?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-daily-sum-series-7411285a
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_hewp5u6jlW0BTRfbTH4uo

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-daily-sum-series-7411285a -d '<json body>'
```

Example prompt: I have a batch of observation records with fields row_id, dataset_group, date, duplicate_rows, and total_rows — can you run exact row deduplication and a daily sum series on them, focusing on the duplicate_rows field? Here's my data: row-1 on 2026-10-01 in group-a with 10 duplicates out of 1 total, row-2 on 2026-10-02 in group-b with 20 duplicates out of 2 total.

## When to prefer this

Choose this endpoint when you need both a deduplication report and a daily sum time series computed together in a single low-cost call (0.01 USDC for both reports), using only your supplied data with no external lookups. Ideal for data quality workflows where you want to identify exact duplicate records and simultaneously understand how duplicate or total row counts trend day-by-day across dataset groups, especially when working with up to 200 rows at a time.

## Known failure modes

- Input array exceeds 200 rows — request rejected
- Missing required fields (row_id, dataset_group, date, duplicate_rows, total_rows) — validation error
- Date strings not matching YYYY-MM-DD pattern — schema validation failure
- Numeric values outside the allowed range (±1,000,000,000,000) — rejection
- Empty rows array — minimum items constraint violated
- Payment not provided or insufficient — x402 payment required error

## How this service works

Duplicate observations — Exact row deduplication + Daily sum series: Exact row deduplication + Daily sum series 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: (1) an exact row deduplication report identifying and collapsing identical records from the supplied dataset, and (2) a daily sum time series aggregating the selected field (duplicate_rows or total_rows) by date — both computed locally from the submitted rows without any external lookup.

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/duplicate-observations-exact-row-deduplication-daily-sum-series-7411285a/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)