Zum Inhalt
HALOWERK

Agentenwerk

oss openrefine reference catalog reconciliation review

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.

POST https://agent.halowerk.com/v1/oss-openrefine-reference-catalog-reconciliation-review

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
tableobjectJa
query_columnstringJa
catalogarrayJa
required_typestringJa
max_edit_distanceintegerJa
Vollständiges Eingabeschema anzeigen
{
  "type": "object",
  "properties": {
    "table": {
      "type": "object",
      "properties": {
        "columns": {
          "type": "array",
          "items": {
            "type": "string",
            "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
          },
          "minItems": 1,
          "maxItems": 16
        },
        "rows": {
          "type": "array",
          "items": {
            "type": "object",
            "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"
                    }
                  ]
                },
                "minItems": 1,
                "maxItems": 16
              }
            },
            "required": [
              "id",
              "values"
            ],
            "additionalProperties": false
          },
          "minItems": 1,
          "maxItems": 200
        }
      },
      "required": [
        "columns",
        "rows"
      ],
      "additionalProperties": false
    },
    "query_column": {
      "type": "string",
      "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
    },
    "catalog": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "id": {
            "type": "string",
            "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
          },
          "name": {
            "type": "string",
            "minLength": 1,
            "maxLength": 256
          },
          "type": {
            "type": "string",
            "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
          }
        },
        "required": [
          "id",
          "name",
          "type"
        ],
        "additionalProperties": false
      },
      "minItems": 1,
      "maxItems": 100
    },
    "required_type": {
      "type": "string",
      "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
    },
    "max_edit_distance": {
      "type": "integer",
      "minimum": 0,
      "maximum": 8
    }
  },
  "required": [
    "table",
    "query_column",
    "catalog",
    "required_type",
    "max_edit_distance"
  ],
  "additionalProperties": false
}

Originalschema öffnen

Veröffentlichtes Eingabebeispiel

{
  "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ödel",
          "009"
        ]
      }
    ]
  },
  "query_column": "name",
  "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"
    }
  ],
  "required_type": "org",
  "max_edit_distance": 0
}

Ergebnis & Dokumentation

Maschinenlesbare Dokumentation dieses Hubs

Quelle dieser Seite: der veröffentlichte HALOWERK-Katalog. Stand: 2026-11-01, 15:19 UTC.

Weitere Endpunkte dieses Hubs

Alle Endpunkte dieses Hubs →