To create an XMLport that imports the data in an XML document, you specify all the XML node names and indicate the type for each node to indicate whether it represents an element or an attribute. You then map these node names to corresponding data structures, such as tables, records, or fields, in the Microsoft Dynamics NAV database.

At run time, when an XMLport object is called to handle an incoming XML document, it reads the incoming data stream and performs the processing and database actions. When you want to create an XMLport to export data from the Microsoft Dynamics NAV database in XML format, you use the XMLport Designer to build the node structure of the XML document and map the data. At run time, the XMLport object reads the required data from the database, adds the necessary XML nodes to form the XML document, and writes the document to a data stream.

XMLports do not handle XML documents that:

• Modify existing data in the database.

• Find and delete data in the database.

• Query the database for data, such as item catalog information.

If you need to work with an incoming document of one of these types, then you can use C/AL code to manipulate the database to achieve the desired result.

Note
Do not use a semicolon within a quoted argument as a field value when importing a file through an XMLport. Even within a quoted argument, the semicolon is interpreted as a record separator.

Concepts