Perform OData entity operations in Dynamics 365 Finance and Operations
domain: Dynamics 365 Finance and Operations OData · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Steps
Register an Azure AD application in the tenant, grant it the Dynamics ERP API permission ('user_impersonation' or application-level access), and create a client secret; record the client ID and tenant ID.
Acquire an access token via the OAuth 2.0 client credentials flow: POST to https://login.microsoftonline.com/YOUR_TENANT/oauth2/v2.0/token with client_id, client_secret, grant_type=client_credentials, and scope=https://YOUR_D365_ENV.operations.dynamics.com/.default.
Send requests to the OData endpoint at https://YOUR_D365_ENV.operations.dynamics.com/data/EntityName, using standard OData query options ($filter, $select, $expand, $top, $skip) for GET and JSON bodies for POST/PATCH/DELETE.
For write operations include the 'If-Match: *' header for PATCH and DELETE to bypass ETag validation, or supply the actual ETag from a prior GET if optimistic concurrency is required.
Handle HTTP 429 (throttling) responses with exponential backoff; D365 F&O enforces per-user and per-application request rate limits.
Known gotchas
Not all data entities are enabled for OData by default; the entity must have 'Is Public' set to Yes in the data entity properties in Visual Studio / LCS, otherwise it returns 404.
Cross-company data access requires appending '?cross-company=true' and specifying the DataAreaId in the filter; without this only records for the default legal entity are returned.
Batch requests ($batch) using multipart/mixed reduce round-trips but require strict MIME boundary formatting; malformed batch envelopes return 400 with minimal diagnostics.
Give your agent this knowledge — and 15,500+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?