Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Want to access backend data for all my Dynamics data.

(0) ShareShare
ReportReport
Posted on by 2
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.
  • Suggested answer
    Komi Siabi Profile Picture
    Komi Siabi 12,759 Most Valuable Professional on at
    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.
     
     
    You can gradually makes sense of all tables that make up a form to guide you on what tables->Data entity to use exactly.
  • Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    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. 
  • Suggested answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    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.
  • 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.
  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,552 Super User 2024 Season 1 on at
    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.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans