# Remove Duplicates → Text Match → Sort Numbers Descending

> Remove Duplicates → Text Match → Sort Numbers Descending 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-15).

Processes tabular records by sequentially removing duplicate rows, filtering rows where a text column matches a query, and sorting the results by a numeric column in descending order.

## Facts

- Endpoint: POST https://market.datapackvibe.com/x402/assistant-cap-72a93bfc8cb8b26e2d26?utm_source=zero.xyz
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-15
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/remove-duplicates-text-match-sort-numbers-descending-6872a708
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_KoF61j4qmcOQmCM1Je3j5

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-text-match-sort-numbers-descending-6872a708 -d '<json body>'
```

Example prompt: Take these customer records and run them through a three-step pipeline: first remove any duplicate rows, then keep only rows where the 'category' column matches 'electronics', and finally sort what's left by the 'price' column from highest to lowest.

## When to prefer this

Choose this endpoint when you need a fixed three-step pipeline (deduplicate → text-match filter → numeric descending sort) applied to up to 300 flat records in a single call for a flat $0.01 USDC. Ideal for lightweight ETL preprocessing, data cleaning tasks, or quick report generation where you don't want to maintain your own transformation logic. Not suitable if you need a different operation order, more than 300 records, external data lookups, or custom aggregation beyond these three steps.

## Known failure modes

- Empty records array or fewer than 1 item returns a validation error
- Records array exceeding 300 items is rejected
- Field name not matching pattern ^[a-zA-Z][a-zA-Z0-9_]{0,39}$ returns schema error
- Query string shorter than 1 character or longer than 100 characters is rejected
- Non-object items in records array cause schema validation failure
- No rows surviving deduplication or text-match filter returns empty result set with zero rows

## How this service works

Remove duplicate rows → Match text in a column → Sort numbers descending: Process customer-supplied records: Remove duplicate rows → Match text in a column → Sort numbers descending. 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 array after all three sequential steps (deduplication, text match filter, numeric sort descending), along with row counts at each stage so you can see how many rows were removed or kept at each step.

## 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-duplicates-text-match-sort-numbers-descending-6872a708/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)