# Contract Renewal Inventories — Exact Row Deduplication + Explicit Missing-Value Fill

> Contract Renewal Inventories — Exact Row Deduplication + 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-20).

Deduplicates exact rows and fills missing values in contract renewal inventory records (expiring_contracts, renewed_contracts) for up to 200 rows, producing 2 analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-20-054?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-20
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/contract-renewal-inventories-exact-row-deduplication-explicit-missing-d3639b01
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_3EGO5g1W_7Yai6H0YwA34

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 contract-renewal-inventories-exact-row-deduplication-explicit-missing-d3639b01 -d '<json body>'
```

Example prompt: Clean up my contract renewal inventory data by removing exact duplicate rows and filling any missing expiring_contracts values using the median method — here are my records: row-1, group-a, 2026-10-01, expiring=10, renewed=1; row-2, group-b, 2026-10-02, expiring=20, renewed=2; and row-3, group-a, 2026-10-03, expiring=null, renewed=3.

## When to prefer this

Choose this endpoint when you have tabular contract renewal data (expiring_contracts and renewed_contracts) that needs both duplicate row removal and missing-value imputation in a single step, without any external data enrichment, predictions, or live lookups. Ideal for preprocessing pipelines where data quality must be ensured before downstream renewal rate analysis, and when you want two simultaneous field-level reports at low cost ($0.01 USDC for both).

## Known failure modes

- Input array exceeds 200 rows — request rejected
- Missing required fields (row_id, date, company_group) — validation error
- Invalid date format not matching YYYY-MM-DD pattern — rejected
- Numeric values outside allowed range (±1,000,000,000,000) — validation error
- Empty rows array — minimum 1 item required

## How this service works

Contract renewal inventories — Exact row deduplication + Explicit missing-value fill: Exact row deduplication + Explicit missing-value fill for supplied contract renewal inventories records (expiring_contracts, renewed_contracts). 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 for the supplied contract renewal inventory records: one for expiring_contracts and one for renewed_contracts. Each report reflects exact-row deduplication (identifying and removing identical rows) and explicit missing-value fill applied to the selected field using the chosen method (zero, mean, or median). Reports cover up to 200 input rows and are generated using local analytical engines with no external lookups.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "rows": {
   "type": "array",
   "items": {
    "type": "object",
    "required": [
     "row_id",
     "company_group",
     "date",
     "expiring_contracts",
     "renewed_contracts"
    ],
    "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
     },
     "renewed_contracts": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     },
     "expiring_contracts": {
      "type": [
       "number",
       "null"
      ],
      "maximum": 1000000000000,
      "minimum": -1000000000000
     }
    },
    "additionalProperties": false
   },
   "default": [
    {
     "date": "2026-10-01",
     "row_id": "row-1",
     "company_group": "group-a",
     "renewed_contracts": 1,
     "expiring_contracts": 10
    },
    {
     "date": "2026-10-02",
     "row_id": "row-2",
     "company_group": "group-b",
     "renewed_contracts": 2,
     "expiring_contracts": 20
    },
    {
     "date": "2026-10-03",
     "row_id": "row-3",
     "company_group": "group-a",
     "renewed_contracts": 3,
     "expiring_contracts": 15
    },
    {
     "date": "2026-10-04",
     "row_id": "row-4",
     "company_group": "group-b",
     "renewed_contracts": 4,
     "expiring_contracts": 30
    }
   ],
   "maxItems": 200,
   "minItems": 1
  },
  "field": {
   "enum": [
    "expiring_contracts",
    "renewed_contracts"
   ],
   "type": "string",
   "default": "expiring_contracts"
  },
  "method": {
   "enum": [
    "zero",
    "mean",
    "median"
   ],
   "type": "string",
   "default": "median"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/contract-renewal-inventories-exact-row-deduplication-explicit-missing-d3639b01/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)