Want to access backend data for all my Dynamics data.

(3) 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 (5)

Answers (3)

Verified answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Community member 4 on at

Like (0)

Report
Copy link

Link copied!

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

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Verified answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Suggested answer

Komi Siabi 13,208 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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