{"service":"HALOWERK agentenwerk","endpoint":"/v1/oss-openrefine-table-collision-review-plan","method":"POST","content_type":"application/json","inputSchema":{"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},"requestExample":{"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"},"operations":[{"method":"POST","inputSchema":{"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},"requestExample":{"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"}}],"example_request":{"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"},"serviceName":"oss_openrefine_table_collision_review_plan","tags":["oss","openrefine","p043"],"outputSchema":{"type":"object","properties":{"operation":{"const":"table-collision-review-plan"},"result":{"type":"object","properties":{"plan":{"type":"object","properties":{"artifact_id":{"type":"string","minLength":1,"maxLength":128},"sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"bytes":{"type":"integer","minimum":1,"maximum":8388608},"media_type":{"const":"application/json"}},"required":["artifact_id","sha256","bytes","media_type"],"additionalProperties":false},"source_table_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"native_projection_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"groups":{"type":"array","items":{"type":"object","properties":{"group_id":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"row_ids":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":2,"maxItems":1000},"fingerprint":{"type":"string","minLength":1,"maxLength":4096},"preferred_value":{"type":"string","minLength":1,"maxLength":4096},"conflict_columns":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":0,"maxItems":15},"kind":{"enum":["native_fingerprint_collision","exact_value_repeat"]},"requires_review":{"const":true}},"required":["group_id","row_ids","fingerprint","preferred_value","conflict_columns","kind","requires_review"],"additionalProperties":false},"minItems":0,"maxItems":500},"excluded_rows":{"type":"array","items":{"type":"object","properties":{"row_id":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"reason":{"enum":["null_match_value","empty_fingerprint"]}},"required":["row_id","reason"],"additionalProperties":false},"minItems":0,"maxItems":1000},"singleton_row_ids":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":0,"maxItems":1000},"native_distinct_value_cluster_count":{"type":"integer","minimum":0,"maximum":500},"source_rows":{"type":"integer","minimum":1,"maximum":1000},"source_unchanged":{"const":true},"automatic_merges_applied":{"const":0},"scope":{"const":"lexical_collision_candidates_not_confirmed_entity_identity"},"warnings":{"type":"array","items":{"type":"string","minLength":1,"maxLength":1024},"minItems":1,"maxItems":16}},"required":["plan","source_table_sha256","native_projection_sha256","groups","excluded_rows","singleton_row_ids","native_distinct_value_cluster_count","source_rows","source_unchanged","automatic_merges_applied","scope","warnings"],"additionalProperties":false},"upstream":{"type":"object","properties":{"project":{"const":"OpenRefine"},"version":{"const":"3.10-SNAPSHOT"},"source_commit":{"const":"1e6e28f4fc3724ff4bfd55de1bfe2ca1b6b41141"},"runtime_bundle_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"components":{"const":["FingerprintKeyer","BinningClusterer","Project","Engine"]},"canonical_request_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"java_locale":{"const":"ROOT"},"timezone":{"const":"UTC"}},"required":["project","version","source_commit","runtime_bundle_sha256","components","canonical_request_sha256","java_locale","timezone"],"additionalProperties":false},"runtime_ms":{"type":"number","minimum":0,"maximum":180000}},"required":["operation","result","upstream","runtime_ms"],"additionalProperties":false}}