# Patch Inventories — Exact Row Deduplication + Duplicate Key Report

> Patch Inventories — Exact Row Deduplication + Duplicate Key Report is a paid API for AI agents from market.datapackvibe.com, paid per call via x402, $0.01/call, status unknown (last checked 2026-11-02).

Deduplicates exact rows and identifies duplicate keys in patch inventory records (affected_hosts, patched_hosts) with up to 200 rows, producing two independent analytical reports.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-security-02-038?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-11-02
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/patch-inventories-exact-row-deduplication-duplicate-key-report-0dc347c6
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_3uLmol5thwCU_INqdrGJf

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 patch-inventories-exact-row-deduplication-duplicate-key-report-0dc347c6 -d '<json body>'
```

Example prompt: Can you check my patch inventory data for exact duplicate rows and duplicate keys? Here are my records: row-1 for group-a on 2026-10-01 with 10 affected and 1 patched host, row-2 for group-b on 2026-10-02 with 20 affected and 2 patched, row-3 for group-a on 2026-10-03 with 15 affected and 3 patched, and row-4 for group-b on 2026-10-04 with 30 affected and 4 patched — give me both the deduplication report and the duplicate key report.

## When to prefer this

Choose this endpoint when you need to audit patch inventory records specifically for exact row-level duplicates and duplicate key collisions on the fields affected_hosts and patched_hosts, without requiring any live data lookup or external integrations. It is ideal for lightweight, local analytical data quality checks on batches of up to 200 patch management rows at very low cost ($0.01 per call for two reports).

## Known failure modes

- Submitting more than 200 rows returns an error or truncates results
- Missing required fields (row_id, date, affected_hosts, patched_hosts) cause row-level validation failures
- Malformed date strings not matching YYYY-MM-DD pattern are rejected
- Numeric values exceeding ±1,000,000,000,000 are out of range
- Empty rows array returns an error (minItems: 1)
- Payment of 0.01 USDC must be provided via x402 protocol or request is rejected

## How this service works

Patch inventories — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied patch inventories records (affected_hosts, patched_hosts). 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 reports: (1) an exact row deduplication report identifying rows that are completely identical across all fields, and (2) a duplicate key report flagging rows that share the same key identifier (row_id), covering up to 200 submitted patch inventory records per call.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/patch-inventories-exact-row-deduplication-duplicate-key-report-0dc347c6/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)