Dynamics 365 MCP Integration

Weldable's Dynamics 365 MCP integration gives your AI agents access to Microsoft's enterprise CRM and ERP platform through natural language. Microsoft's 2026 release wave 1 introduced AI-powered agents across sales, service, finance, and supply chain, and Weldable builds on the Dynamics 365 Web API to let your agents query, create, and update records without writing OData queries or managing complex authentication flows.

Your agent works with standard Dynamics 365 entities: leads, contacts, accounts, opportunities, cases, and custom entities. Describe your intent in plain English and Weldable handles the entity resolution, field mapping, and API execution.

Use cases

Opportunity pipeline monitoring

Your agent queries all open opportunities with close dates in the current quarter, grouped by sales stage and owner. It calculates weighted pipeline value using probability percentages from each stage, then posts a summary to a Slack channel or writes it to a Google Sheet. Sales leadership gets an always-current forecast without running reports manually in Dynamics.

Case SLA tracking and escalation

Your agent monitors open cases and compares their age against SLA thresholds defined by priority level. When a case breaches its response or resolution target, the agent updates the priority, reassigns it to a senior agent, and posts the case details to a support escalation channel in Slack. Your support team catches SLA risks before they become customer complaints.

Lead qualification from external data

When a new lead arrives in Dynamics 365, your agent queries Clearbit or Apollo for firmographic data about the lead's company. It updates the lead record with enriched fields like employee count, revenue range, and industry, then applies a qualification score. Leads meeting your threshold get converted to opportunities automatically. Leads that do not qualify get tagged for marketing nurture.

Cross-system account reconciliation

Companies running Dynamics 365 alongside other CRMs or ERPs can keep account records consistent. Your agent reads accounts from Dynamics, matches them against records in Salesforce or a Google Sheet by domain or account name, and flags discrepancies like mismatched addresses, different primary contacts, or conflicting revenue figures for review.

Automated activity follow-ups

After a sales call or meeting, your agent reads the associated opportunity, checks for recent activity history, and creates a follow-up task with a due date based on the deal stage. It can also draft a follow-up email through Gmail and log the interaction back to the Dynamics timeline, keeping the CRM record complete without the rep doing double entry.

How it works

Connect your Dynamics 365 environment through OAuth. Weldable handles the Azure AD authorization flow and manages token refresh in the background. Your agent translates natural language into Dynamics 365 Web API calls, resolving entity names, attribute references, and filter expressions automatically.

Once connected, your agent can perform CRUD operations on any standard or custom entity, run filtered queries, and chain Dynamics actions with other services. Build workflows that span Dynamics 365, Slack, Google Sheets, Gmail, and any other connected integration.

Tips

Use logical entity names. Dynamics 365 uses logical names like opportunity and systemuser rather than display names. Your agent handles common variations, but using the logical name directly removes ambiguity for custom entities.

Filter queries with OData-style conditions. When your agent searches for records, include conditions like date ranges, status codes, or owner IDs. Dynamics 365 API response sizes are capped, and broad queries may return truncated results or hit throttling limits.

Map custom fields carefully. Dynamics 365 custom fields follow a publisher prefix pattern like cr123_customfield. When your workflows reference these fields, use the full logical name so your agent resolves them correctly against your environment's schema.

Test against a sandbox environment. Dynamics 365 offers sandbox instances that mirror production. Connect a sandbox to Weldable first to validate write operations and ensure your workflows behave correctly before running them against live data.

Combine with Power BI data via Google Sheets. If your team uses Power BI for reporting, have your agent write summarized Dynamics data to Google Sheets as an intermediate step. This gives stakeholders without Dynamics licenses access to pipeline and case data in a format they can work with immediately.