# Remove Duplicate Rows → Match Text in Column → Numeric Summary

> Remove Duplicate Rows → Match Text in Column → Numeric Summary 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 customer-supplied records by deduplicating rows, filtering by text match in a specified column, then returning a numeric summary with row counts per step.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-cap-a359e296a6341bcba00f?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-duplicate-rows-match-text-in-column-numeric-summary-a0aba4da
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_LK1_8yLwrnvGdNnKEbJAU

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-duplicate-rows-match-text-in-column-numeric-summary-a0aba4da -d '<json body>'
```

Example prompt: I have a list of up to 300 customer records with a 'text' column and a 'value' column — can you remove duplicate rows, then keep only rows where 'text' contains 'Useful example', and give me a numeric summary with row counts at each step?

## When to prefer this

Choose this endpoint when you have a flat dataset (up to 300 records) and need a chained pipeline of deduplication followed by text-column filtering followed by numeric aggregation — all in a single call for $0.01 USDC. It is ideal for lightweight, self-contained data cleaning and summarization tasks that do not require external data lookups or complex transformations beyond this three-step sequence.

## Known failure modes

- Input records array is empty or missing (minItems: 1 violated)
- More than 300 records supplied (maxItems exceeded)
- Field name doesn't match pattern ^[a-zA-Z][a-zA-Z0-9_]{0,39}$ or exceeds 40 characters
- Query string is empty or exceeds 100 characters
- Records contain objects with more than 30 properties (maxProperties violated)
- No rows survive the text-match filter, resulting in empty output set

## How this service works

Remove duplicate rows → Match text in a column → Numeric summary: Process customer-supplied records: 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 processed output records and row counts per step: (1) after deduplication, (2) after text-match filtering, and (3) a numeric summary of the remaining data. Up to 300 input records supported per call.

## 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/remove-duplicate-rows-match-text-in-column-numeric-summary-a0aba4da/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)