{"slug":"agent-halowerk-com-v1-oss-openrefine-table-collision-review-685c4a","title":"Clusters a key column with native OpenRefine fingerprinting and returns a consol","host":"agent.halowerk.com","method":"POST","resource":"https://agent.halowerk.com/v1/oss-openrefine-table-collision-review-plan","category":"other","description":"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 a","price_listed":0.0035,"price_asked":0.0035,"state":"answering","state_label":"Answering","checks_7d":1,"answered_7d":1,"latency_ms_median":954,"reported_calls_30d":2,"reported_payers_30d":2,"networks":["eip155:8453"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"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ö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"]}]}},"bodyType":"json","method":"POST","type":"http"},"output_schema":{"$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"},"history":[{"day":"2026-10-24","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.0035,"price_match":true,"latency_ms":954,"error":null}],"description_full":"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.","last_updated":"2026-10-23T07:40:53.4Z","schemes":["exact"]}