Clean a table
clean_tableClean a table: trim spaces, turn empty strings into null, remove duplicate rows, and optionally parse numeric strings (1,5 or 1 234) and normalize column names to snake_case. Returns the cleaned rows and a report.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"rows": "<rows>"
},
"name": "clean_table"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | Table as an array of flat JSON objects (one per row), up to 500 rows. | |
| trim | No | Trim spaces (default true). | |
| dedupe | No | Remove duplicate rows (default true). | |
| empty_to_null | No | Empty strings become null (default true). | |
| parse_numbers | No | Convert numeric strings to numbers (default false). | |
| normalize_keys | No | Rename columns to snake_case (default false). |