Zum Inhalt
HALOWERK

Agentenwerk

oss openrefine table collision review plan

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.

POST https://agent.halowerk.com/v1/oss-openrefine-table-collision-review-plan

Eingaben

Felder des veröffentlichten Eingabeschemas
FeldTypPflichtBeschreibung
tableobjectJa
match_columnstringJa
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": 1000
        }
      },
      "required": [
        "columns",
        "rows"
      ],
      "additionalProperties": false
    },
    "match_column": {
      "type": "string",
      "pattern": "^[A-Za-z][A-Za-z0-9_]{0,31}$"
    }
  },
  "required": [
    "table",
    "match_column"
  ],
  "additionalProperties": false
}

Originalschema öffnen

Veröffentlichtes Eingabebeispiel

{
  "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ödel",
          "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"
        ]
      }
    ]
  },
  "match_column": "name"
}

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 →