Skip to main content
Glama

dmf_import_file

Destructive

Bulk-import a CSV file into a D365 F&O entity through the Data Management package REST API. Builds the package (Manifest + header + CSV) in memory, uploads it to Azure blob, then calls ImportFromPackage which AUTO-CREATES the data project from the manifest. Runs in batch; the tool polls until completion and returns the final status plus an error-keys file URL when rows fail. Provide either filePath (a .csv on disk) or inline csvContent. Resolve the entity name from the KB (find_entity_for_table) -- do not invent it.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
executeNoExecute the import after staging (true) or stage only (false). Default true.
filePathNoPath to a .csv file on disk. Provide this OR csvContent.
overwriteNoOverwrite an existing project definition with the same id. Default true.
csvContentNoInline CSV content (header row + data). Provide this OR filePath.
entityNameYesTarget entity name as known to DMF (the entity, not the OData set), e.g. 'Customers V3'.
legalEntityYesLegal entity / company id to import into, e.g. 'USMF'.
definitionGroupIdNoDMF definition group (data project) id. Default: auto-generated from entity + timestamp.
pollTimeoutSecondsNoMax seconds to poll for completion before returning the executionId. Default 300.

Schema Changelog

Changes observed during successful MCP inspections.

  1. Added

TDQS

A4.6/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Adds substantial context beyond the annotations: the in-memory package build, Azure blob upload, ImportFromPackage call, the auto-creation of the data project, batch execution with polling, and an error-keys file URL on row failures. The destructiveHint and non-idempotent annotations are consistent with the described overwrite-and-import behavior, so there is no contradiction.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Four sentences arranged as purpose, mechanism, execution behavior, then usage requirements — front-loaded and logically ordered with no filler. For a tool this complex, each sentence earns its place.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Since no output schema exists, the description correctly covers return values (final status and error-keys file URL) plus the full execution flow. Minor gaps: 'polls until completion' overlooks the pollTimeoutSeconds early-return behavior, and the stage-only mode (execute=false) appears only in the schema — both are documented there, limiting practical impact.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3, but the description adds genuine semantic value by tying entityName to a resolution workflow ('Resolve the entity name from the KB (find_entity_for_table) -- do not invent it'), which the schema's example does not convey. The filePath/csvContent exclusivity is useful reinforcement even though both parameter descriptions already state it.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The first sentence states a specific verb and resource — 'Bulk-import a CSV file into a D365 F&O entity through the Data Management package REST API' — and the AUTO-CREATES clause explicitly distinguishes it from sibling dmf_create_data_project. The import direction separates it from dmf_export_package and odata_export_entity, so an agent can pick it without opening schemas.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides clear usage context: the caller must supply either filePath or csvContent, and it instructs the agent to resolve entityName via find_entity_for_table ('do not invent it'), naming the right sibling for the prerequisite step. It stops short of explicit when-not-to-use guidance against alternatives such as odata_upsert_rows for non-bulk loads.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.