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

Notifications

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 95,331 Super User 2025 Season 2 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,380 Super User 2025 Season 2 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,672 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans