Want to access backend data for all my Dynamics data.

(2) Share

Report

Posted on by Community member

I am storing my information in various modules and forms in Dynamics such as InvoiceJournal, Vendors. I want to access the backend data tables which comprises data entries about these modules and forms, so that I can utilize this data to connect to my 3rd party application and utilize it. How can I access these backend tables which contain all my entries.

I have the same question (0)

All responses (6)

Answers (3)

CU08051205-0 on at

Like (0)

Report

Want to access backend data for all my Dynamics data.

Dynamics' backend data can be accessed through OData or Web API endpoints. These APIs allow users to query the Dynamics system tables for data. The names of the entities are needed for modules such as InvoiceJournal and Vendors. You can directly fetch data using these APIs by integrating with 3rd party apps. If you require more specific data filtering, use the "FetchXML" queries. It is also important to check that you have the appropriate permissions to access these tables. I found this useful when working alongside tools like their backend services for smoother data flow.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,032 Most Valuable Professional on at

Like (0)

Report

Want to access backend data for all my Dynamics data.

Hello,

You can, yourself figure out name of fields and tables they belong to from the form(user interface). Please, check this video.

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

You can gradually makes sense of all tables that make up a form to guide you on what tables->Data entity to use exactly.

Was this reply helpful? Yes No
Verified answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

Want to access backend data for all my Dynamics data.

I Believe Tables are not exposed directly for use (except for few options like Azure Data Lake). You can get form name and tables involved from User Interface but as you mentioned the structure can be different like not all fields available in data entity etc. You can extend standard data entities or create custom entities.

Was this reply helpful? Yes No
Verified answer

GirishS 27,825 Moderator on at

Like (0)

Report

Want to access backend data for all my Dynamics data.

You can find out the entities used in the form using the office icon. You need to know the form then only you can identify the entities related to the form. Otherwise it will hard to find out.

After finding out the name under Open in excel - You can find out the backend name by navigating to System administration >> Workspaces >> Data manegement

From the above screenshot Target entity column will indicate the name of the entity in the backend.

One more option will be identifying the form name from the front end - Navigate to that form from backend - Find out the datasource - Navigate to the table - Do the find reference of the table and it will show list of objects that is using that table including data entity.

Thanks,

Girish S.

Was this reply helpful? Yes No
Community member 2 on at

Like (0)

Report

Want to access backend data for all my Dynamics data.

Hey @MohitRampal I have used OData to access D365 data, but the tables are of different structure and table names , it is hard to figure out which information is saved in which table. I want to access tables which d365 stores in backend for required entries.

Was this reply helpful? Yes No
Verified answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

Want to access backend data for all my Dynamics data.

Hi, You didn't provided enough details on integration with 3rd party but one way is to use OData to access D365FO data via public data entities.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata

Was this reply helpful? Yes No