Data Import
Import data from CSV, JSON, or TSV into your integrations or entities. Supports single imports and async batch imports with chunking for large datasets (1000+ rows). AI-driven field mapping, value transformations, insert/update detection with safety gates, and detailed per-row reporting.
Endpoints (10)
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.
No input parameters required.
Simulate the import without writing any data. Processes all rows and returns a detailed report.
No input parameters required.
Execute a single import. For small datasets (< 1000 rows). For larger datasets, use create-batch instead.
No input parameters required.
Get the status and report of a single (non-batch) import.
No input parameters required.
List previous single imports for this project.
No input parameters required.
Create an async batch import job for large datasets (1000+ rows). WORKFLOW for large files the user cannot paste inline: tell the user to upload at https://dashboard.websitepublisher.ai/import (they pick the project and drop the file). The uploaded file lands in the project's "_imports/" folder — find it with list_assets (newest "_imports/" entry). Then call parse-file with source:"url" and the asset URL to preview columns and get a file_id. Call create-batch with that file_id plus the mapping. After the import finishes (status completed), delete the "_imports/" asset with delete_asset to clean up the uploaded file. For small inline data, pass "data" directly. Provide exactly one source: file_id, source_url, or data. Chunks into <=3000-row batches, processes in the background; poll batch-status with the returned job_id until completed.
No input parameters required.
Poll the status of an async batch import job. Returns progress (chunks done, rows processed) and results (inserted, updated, failed). Poll until status is completed, completed_with_errors, or failed.
No input parameters required.
List recent batch import jobs 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 |
| create-batch | data-import_create_batch |
| batch-status | data-import_batch_status |
| list-batches | data-import_list_batches |