Dynamics Community Forum Thread Details

Replicating internal F&O tables

I'm working on an integration project where I need to understand the structure and potentially access the data of the underlying tables in Dynamics 365 for Finance and Operations (e.g., tables like LedgerJournalTrans, CustTable, VendTable, etc.).

Currently, I'm primarily using OData to interact with D365 F&O, which works well for data entities. However, I'm exploring whether there's a supported or recommended way to directly access the table structure (metadata) and potentially query the data within those tables, similar to how one might use SQL to query tables in a traditional database.

My specific questions are:

Is there any officially supported API, service, or method in D365 F&O that allows direct access to the underlying table structure and data, bypassing the data entity layer? (I understand that OData primarily deals with entities).

If direct table access is strongly discouraged or not feasible, what are the primary reasons behind this limitation? (e.g., data integrity, security, architectural considerations).

I need access to all the internal tables for an F&O instance.

Categories:

Dynamics 365 Finance

Quick Links