{"service":"HALOWERK agentenwerk","endpoint":"/v1/oss-openrefine-verified-table-recipe-replay","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},"steps":{"type":"array","items":{"oneOf":[{"type":"object","properties":{"op":{"const":"normalize_text"},"column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"trim":{"type":"boolean"},"case":{"enum":["preserve","lower","upper"]}},"required":["op","column","trim","case"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"replace_values"},"column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"edits":{"type":"array","items":{"type":"object","properties":{"from":{"type":"array","items":{"type":"string","minLength":1,"maxLength":4096},"minItems":1,"maxItems":32},"to":{"type":"string","maxLength":4096}},"required":["from","to"],"additionalProperties":false},"minItems":1,"maxItems":32}},"required":["op","column","edits"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"add_text_column"},"name":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"columns":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":1,"maxItems":8},"separator":{"type":"string","maxLength":64},"null_policy":{"enum":["empty","propagate"]}},"required":["op","name","columns","separator","null_policy"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"rename_column"},"column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"name":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"}},"required":["op","column","name"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"remove_column"},"column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"}},"required":["op","column"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"reorder_columns"},"columns":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":1,"maxItems":16}},"required":["op","columns"],"additionalProperties":false}]},"minItems":1,"maxItems":16}},"required":["table","steps"],"additionalProperties":false},"requestExample":{"table":{"columns":["name","code","status","notes"],"rows":[{"id":"r1","values":[" Élodie "," X1 ","yes",null]},{"id":"r2","values":["ALICE","x2","Y",""]},{"id":"r3","values":[null,"001","no","keep"]}]},"steps":[{"op":"normalize_text","column":"name","trim":true,"case":"lower"},{"op":"normalize_text","column":"code","trim":true,"case":"preserve"},{"op":"replace_values","column":"status","edits":[{"from":["yes","Y"],"to":"active"},{"from":["no"],"to":"inactive"}]},{"op":"add_text_column","name":"label","columns":["name","code"],"separator":" / ","null_policy":"empty"},{"op":"rename_column","column":"code","name":"external_id"},{"op":"remove_column","column":"notes"}]},"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},"steps":{"type":"array","items":{"oneOf":[{"type":"object","properties":{"op":{"const":"normalize_text"},"column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"trim":{"type":"boolean"},"case":{"enum":["preserve","lower","upper"]}},"required":["op","column","trim","case"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"replace_values"},"column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"edits":{"type":"array","items":{"type":"object","properties":{"from":{"type":"array","items":{"type":"string","minLength":1,"maxLength":4096},"minItems":1,"maxItems":32},"to":{"type":"string","maxLength":4096}},"required":["from","to"],"additionalProperties":false},"minItems":1,"maxItems":32}},"required":["op","column","edits"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"add_text_column"},"name":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"columns":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":1,"maxItems":8},"separator":{"type":"string","maxLength":64},"null_policy":{"enum":["empty","propagate"]}},"required":["op","name","columns","separator","null_policy"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"rename_column"},"column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"name":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"}},"required":["op","column","name"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"remove_column"},"column":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"}},"required":["op","column"],"additionalProperties":false},{"type":"object","properties":{"op":{"const":"reorder_columns"},"columns":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":1,"maxItems":16}},"required":["op","columns"],"additionalProperties":false}]},"minItems":1,"maxItems":16}},"required":["table","steps"],"additionalProperties":false},"requestExample":{"table":{"columns":["name","code","status","notes"],"rows":[{"id":"r1","values":[" Élodie "," X1 ","yes",null]},{"id":"r2","values":["ALICE","x2","Y",""]},{"id":"r3","values":[null,"001","no","keep"]}]},"steps":[{"op":"normalize_text","column":"name","trim":true,"case":"lower"},{"op":"normalize_text","column":"code","trim":true,"case":"preserve"},{"op":"replace_values","column":"status","edits":[{"from":["yes","Y"],"to":"active"},{"from":["no"],"to":"inactive"}]},{"op":"add_text_column","name":"label","columns":["name","code"],"separator":" / ","null_policy":"empty"},{"op":"rename_column","column":"code","name":"external_id"},{"op":"remove_column","column":"notes"}]}}],"example_request":{"table":{"columns":["name","code","status","notes"],"rows":[{"id":"r1","values":[" Élodie "," X1 ","yes",null]},{"id":"r2","values":["ALICE","x2","Y",""]},{"id":"r3","values":[null,"001","no","keep"]}]},"steps":[{"op":"normalize_text","column":"name","trim":true,"case":"lower"},{"op":"normalize_text","column":"code","trim":true,"case":"preserve"},{"op":"replace_values","column":"status","edits":[{"from":["yes","Y"],"to":"active"},{"from":["no"],"to":"inactive"}]},{"op":"add_text_column","name":"label","columns":["name","code"],"separator":" / ","null_policy":"empty"},{"op":"rename_column","column":"code","name":"external_id"},{"op":"remove_column","column":"notes"}]},"serviceName":"oss_openrefine_verified_table_recipe_replay","tags":["oss","openrefine","p043"],"outputSchema":{"type":"object","properties":{"operation":{"const":"verified-table-recipe-replay"},"result":{"type":"object","properties":{"table":{"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},"native_recipe":{"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},"provenance":{"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}$"},"result_table_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"reopened_table_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"replayed_table_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"output_columns":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":1,"maxItems":16},"row_ids":{"type":"array","items":{"type":"string","pattern":"^[A-Za-z][A-Za-z0-9_]{0,31}$"},"minItems":1,"maxItems":1000},"step_count":{"type":"integer","minimum":1,"maximum":16},"step_results":{"type":"array","items":{"type":"object","properties":{"index":{"type":"integer","minimum":0,"maximum":15},"operation":{"enum":["normalize_text","replace_values","add_text_column","rename_column","remove_column","reorder_columns"]},"before_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"after_sha256":{"type":"string","pattern":"^[a-f0-9]{64}$"},"changed_cell_count":{"type":"integer","minimum":0,"maximum":16000},"outcome":{"enum":["changed","no_change"]}},"required":["index","operation","before_sha256","after_sha256","changed_cell_count","outcome"],"additionalProperties":false},"minItems":1,"maxItems":16},"native_history_verified":{"const":true},"persistence_verified":{"const":true},"original_input_replay_verified":{"const":true},"scope":{"const":"declared_native_recipe_and_exact_input_replay_not_generated_program_synthesis"},"warnings":{"type":"array","items":{"type":"string","minLength":1,"maxLength":1024},"minItems":1,"maxItems":16}},"required":["table","native_recipe","provenance","source_table_sha256","result_table_sha256","reopened_table_sha256","replayed_table_sha256","output_columns","row_ids","step_count","step_results","native_history_verified","persistence_verified","original_input_replay_verified","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":["Recipe","TextTransformOperation","MassEditOperation","ColumnAdditionOperation","ColumnRenameOperation","ColumnRemovalOperation","ColumnReorderOperation","History","ProcessManager","Project"]},"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":300000}},"required":["operation","result","upstream","runtime_ms"],"additionalProperties":false}}