Business Central API

Mercury

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

vaprog

Google for The Big Picture of NAV

There are objects for download on this site, and there is more info at Kine's Info - The Art Of Nav – Big Picture of NAV

Another approach can be found at dynamicsdocs.com

micieboris

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

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.

vaprog

Google for The Big Picture of NAV

There are objects for download on this site, and there is more info at Kine's Info - The Art Of Nav – Big Picture of NAV

Another approach can be found at dynamicsdocs.com

Mercury

Thank you. that was helpful.