# Supplier Qualification — Duplicate Key Report + Date by Category Pivot

> Supplier Qualification — 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 supplier qualification records to produce two local analytical reports: a duplicate key report and a date-by-category pivot on checked_criteria or met_criteria values.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-02-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/supplier-qualification-duplicate-key-report-date-by-category-pivot-401d97ec
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_IUnuRXxLYr1k-Jl7Yy_cq

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 supplier-qualification-duplicate-key-report-date-by-category-pivot-401d97ec -d '<json body>'
```

Example prompt: Can you run a duplicate key check and a date-by-category pivot on this supplier qualification data — checking the met_criteria field — for these records: row-1 on 2026-10-01 group-a with 10 checked and 1 met, row-2 on 2026-10-02 group-b with 20 checked and 2 met, row-3 on 2026-10-03 group-a with 15 checked and 3 met?

## When to prefer this

Choose this endpoint when you need fast, local analytical processing of supplier qualification records without any external lookups or predictions. It is ideal for data quality checks (duplicate detection) combined with date-based category pivots in a single $0.01 call covering up to 200 rows. Prefer it over general analytics tools when working within the x402 micropayment ecosystem or when you need both a duplicate report and a pivot report simultaneously from a single request.

## Known failure modes

- Fewer than 1 row submitted — request rejected
- More than 200 rows submitted — exceeds max limit
- Invalid date format (not YYYY-MM-DD) — schema validation error
- row_id missing or empty — required field violation
- checked_criteria or met_criteria value outside ±1,000,000,000,000 — range error
- Invalid field enum value — must be 'checked_criteria' or 'met_criteria'

## How this service works

Supplier qualification — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied supplier qualification records (checked_criteria, met_criteria). 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 flagging any row_ids that appear more than once in the submitted dataset, and (2) a date-by-category pivot table aggregating the selected field (checked_criteria or met_criteria) grouped by date and company_group. No external data is fetched; all analysis runs on the supplied rows only (up to 200).

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/supplier-qualification-duplicate-key-report-date-by-category-pivot-401d97ec/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)