# Partnership Pipeline — Exact Row Deduplication + Duplicate Key Report

> Partnership Pipeline — 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-10-15).

Deduplicates exact rows and generates a duplicate key report for partnership pipeline records (qualified_partners, active_partners) in a single batch call.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-09-038?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/partnership-pipeline-exact-row-deduplication-duplicate-key-report-51e14864
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_-g9quXC8Yi5mjBYAaxtp9

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 partnership-pipeline-exact-row-deduplication-duplicate-key-report-51e14864 -d '<json body>'
```

Example prompt: Can you check this list of partnership pipeline records for exact duplicate rows and also flag any duplicate keys? I have up to 20 rows with fields like row_id, company_group, date, qualified_partners, and active_partners — I need both a deduplication result and a duplicate key report.

## When to prefer this

Choose this endpoint when you need to clean or audit partnership pipeline data containing qualified_partners and active_partners metrics, and want both exact row deduplication and a duplicate key report in a single low-cost call. Ideal for pre-import validation, periodic data quality checks, or reconciliation after merging partner records from multiple sources. Best for batch sizes up to 200 rows. Not suitable if you need fuzzy matching, external enrichment, or real-time partner data lookups.

## Known failure modes

- Exceeding 200 rows returns a validation error
- Missing required fields (row_id, company_group, date, qualified_partners, active_partners) causes schema rejection
- Invalid date format (not YYYY-MM-DD) triggers pattern validation failure
- Numeric values outside [-1,000,000,000,000, 1,000,000,000,000] range are rejected
- Empty rows array (minItems: 1 not met) returns an error
- Payment of 0.01 USDC required; insufficient payment results in HTTP 402

## How this service works

Partnership pipeline — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied partnership pipeline records (qualified_partners, active_partners). 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 which rows among the submitted partnership pipeline records are exact duplicates, and (2) a duplicate key report identifying which row keys (e.g., row_id or composite keys) appear more than once across the submitted records. No external lookups or predictions are performed; all analysis is done on the supplied data only.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/partnership-pipeline-exact-row-deduplication-duplicate-key-report-51e14864/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)