# Trim, Deduplicate, Match, and Count Records Pipeline

> Trim, Deduplicate, Match, and Count Records 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-27).

Processes tabular records through a four-step pipeline: trims text whitespace, removes duplicate rows, filters rows matching a text query, and counts values by group.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-cap-2034f06d02a91a0e2a70?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-27
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/trim-deduplicate-match-and-count-records-pipeline-ba6ab0b2
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_Rzv5kv-0iC9juL0iyYmUm

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 trim-deduplicate-match-and-count-records-pipeline-ba6ab0b2 -d '<json body>'
```

Example prompt: I have a list of customer records with a 'name' field — can you trim the whitespace, remove duplicates, find all rows where 'name' contains 'Acme', and tell me the count at each step? Here are the records: [{"name": " Acme Corp "}, {"name": "Acme Corp"}, {"name": "Beta LLC"}].

## When to prefer this

Choose this endpoint when you need a self-contained, four-step text-cleaning and counting pipeline on up to 300 records without any external data lookup — especially when you want row counts at each stage (trim → deduplicate → match → count) in a single call at a fixed low cost of $0.01 USDC.

## Known failure modes

- Empty records array (minItems:1 violated) returns validation error
- Field name doesn't match pattern ^[a-zA-Z][a-zA-Z0-9_]{0,39}$ returns schema error
- Query string empty or over 100 characters returns validation error
- More than 300 records submitted (maxItems exceeded) returns rejection
- Records contain objects with more than 30 properties (maxProperties exceeded)

## How this service works

Trim text fields → Remove duplicate rows → Match text in a column → Count values by group: Process customer-supplied records: Trim text fields → 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 records and row counts for each pipeline step: after trimming, after deduplication, after text matching, and after grouping — so the agent can see exactly how many records survived each transformation.

## 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/trim-deduplicate-match-and-count-records-pipeline-ba6ab0b2/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)