# API Usage Exact Row Deduplication

> API Usage Exact Row Deduplication 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-28).

Removes exact duplicate rows from API usage records (endpoint, date, requests, latency_ms) and returns a deduplicated set of up to 200 typed records.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-sector-analytics-api-usage-deduplicate?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-28
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/api-usage-exact-row-deduplication-ad9f4266
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_bbGgaWL_ASMTcCmvHPnoG

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 api-usage-exact-row-deduplication-ad9f4266 -d '<json body>'
```

Example prompt: I have a list of API usage records with endpoint names, dates, request counts, and latency values — can you deduplicate them and give me back only the unique rows?

## When to prefer this

Choose this endpoint when you have a small-to-medium batch of API usage records (up to 200 rows) and need exact row deduplication locally, without any external enrichment, forecasting, or fuzzy matching. Ideal for data pipeline cleanup before analytics or billing.

## Known failure modes

- Input array is empty (minItems:1 violated — request rejected)
- More than 200 rows submitted (maxItems:200 exceeded — request rejected)
- Missing required fields (row_id, endpoint, date, requests, or latency_ms) on any row — validation error
- Date field not matching YYYY-MM-DD pattern — validation error
- row_id exceeds 80 characters — validation error
- Payment of 0.01 USDC not provided or x402 payment handshake fails — authentication/payment error

## How this service works

API usage - Exact row deduplication: Exact row deduplication for API usage. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded exact row deduplication deliverable.

## Output

A deduplicated array of API usage records where every row is unique across all fields (endpoint, date, requests, latency_ms). Duplicate rows are removed, and only distinct records are returned.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/api-usage-exact-row-deduplication-ad9f4266/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)