Thursday, January 18, 2018

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
saurav-nav.blogspot.in