Reconciles a column of names against a reference catalog that you supply — your
Reconciles a column of names against a reference catalog that you supply — your catalog, not a public knowledge base — using native OpenRefine reconciliation with a caller-set edit distance and an optional required type. The result separates rows with a single candidate, rows with several, and rows with none, and it leaves the ambiguous ones ambiguous: an automatic pick would be the cheapest possible way to introduce a wrong identity into a reference dataset.
Answeringour last check, 2026-10-24
1 of 1checks answered this week
1209 msmedian answer time
$0.004listed price per call
$0.004price it asked us
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-reference-catalog-reconciliation-review
| 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.004 | 1209 ms |
Example input (from the provider)
{
"body": {
"catalog": [
{
"id": "ref_a",
"name": "Aa",
"type": "org"
},
{
"id": "ref_b",
"name": "BB",
"type": "org"
},
{
"id": "ref_acme",
"name": "Acme Ltd",
"type": "org"
},
{
"id": "ref_acme_reordered",
"name": "Ltd Acme",
"type": "org"
},
{
"id": "ref_person",
"name": "Aa",
"type": "person"
},
{
"id": "ref_godel",
"name": "Godel",
"type": "org"
}
],
"max_edit_distance": 0,
"query_column": "name",
"required_type": "org",
"table": {
"columns": [
"name",
"source_code"
],
"rows": [
{
"id": "row_a",
"values": [
"Aa",
"001"
]
},
{
"id": "row_b",
"values": [
"BB",
"002"
]
},
{
"id": "row_a_repeat",
"values": [
"Aa",
"003"
]
},
{
"id": "row_ambiguous",
"values": [
"Acme Ltd",
"004"
]
},
{
"id": "row_none",
"values": [
"ZZ",
"005"
]
},
{
"id": "row_null",
"values": [
null,
"006"
]
},
{
"id": "row_empty",
"values": [
"",
"007"
]
},
{
"id": "row_punctuation",
"values": [
"!!!",
"008"
]
},
{
"id": "row_accent",
"values": [
"G\u00f6del",
"009"
]
}
]
}
},
"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": {
"catalog": {
"items": {
"additionalProperties": false,
"properties": {
"id": {
"pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$",
"type": "string"
},
"name": {
"maxLength": 256,
"minLength": 1,
"type": "string"
},
"type": {
"pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$",
"type": "string"
}
},
"required": [
"id",
"name",
"type"
],
"type": "object"
},
"maxItems": 100,
"minItems": 1,
"type": "array"
},
"max_edit_distance": {
"maximum": 8,
"minimum": 0,
"type": "integer"
},
"query_column": {
"pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$",
"type": "string"
},
"required_type": {
"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": 200,
"minItems": 1,
"type": "array"
}
},
"required": [
"columns",
"rows"
],
"type": "object"
}
},
"required": [
"table",
"query_column",
"catalog",
"required_type",
"max_edit_distance"
],
"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"
}