# Trim, Deduplicate, Match, and Summarize Text Records

> Trim, Deduplicate, Match, and Summarize Text Records 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 a batch of records through four sequential steps: trim text fields, remove duplicate rows, filter rows matching a text pattern, and compute a numeric summary.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-cap-200605745edb91804dda?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-summarize-text-records-7e7ad9c0
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_nhoQq223IlrnnIA7CrTZN

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-summarize-text-records-7e7ad9c0 -d '<json body>'
```

Example prompt: Clean up these 50 customer records for me — trim whitespace from the 'name' field, remove any duplicate rows, then filter for rows matching 'premium', and give me a numeric summary and row count at each step.

## When to prefer this

Choose this endpoint when you need a lightweight, self-contained, multi-step data cleaning pipeline (trim → deduplicate → match → summarize) on small-to-medium record sets (up to 300 rows) without spinning up a full ETL system. It is ideal for pre-processing customer-supplied data before import, quickly validating uniqueness after text normalization, or getting a per-step audit trail of row counts during data quality checks.

## Known failure modes

- Empty records array or missing required 'records' field returns a validation error
- 'field' parameter references a column that does not exist in the supplied records — may return zero matches or an error
- 'query' string that matches nothing returns an empty matched set and zero count at that step
- Supplying more than 300 records exceeds the plan limit and may be rejected
- Non-string values in the targeted field may be skipped or cause unexpected trim behavior

## How this service works

Trim text fields → Remove duplicate rows → Match text in a column → Numeric summary: Process customer-supplied records: Trim text fields → Remove duplicate rows → Match text in a column → 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 fully processed records after all four pipeline steps (trim → deduplicate → match → numeric summary), along with row counts at each stage and a numeric summary of the relevant column. All processing is self-contained with no external data lookups.

## 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
  },
  "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-summarize-text-records-7e7ad9c0/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)