Development with XMLPORT

XMLPORT is used for importing/exporting data from excel , text or XML in NAV.

What are the common requirement for XMLPORT by Client are listed below with ERRORS NAV Developer can face. So get ready to learn and explore.

Requirement 1. SKIP EXCEL Header.

This requirement is common while importing from Excel in NAV tables.

Solution.
Define a Boolean Field and write code as in Screen Shot.

 

Requirement 2.
Use OF EVALUATE Function to convert the Datatype.

Error 1.

Microsoft Dynamics NAV
---------------------------
Data at the root level is invalid. Line 1, position 1.
---------------------------
OK
---------------------------
Solution:

Error 2.

Microsoft Dynamics NAV
---------------------------
'', hexadecimal value 0x03, is an invalid character. Line 1, position 82.
---------------------------
OK
---------------------------
Solution :

Convert your Excel File to CSV Format.

 

Flow of Triggers in XMLPORT during Import of XMLPORT

OnInit

 

OnPre

 

OnAfterInit

 

Text Variable OnAfter Assign

 

OnBeforeInsert

 

OnAfterInsert

 

Root Import

 

OnPost Trigger

What is the difference between ODATA URL and ODATAV4 URL in NAV?

Hi ,

Today while working on API I got this new ODATA V4 url in NAV 2018. Best part is it will help Nav developers to provide JSON data.

Yes this is correct whenever you will give ODATA V4 Login you will receive a json format data from NAV 2018.

ODATA V4 URL :

Result 1 : ODATA URL

Result 2 : ODATA V4 URL

Result 3 : SOAP Result.