validate_migration_file
Validates CSV import files for migration by checking column headers, data types, required fields, picklist values, and foreign key references. Returns a detailed error report per row.
Instructions
Deep validation of a migration/import CSV file.
Validates:
Column headers match entity metadata
Key fields are present and populated
Data types are correct (dates, numbers, strings)
Required fields are populated
Picklist values exist (strict mode)
Foreign key references exist (strict mode)
Date format consistency
Returns detailed error report per row.
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": {
"entity": "<entity>",
"file_content": "<file_content>"
},
"name": "validate_migration_file"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| entity | Yes | Target entity (e.g., 'EmpJob', 'FODepartment') | |
| strict | No | Strict mode: also validate picklist values and foreign key references exist | |
| data_center | No | ||
| auth_user_id | No | ||
| file_content | Yes | CSV file content as string | |
| auth_password | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||