# Damaged Stock — Exact Row Deduplication + Secondary-Measure Weighted Mean

> Damaged Stock — Exact Row Deduplication + Secondary-Measure Weighted Mean 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).

Deduplicates exact rows and computes a secondary-measure weighted mean across up to 200 damaged stock records (handled_units, damaged_units) in two bundled analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-retail-18-051?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/damaged-stock-exact-row-deduplication-secondary-measure-weighted-mean-62dacb8b
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_r8MWYBAHvDBmT5ZwZk3QU

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 damaged-stock-exact-row-deduplication-secondary-measure-weighted-mean-62dacb8b -d '<json body>'
```

Example prompt: I have up to 200 rows of damaged stock records with store_group, date, handled_units, and damaged_units — can you deduplicate exact rows and compute a weighted mean of handled_units across those records, giving me both reports?

## When to prefer this

Choose this endpoint when you have up to 200 damaged stock records and need both exact row deduplication and a secondary-measure weighted mean in a single low-cost call ($0.01 USDC). It is ideal for retail or warehouse inventory pipelines that need lightweight, offline data cleaning and aggregation without external API dependencies, predictions, or live lookups. Prefer alternatives if you need more than 200 rows, real-time inventory data, or operations beyond deduplication and weighted mean.

## Known failure modes

- More than 200 rows submitted — exceeds maxItems limit, request rejected
- Missing required fields (row_id, store_group, date, handled_units, damaged_units) — validation error
- Date field does not match YYYY-MM-DD pattern — schema validation failure
- All rows are duplicates leaving empty dataset for aggregation — edge case result
- Numeric values outside allowed range (±1,000,000,000,000) — validation error

## How this service works

Damaged stock — Exact row deduplication + Secondary-measure weighted mean: Exact row deduplication + Secondary-measure weighted mean for supplied damaged stock records (handled_units, damaged_units). 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 analytical reports: (1) a deduplicated row set with exact duplicate rows removed, and (2) a secondary-measure weighted mean of the specified field (handled_units or damaged_units), computed across the cleaned dataset. Both reports are generated locally without external lookups or predictions.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/damaged-stock-exact-row-deduplication-secondary-measure-weighted-mean-62dacb8b/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)