# Third-Party Reviews — Date×Category Pivot + Explicit Missing-Value Fill

> Third-Party Reviews — Date×Category Pivot + 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-26).

Pivots third-party review data by date and category, then fills missing values using a chosen method (zero, mean, or median) across vendors_reviewed and outstanding_actions fields.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-security-24-189?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-26
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/third-party-reviews-date-category-pivot-explicit-missing-value-fill-ad47ce84
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_6D47dLIXyHKHfGOzjWDfO

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 third-party-reviews-date-category-pivot-explicit-missing-value-fill-ad47ce84 -d '<json body>'
```

Example prompt: I have up to 200 rows of third-party review records with dates, control groups, vendors_reviewed and outstanding_actions — can you run a date-by-category pivot and fill any missing vendors_reviewed values using median imputation?

## When to prefer this

Choose this endpoint when you have up to 200 rows of third-party review records that need both a date×category pivot and missing-value imputation in a single call. Ideal for vendor risk reporting workflows where data has sparse nulls and needs reshaping before visualization or downstream analysis. Prefer this over general pivot tools when your schema exactly matches vendors_reviewed and outstanding_actions fields with control groups.

## Known failure modes

- Rows array exceeds 200 items — request rejected
- Missing required fields (row_id, date, control_group) in any row — validation error
- Invalid date format (must be YYYY-MM-DD) — schema rejection
- Field enum value not recognized — bad request
- All values null for the chosen field — fill method may produce degenerate output
- Payment of 0.01 USDC not received — 402 payment required

## How this service works

Third party reviews — Date by category pivot + Explicit missing-value fill: Date by category pivot + Explicit missing-value fill for supplied third party reviews records (vendors_reviewed, outstanding_actions). 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 derived from the supplied rows: (1) a date-by-category pivot table for the selected field, and (2) the same dataset with missing values explicitly filled using the specified method (zero, mean, or median). Both reports are based purely on the provided data with no external lookups.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/third-party-reviews-date-category-pivot-explicit-missing-value-fill-ad47ce84/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)