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.
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 | |||