import_data
Imports CSV or Excel files into Dynamics 365 Finance & Operations data projects through DMF, handling multiple entities, dependency order, validation, and optional wait for results.
Instructions
Import one or more data files into D365 through a DMF data project, as the signed-in user.
definition_group is the data project name (created automatically if it doesn't exist),
company the legal entity id (e.g. USMF). files lists {entity, file_path} pairs: entity
is the DMF entity name as shown in D365 (e.g. "Customer groups"; find it with search_entities),
file_path a .csv or .xlsx
whose first row holds the entity's field names (staging column names, e.g. CUSTOMERGROUPID;
list them with get_entity_fields).
Several entities can be imported in one call; D365 decides the order from their dependencies.
format is the file format in the package, free text and case-insensitive: "CSV" (default) and
"EXCEL" are the common ones; other CSV/Excel-based source formats on the environment
(e.g. "CSV-Unicode") also work. An unknown value returns the available ones.
Composite and XML-based entities are not supported.
With wait=True, polls until the import finishes (or the timeout); otherwise returns the
execution id to check with get_execution_status. dry_run only validates and builds the package.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| wait | No | ||
| files | Yes | ||
| format | No | CSV | |
| company | Yes | ||
| dry_run | No | ||
| definition_group | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |