web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to get access to a...
Small and medium business | Business Central, N...
Suggested Answer

How to get access to all tables via API calls

(1) ShareShare
ReportReport
Posted on by mdodge 8
We are using Business Central online for much of our financial and production data.  We had a third party create custom extensions for us to get and post data using API calls.  One of the API calls looks like this:
{{URL}}/{{TENANTID}}/{{ENV}}/{{ECGAPIPath}}/companies({{COMPANYID}})/productionOrders?$filter=status eq 'Released'&$select=id,status,sourceNo...
 
The URL variable is: https:/api.businesscentral.dynamics.com/v2.0. Now we are wanting to create our own API calls to get data from our Business Central database.  How can we find the API calls needed to get all the tables and attributes from our Business Central database?  And then secondly, start getting data from each of the tables?
 
Thanks!
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,611 Super User 2026 Season 1 on at
    By default, BC does not publish all tables in the database. . . .
    You can only use standard APIs, or Webservices.
    Hope the following can give you some hints.
    Standard API for Dynamics 365 Business Central SaaS (Get, Post, Patch, Delete and Basic query parameters – filter, orderby, select…)
    Dynamics 365 Business Central: A simple way to view the list of all APIs
    Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs
     
    Thanks.
    ZHU
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 14,419 User Group Leader on at
    Hi,
     
    As YUN ZHU mentioned you cannot do that.
     
    For CURD operations you will need an API endpoint created. I don't think you need all tables.
     
    Identify your entities that you need and create custom API Endpoints if required. 
     
    I think, it's possible (just for reading purpose), you can create a generic API endpoint to get Records based on table id and field ids only.  
     
     
    Regards,
    Saurav Dhyani
  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,692 Moderator on at
    BC has some APIs out of the box that you can use. In most situations you need more APIs or more fields and then it's best to develop your own APIs. It's really not difficult to do.
     
    Want to learn how to develop, have a look here:

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,937 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,031 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 700 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans