# Vendor Evaluation — Exact Row Deduplication + Date by Category Pivot

> Vendor Evaluation — Exact Row Deduplication + 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-23).

Deduplicates exact duplicate rows and generates a date-by-category pivot report for vendor evaluation records containing supplied_score and maximum_score fields.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-10-052?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-23
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/vendor-evaluation-exact-row-deduplication-date-by-category-pivot-b6171d41
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_J8KDBCgPheDAyxUgSvSu6

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 vendor-evaluation-exact-row-deduplication-date-by-category-pivot-b6171d41 -d '<json body>'
```

Example prompt: Can you clean up my vendor evaluation data by removing exact duplicate rows and then build a pivot table of supplied_score grouped by company group across dates? I have up to 50 rows with fields like row_id, company_group, date, supplied_score, and maximum_score.

## When to prefer this

Choose this endpoint when you have vendor evaluation records with supplied_score and maximum_score and need both exact-duplicate removal and a date-by-category pivot in one low-cost call (up to 200 rows for $0.01 USDC). It is ideal for offline batch data cleaning and reporting workflows where no live lookup, prediction, or external action is needed. Prefer it over generic analytics tools when you specifically need the dual-report output (dedup + pivot) tailored to vendor evaluation schemas.

## Known failure modes

- Input exceeds 200 rows — request rejected with validation error
- Missing required fields (row_id, date, company_group, supplied_score, maximum_score) cause row rejection
- Invalid date format (non-YYYY-MM-DD) fails pattern validation
- Numeric values outside allowed range (-1e12 to 1e12) are rejected
- Empty rows array returns error
- Field enum value other than 'supplied_score' or 'maximum_score' is rejected

## How this service works

Vendor evaluation — Exact row deduplication + Date by category pivot: Exact row deduplication + Date by category pivot for supplied vendor evaluation records (supplied_score, maximum_score). 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) an exact row deduplication report identifying and removing duplicate vendor evaluation records, and (2) a date-by-category pivot table showing the selected score field (supplied_score or maximum_score) broken down by company_group across dates. Covers up to 200 input rows with no external lookups or live data.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/vendor-evaluation-exact-row-deduplication-date-by-category-pivot-b6171d41/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)