# Competitor Supplied Prices — Duplicate Key Report + Date by Category Pivot

> Competitor Supplied Prices — Duplicate Key Report + Date by Category Pivot 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).

Analyzes up to 200 rows of competitor pricing data (list_price or package_quantity) to produce a duplicate key report and a date-by-category pivot table in a single call.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-07-068?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-date-by-category-pivot-6d81fcbe
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_v9LXGlNGW_XAjOVhQfE1V

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-date-by-category-pivot-6d81fcbe -d '<json body>'
```

Example prompt: I have up to 200 rows of competitor pricing data with fields row_id, company_group, date, list_price, and package_quantity — can you run a duplicate key report and a date-by-category pivot on the list_price field for me?

## When to prefer this

Choose this endpoint when you need both a duplicate key check and a date-by-category pivot on competitor pricing records (list_price or package_quantity) in a single low-cost call. It is ideal for data quality workflows where you want to simultaneously detect repeated row identifiers and summarize numeric pricing fields across time and company segments, without needing live market data, external lookups, or predictions.

## Known failure modes

- Exceeds 200 row limit — request rejected
- Missing required fields (row_id, company_group, date, list_price, or package_quantity) — validation error
- Invalid date format (must be YYYY-MM-DD) — schema validation failure
- Field value out of allowed numeric range (±1 trillion) — rejected
- Empty rows array — minimum 1 item required

## How this service works

Competitor supplied prices — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot 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 analytical reports: (1) a duplicate key report identifying repeated row_id values within the submitted dataset, and (2) a date-by-category pivot table aggregating the selected numeric field (list_price or package_quantity) broken down by date and company_group, covering up to 200 input 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"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/competitor-supplied-prices-duplicate-key-report-date-by-category-pivot-6d81fcbe/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)