Clusters a key column with native OpenRefine fingerprinting and returns a consol
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.
Paid test badge: not yet. The checks above are free: we call the tool without paying and read the payment request it sends back. The Verified badge needs paid calls whose answers match the promised output, and nobody can buy a badge.
Endpoint
POST https://agent.halowerk.com/v1/oss-openrefine-table-collision-review-plan
| Category | Everything else |
|---|---|
| Provider host | agent.halowerk.com |
| Networks | eip155:8453 |
| Payment schemes | exact |
| Self-reported calls, 30 days | 2 from 2 payers (the provider's figure, not ours) |
Our checks, last 30 days
| Day | Result | HTTP | Asked | Time |
|---|---|---|---|---|
| 2026-10-24 | valid payment request | 402 | $0.0035 | 954 ms |
Example input (from the provider)
{
"body": {
"match_column": "name",
"table": {
"columns": [
"name",
"country",
"code"
],
"rows": [
{
"id": "r1",
"values": [
"Tom Cruise",
"US",
"A"
]
},
{
"id": "r2",
"values": [
"Cruise, Tom",
"US",
"A"
]
},
{
"id": "r3",
"values": [
"tom cruise",
"CA",
"A"
]
},
{
"id": "r4",
"values": [
"G\u00f6del",
"AT",
"B"
]
},
{
"id": "r5",
"values": [
"Godel",
"AT",
"B"
]
},
{
"id": "r6",
"values": [
"Acme",
"US",
null
]
},
{
"id": "r7",
"values": [
"Acme",
"US",
""
]
},
{
"id": "r8",
"values": [
"---",
"US",
"C"
]
},
{
"id": "r9",
"values": [
null,
"US",
"D"
]
},
{
"id": "r10",
"values": [
"Unique",
"US",
"E"
]
}
]
}
},
"bodyType": "json",
"method": "POST",
"type": "http"
}
Promised output schema (from the provider)
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"input": {
"additionalProperties": false,
"properties": {
"body": {
"additionalProperties": false,
"properties": {
"match_column": {
"pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$",
"type": "string"
},
"table": {
"additionalProperties": false,
"properties": {
"columns": {
"items": {
"pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$",
"type": "string"
},
"maxItems": 16,
"minItems": 1,
"type": "array"
},
"rows": {
"items": {
"additionalProperties": false,
"properties": {
"id": {
"pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$",
"type": "string"
},
"values": {
"items": {
"anyOf": [
{
"maxLength": 4096,
"type": "string"
},
{
"type": "null"
}
]
},
"maxItems": 16,
"minItems": 1,
"type": "array"
}
},
"required": [
"id",
"values"
],
"type": "object"
},
"maxItems": 1000,
"minItems": 1,
"type": "array"
}
},
"required": [
"columns",
"rows"
],
"type": "object"
}
},
"required": [
"table",
"match_column"
],
"type": "object"
},
"bodyType": {
"enum": [
"json",
"form-data",
"text"
],
"type": "string"
},
"method": {
"enum": [
"POST",
"PUT",
"PATCH"
],
"type": "string"
},
"type": {
"const": "http",
"type": "string"
}
},
"required": [
"type",
"method",
"bodyType",
"body"
],
"type": "object"
}
},
"required": [
"input"
],
"type": "object"
}