Microsoft Dynamics NAV 2018 - API Part 1.

Hi all,

As most of us know that with Microsoft NAV 2018 Microsoft has released a great feature about API.

As per Microsoft, in standard NAV 44 API,  have been released.

In API Series of articles, we will cover what is available in standard NAV 2018 and how we can add more API in Microsoft Dynamics NAV 2018.


I will start with the way I start exploring this feature in a set of multiple articles. During series of these articles if you think we need to cover anything new let me know I will try to add that in future articles.

1. To Start with Microsoft have added a New Page Type in NAV 2018 i.e API as shown below.
With that Microsoft have added new page properties EntityName,EntitySetName & ODataKeyFields.
We will use these fields in future articles.

All API Pages in NAV 2018 are listed below -

ID	Name
5470	Item Entity
5471	Customer Entity
5472	Vendor Entity
5473	Company Information Entity
5475	Sales Invoice Entity
5477	Customer Paym. Journal Entity
5480	Account Entity
5481	Tax Group Entity
5482	Journal Entity
5483	Employee Entity
5484	G/L Entry Entity
5485	Currencies Entity
5486	Payment Methods Entity
5487	Dimensions Entity
5489	Dimension Lines Entity
5490	Payment Terms Entity
5491	Shipment Method Entity
5492	Item Categories Entity
5493	Cash Flow Statement Entity
5494	Country/Regions Entity
5495	Sales Order Entity
5497	Retained Earnings Entity
5498	Units of Measure Entity
5499	Aged AR Entity
5500	Aged AP Entity
5501	Balance Sheet Entity
5502	Trial Balance Entity
5503	Income Statement Entity
5504	Tax Area Entity
5505	Sales Quote Entity
5507	Sales Credit Memo Entity
5527	Purchase Invoice Entity
10900	IRS 1099 Form-Box Entity

Next exploration that I did was a field analysis that was added to these pages source table and to my surprise, Microsoft has added a new field with the name ID  & type GUID shown below. In most of the tables, the field is added in ID 8000.

TableNo	No.	TableName	FieldName	Type
3	8000	Payment Terms	Id	GUID
4	8000	Currency	Id	GUID
9	8000	Country/Region	Id	GUID
10	8000	Shipment Method	Id	GUID
15	8000	G/L Account	Id	GUID
18	8000	Customer	Id	GUID
23	8000	Vendor	Id	GUID
27	8000	Item	Id	GUID
36	8000	Sales Header	Id	GUID
38	8000	Purchase Header	Id	GUID
79	8000	Company Information	Id	GUID
81	8000	Gen. Journal Line	Id	GUID
112	8000	Sales Invoice Header	Id	GUID
114	8000	Sales Cr.Memo Header	Id	GUID
122	8000	Purch. Inv. Header	Id	GUID
133	8000	Incoming Document Attachment	Id	GUID
138	8000	Unlinked Attachment	Id	GUID
204	8000	Unit of Measure	Id	GUID
232	8000	Gen. Journal Batch	Id	GUID
289	8000	Payment Method	Id	GUID
318	8000	Tax Area	Id	GUID
321	8000	Tax Group	Id	GUID
323	8000	VAT Business Posting Group	Id	GUID
324	8000	VAT Product Posting Group	Id	GUID
348	8000	Dimension	Id	GUID
349	8000	Dimension Value	Id	GUID
560	8000	VAT Clause	Id	GUID
2850	8000	Native - API Tax Setup	Id	GUID
5200	8000	Employee	Id	GUID
5475	8000	Sales Invoice Entity Aggregate	Id	GUID
5476	8000	Sales Invoice Line Aggregate	Document Id	GUID
5477	8000	Purch. Inv. Entity Aggregate	Id	GUID
5478	8000	Purch. Inv. Line Aggregate	Document Id	GUID
5480	8000	Tax Group Buffer	Id	GUID
5489	8000	Dimension Set Entry Buffer	Dimension Id	GUID
5495	8000	Sales Order Entity Buffer	Id	GUID
5504	8000	Tax Area Buffer	Id	GUID
5505	8000	Sales Quote Entity Buffer	Id	GUID
5507	8000	Sales Cr. Memo Entity Buffer	Id	GUID
5509	8000	Attachment Entity Buffer	Id	GUID
5722	8000	Item Category	Id	GUID
10010	8000	IRS 1099 Form-Box	Id	GUID
50505	8000	My Master	Id	GUID
2000000006	8000	Company	Id	GUID

Will share next part of exploration in next articles.

Let me know your views and stay tuned for Part 2 of API Article in NAV 2018.

Regards,
Saurav Dhyani
www.sauravdhyani.com