Stop Guessing Field Names: Why We Built the D365 OData Workbench

If you have spent more than an hour integrating with Dynamics 365 Finance & Operations, you know the specific flavor of pain I’m talking about.

You need to pull a list of Bank Accounts. Or maybe check a Customer Balance.

You open Postman. You type {{d365_url}}/data/. And then you pause. Is the entity called BankAccounts? BankAccountEntity? TrvBankAccount?

This is the "Integration Tax." It’s the hours we burn just trying to see the data.

The Problem: The ERP is a Black Box

Dynamics 365 is a powerhouse, but its external API surface is opaque. Unless you have the source code open, you are guessing field names and fighting syntax errors.

We decided to stop guessing. We treated the ERP not as an application, but as a database node.

Introducing the Demiton OData Workbench

We built this tool for ourselves. It is a browser-based IDE that connects directly to your D365 environment and gives you X-Ray vision.

https://www.youtube.com/watch?v=z33MR_T3zlo

1. Instant Schema Discovery

When you connect Demiton to FinOps, we don't just ping the URL. We crawl the metadata. We pull the full definition of every entity in the system—Standard and Custom.

Search by Label ("All Customers") or Name (CustCustomerV3).
See every field, type, and required status instantly.
No Visual Studio required.

2. Visual Query Builder

Stop writing query strings. Build them.

Cross-Company: Select USMF, DEMF, and GLSI from a dropdown. We generate the cross-company filter logic automatically.
Field Selection: Don't pull Select *. Check the boxes for the 5 fields you actually need.
Filter Logic: Add filters using a clean UI. We handle the OData syntax, the quotes, and the operators.

3. Live Execution

Hit Execute. We proxy the request through our secure gateway and show you the raw JSON response in milliseconds.

The Ask: Help Us Break It

We are looking for 20 Integration Architects to join the Pioneer Program. We want you to throw your messiest, most complex custom entities at the Workbench.

In return, you get:

Lifetime NFR Access: Use the Workbench for your own internal development.
The Engineering Hotline: A direct Discord channel to our core dev team.
Revenue Share: 15% commission on referred licenses.

Stop fighting the syntax. Start seeing the data.

Apply for the Pioneer Program →