# OpenRefine Fingerprint Clustering & Collision Review Plan

> OpenRefine Fingerprint Clustering & Collision Review Plan is a paid API for AI agents from agent.halowerk.com, paid per call via x402, $0.0035/call, status unknown (last checked 2026-10-29).

Clusters a key column using OpenRefine fingerprinting and returns a row-level consolidation plan that distinguishes clean merges, unresolved collisions, excluded rows, and singletons.

## Facts

- Endpoint: POST https://agent.halowerk.com/v1/oss-openrefine-table-collision-review-plan?utm_source=zero.xyz
- Price: $0.0035/call
- Payment: x402
- Status: unknown
- Last checked: 2026-10-29
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/openrefine-fingerprint-clustering-collision-review-plan-7b4e0d1a
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_I1oCPvoUj_EIGFhQ5YjcY

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 openrefine-fingerprint-clustering-collision-review-plan-7b4e0d1a -d '<json body>'
```

Example prompt: Cluster the 'company_name' column in this table using OpenRefine fingerprinting and give me a consolidation plan — flag which rows can be merged cleanly and which have collisions because their other fields disagree.

## When to prefer this

Choose this endpoint when you need a safe, auditable deduplication plan for tabular data and want to avoid silently destroying information by merging conflicting records. It is especially valuable when rows sharing a key may legitimately differ in other fields — the unresolved collision flag prevents bad merges. Prefer it over generic deduplication tools when you need row-level traceability (actual IDs in the plan) and OpenRefine-compatible fingerprint clustering semantics, without needing to run a full OpenRefine instance.

## Known failure modes

- match_column not found in columns array — returns validation error
- rows array is empty or exceeds 1000 row limit — schema rejection
- columns and rows value arrays are misaligned in length — schema error
- match_column pattern violation (invalid characters or too long) — 400 error
- all rows are singletons — returns plan with no merge or collision groups, only singletons

## How this service works

Clusters a key column with native OpenRefine fingerprinting and returns a consolidation plan tied to actual row ids. The plan distinguishes the two cases that matter: rows that repeat an identical value and can simply be merged, and rows that collide on the key but disagree in other fields — those are flagged as unresolved rather than silently collapsed, because merging them would destroy information. Excluded rows and singletons are reported too, so the plan accounts for every input row.

## Output

A consolidation plan covering every input row, organized into: clean merge groups (rows with identical key values that can be collapsed), unresolved collisions (rows that share a fingerprinted key but disagree on other fields), excluded rows, and singletons — each group referencing actual row IDs from the input.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "table": {
   "type": "object",
   "required": [
    "columns",
    "rows"
   ],
   "properties": {
    "rows": {
     "type": "array",
     "items": {
      "type": "object",
      "required": [
       "id",
       "values"
      ],
      "properties": {
       "id": {
        "type": "string",
        "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
       },
       "values": {
        "type": "array",
        "items": {
         "anyOf": [
          {
           "type": "string",
           "maxLength": 4096
          },
          {
           "type": "null"
          }
         ]
        },
        "maxItems": 16,
        "minItems": 1
       }
      },
      "additionalProperties": false
     },
     "maxItems": 1000,
     "minItems": 1
    },
    "columns": {
     "type": "array",
     "items": {
      "type": "string",
      "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
     },
     "maxItems": 16,
     "minItems": 1
    }
   },
   "additionalProperties": false
  },
  "match_column": {
   "type": "string",
   "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/openrefine-fingerprint-clustering-collision-review-plan-7b4e0d1a/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from agent.halowerk.com](https://www.zero.xyz/host/agent.halowerk.com/llms.txt)