Data Import
Import data from CSV, JSON, or TSV into your integrations or entities. Supports AI-driven field mapping, value transformations, insert/update detection with safety gates, and detailed per-row reporting.
Endpoints (7)
Parse source data (CSV/JSON/TSV as text, or file via URL) and detect columns, types, and sample data. Returns a file_id for subsequent calls.
No input parameters required.
Get the field schema of the import target. For IAPI: reads from integration manifest. For MAPI: reads from entity definition.
No input parameters required.
Validate a field mapping configuration against the parsed source file and target schema. Returns warnings and estimated insert/update counts.
No input parameters required.
Simulate the import without writing any data. Processes all rows and returns a detailed report of what would happen.
No input parameters required.
Execute the import. Inserts are unlimited. Updates require a prior dry-run when 2+ records would be affected, plus explicit confirmation with record IDs.
No input parameters required.
Get the status and report of a running or completed import.
No input parameters required.
List previous imports for this project.
No input parameters required.
MCP Tool Names
When using this integration through an AI assistant (Claude, ChatGPT, Cursor, etc.), the endpoints are available as MCP tools:
| Endpoint | MCP Tool Name |
|---|---|
| parse-file | data-import_parse_file |
| get-target-schema | data-import_get_target_schema |
| validate-mapping | data-import_validate_mapping |
| dry-run | data-import_dry_run |
| execute-import | data-import_execute_import |
| get-import-status | data-import_get_import_status |
| list-imports | data-import_list_imports |