# Partnership Pipeline — Exact Row Deduplication + Numeric Row Ordering

> Partnership Pipeline — Exact Row Deduplication + Numeric Row Ordering 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-19).

Deduplicates exact duplicate rows and sorts rows numerically by a chosen field (qualified_partners or active_partners) from supplied partnership pipeline data, returning two analytical reports for up to 200 rows.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-company-09-042?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-19
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/partnership-pipeline-exact-row-deduplication-numeric-row-ordering-9e04a8e2
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_Y6ABJMP9NgplIxrPNvBhN

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-numeric-row-ordering-9e04a8e2 -d '<json body>'
```

Example prompt: I have a batch of up to 200 partnership pipeline records with columns row_id, company_group, date, qualified_partners, and active_partners — can you deduplicate exact duplicate rows and then sort them numerically by qualified_partners, giving me both reports?

## When to prefer this

Choose this endpoint when you have raw partnership pipeline records that may contain exact duplicates and need them cleaned and sorted numerically by qualified or active partner counts, all in a single $0.01 call that returns two reports. Ideal for lightweight, offline analytical tasks on datasets up to 200 rows without any need for live data lookups or predictions.

## Known failure modes

- Exceeding 200 rows returns a validation error
- Missing required fields (row_id, company_group, date, qualified_partners, active_partners) cause schema rejection
- Malformed date strings not matching YYYY-MM-DD pattern fail validation
- Numeric values outside ±1,000,000,000,000 are rejected
- Empty rows array returns an error

## How this service works

Partnership pipeline — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering 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 structured reports derived solely from the supplied data: (1) a deduplication report identifying and removing exact duplicate rows, and (2) a numeric row ordering report ranking the (deduplicated) rows by the selected field (qualified_partners or active_partners). No external lookups or predictions are made.

## 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
  },
  "field": {
   "enum": [
    "qualified_partners",
    "active_partners"
   ],
   "type": "string",
   "default": "qualified_partners"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/partnership-pipeline-exact-row-deduplication-numeric-row-ordering-9e04a8e2/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)