# Proposal Preparation Exact Row Deduplication and Numeric Distribution

> Proposal Preparation Exact Row Deduplication and Numeric Distribution 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-25).

Deduplicates rows and computes numeric distribution statistics for proposal preparation records with completed_sections and planned_sections fields.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-ib26-writing-08-039?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-25
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/proposal-preparation-exact-row-deduplication-and-numeric-distribution-4a4f0637
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_eyzxy46Bt1cL5C1BzyZ32

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 proposal-preparation-exact-row-deduplication-and-numeric-distribution-4a4f0637 -d '<json body>'
```

Example prompt: I have a dataset of proposal preparation records with completed_sections and planned_sections counts — can you deduplicate the rows exactly and show me the numeric distribution of completed_sections across up to 200 rows?

## When to prefer this

Choose this endpoint when you have proposal preparation records (with completed_sections and planned_sections) and need both exact duplicate removal and a numeric distribution summary in a single low-cost call. It is ideal for small-to-medium datasets up to 200 rows where you want offline, deterministic analytics without any external API calls, predictions, or professional assessments. Prefer alternatives if you need fuzzy deduplication, live data enrichment, or analysis of fields beyond the two supported numeric columns.

## Known failure modes

- Input array exceeds 200 rows — request rejected
- Missing required fields (row_id, date, document_group, completed_sections, planned_sections) — validation error
- Invalid date format (not YYYY-MM-DD) — schema validation failure
- Numeric values outside allowed range (-1e12 to 1e12) — rejection
- Empty rows array — minimum 1 item required
- Invalid field enum value — must be completed_sections or planned_sections

## How this service works

Proposal preparation — Exact row deduplication + Numeric distribution: Exact row deduplication + Numeric distribution for supplied proposal preparation records (completed_sections, planned_sections). 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 reports: (1) an exact row deduplication report identifying and removing duplicate rows from the supplied proposal preparation dataset, and (2) a numeric distribution report summarizing the statistical spread (e.g. min, max, mean, histogram buckets) of the selected field (completed_sections or planned_sections) across up to 200 rows. No external lookups or predictions are made; all analysis is performed locally on the supplied data.

## Request schema (JSON Schema)

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

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/proposal-preparation-exact-row-deduplication-and-numeric-distribution-4a4f0637/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)