# Deduplicate, Filter, and Count Rows Pipeline

> Deduplicate, Filter, and Count Rows 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).

Removes duplicate rows from a record set, filters rows where a specified text column matches a query string, then counts remaining records grouped by value.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-cap-a15fdee7e1b56dadc983?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/deduplicate-filter-and-count-rows-pipeline-176976e4
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_bHbOrwv97KSCPb6zBzY_z

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 deduplicate-filter-and-count-rows-pipeline-176976e4 -d '<json body>'
```

Example prompt: Take these 200 customer records, remove any duplicate rows, then keep only the ones where the 'status' column contains the word 'active', and give me a count of how many remain per group.

## When to prefer this

Choose this endpoint when you need a lightweight, stateless three-step pipeline (deduplicate → text filter → group count) applied to up to 300 flat records in a single API call. It's ideal when you don't want to wire up multiple transformation steps yourself, need a cheap per-call price ($0.01 USDC), and have no need for external data lookups or joins.

## Known failure modes

- Records array is empty or missing — returns validation error
- Field name does not match any property in the submitted records — filter step returns zero matches
- Query string is empty or too long (>100 chars) — returns validation error
- More than 300 records submitted — request rejected with limit exceeded error
- Record objects contain more than 30 properties — schema validation failure

## How this service works

Remove duplicate rows → Match text in a column → Count values by group: Process customer-supplied records: Remove duplicate rows → Match text in a column → Count values by group. 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 output after three sequential steps: (1) deduplicated records with count, (2) text-matched filtered records with count, and (3) a group-by count breakdown — all in a single response payload.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "field": {
   "type": "string",
   "default": "text",
   "pattern": "^[a-zA-Z][a-zA-Z0-9_]{0,39}$",
   "maxLength": 40
  },
  "query": {
   "type": "string",
   "default": "useful",
   "maxLength": 100,
   "minLength": 1
  },
  "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/deduplicate-filter-and-count-rows-pipeline-176976e4/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)