# Remove Duplicates → Filter Non-Null → Numeric Summary Pipeline

> Remove Duplicates → Filter Non-Null → Numeric Summary Pipeline 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-18).

Processes a batch of records through three sequential steps: deduplication, filtering rows with a value in a specified field, and computing a numeric summary — returning processed output and row counts per step.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-cap-d209400e5f06b6f1531b?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-18
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/remove-duplicates-filter-non-null-numeric-summary-pipeline-b1f5aa37
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_p0J8iYxBwjpCFk_nN2ZPp

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 remove-duplicates-filter-non-null-numeric-summary-pipeline-b1f5aa37 -d '<json body>'
```

Example prompt: I have a list of customer records with a 'value' field — can you remove any duplicate rows, keep only rows where 'value' is filled in, and then give me a numeric summary of what's left?

## When to prefer this

Choose this endpoint when you need a quick, all-in-one data cleaning and summarization pipeline on up to 300 flat records — specifically when you want to deduplicate, filter non-null rows by field, and get numeric statistics in a single API call without setting up your own ETL. It's ideal for lightweight data-prep tasks where the records fit within the 300-row flat limit and you need row-count transparency per step.

## Known failure modes

- Empty records array (violates minItems:1 constraint)
- More than 300 records submitted (exceeds maxItems:300)
- Field name does not match pattern ^[a-zA-Z][a-zA-Z0-9_]{0,39}$ (invalid field name)
- Records contain objects with more than 30 properties (violates maxProperties:30)
- Specified field does not exist in any records, resulting in empty filtered output
- Non-numeric values in field preventing numeric summary computation
- Payment of 0.01 USDC not provided, resulting in 402 Payment Required

## How this service works

Remove duplicate rows → Keep rows with a value → Numeric summary: Process customer-supplied records: Remove duplicate rows → Keep rows with a value → Numeric summary. Returns the processed output and row counts per step. No external data lookup. 0.01 USDC includes up to 300 flat records.

## Output

Returns the processed records after each pipeline stage (deduplicated, then filtered, then summarized), along with row counts showing how many records remained after each step and numeric summary statistics (such as count, sum, min, max, mean) for the specified numeric field.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "field": {
   "type": "string",
   "default": "value",
   "pattern": "^[a-zA-Z][a-zA-Z0-9_]{0,39}$",
   "maxLength": 40
  },
  "records": {
   "type": "array",
   "items": {
    "type": "object",
    "maxProperties": 30,
    "additionalProperties": {
     "type": [
      "string",
      "number",
      "boolean",
      "null"
     ]
    }
   },
   "default": [
    {
     "text": " Useful example ",
     "value": 10
    },
    {
     "text": "Useful example",
     "value": 20
    },
    {
     "text": "Other row",
     "value": 5
    }
   ],
   "maxItems": 300,
   "minItems": 1
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/remove-duplicates-filter-non-null-numeric-summary-pipeline-b1f5aa37/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)