Business Central API

Mercury
Mercury Member Posts: 3
in General Chat
Hello,
Is there a document that outlines the (logical) tables and colums in Nav/BC?
AL Object Designer is helpful. if you know of other resources, please post here

Best Answer

Answers

  • micieboris
    micieboris Member Posts: 7
    What do you mean with API in your title?
    You are requesting an overview of all tables and columns in NAV?

    NAV has System Tables which are not available through Object Designer.
    System-Table "Objects" contains all Tables.
    System-Table "Fields" contains all Fields.
  • Mercury
    Mercury Member Posts: 3
    Thanks for the reply.

    I am new to NAV/Business Central.
    Mercury, our reporting software, uses OData endpoints as data sources for our reports. So, any query or page that is published as a webservice can be a report source in Mercury.

    When we get a request for a specialized report, often that requires querying multiple tables. When i build a page or a query in AL, i need to know the data items and fields i will need. (coming from Dynamics GP, there may be more than one place to get data - a Transactions table or a Summary table).

    It would be great to have a document that could provide an overview of the tables and fields and how they are linked.

  • Mercury
    Mercury Member Posts: 3
    Thank you. that was helpful.

Categories