# Competitor Supplied Prices — Duplicate Key Report + Explicit Missing-Value Fill

> Competitor Supplied Prices — Duplicate Key Report + 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-15).

Runs two local analytical reports on up to 200 rows of competitor price data: identifies duplicate keys and fills missing numeric values (list_price or package_quantity) using zero, mean, or median imputation.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-07-070?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/competitor-supplied-prices-duplicate-key-report-explicit-missing-97596c39
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_LXqPMcM5GoLHz-Pl_G3Yb

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 competitor-supplied-prices-duplicate-key-report-explicit-missing-97596c39 -d '<json body>'
```

Example prompt: I have up to 150 rows of competitor pricing records with row_id, company_group, date, list_price, and package_quantity — can you run a duplicate key report and fill any missing list_price values using the median?

## When to prefer this

Choose this endpoint when you need both duplicate-key detection and missing-value imputation on competitor pricing data (list_price, package_quantity) in a single low-cost call. It is purpose-built for small-to-medium batches (up to 200 rows) of structured competitor price records and runs entirely on local analytical engines with no external lookups, making it fast, deterministic, and private. Prefer alternatives if you need more than 200 rows, real-time price lookups, predictive pricing models, or reports beyond deduplication and imputation.

## Known failure modes

- Input array exceeds 200 rows — request rejected
- Missing required fields (row_id, company_group, date) cause validation errors
- Invalid date format (not YYYY-MM-DD) triggers schema rejection
- Numeric values outside ±1,000,000,000,000 range are rejected
- Invalid enum value for field or method causes bad request
- Empty rows array (minItems:1 not met) returns error

## How this service works

Competitor supplied prices — Duplicate key report + Explicit missing-value fill: Duplicate key report + Explicit missing-value fill for supplied competitor supplied prices records (list_price, package_quantity). 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 reports: (1) a duplicate key report listing rows that share identical keys within the submitted competitor price data, and (2) a missing-value fill report showing the original and imputed values for the chosen numeric field (list_price or package_quantity) using the selected method (zero, mean, or median). No external data is fetched; all analysis runs locally on the submitted rows.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/competitor-supplied-prices-duplicate-key-report-explicit-missing-97596c39/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)