แก้ไข

แชร์ผ่าน

Defining an XMLport schema

  • บทความ

You use an XMLport object to export and import data between an external source and Business Central. The schema determines which data and how that data is extracted from or inserted into the Business Central database tables through an XMLport. Learn more in XMLport object and about designing XMLports in XMLport overview.

You build the XMLport schema from nodes. A node can be one of the following elements:

  • A text element
  • A text attribute
  • A table element
  • A field element
  • A field attribute

You nest nodes inside other nodes to define the structure of the XMLport schema. Use the following keywords to define the structure.

Keyword Description
textelement Defines a new text element in the XMLport. It's used for XML elements that don't map to a database item or when the database doesn't need the information.
textattribute Defines a new text attribute in the XMLport. It's used for XML attributes that don't map to a database item or when the database doesn't need the information.
tableelement Defines a new table element in the XMLport. It's used for XML elements that map to a table in the database, which is specified in the SourceTable property. When the XMLport is run, the code nested inside the table element is iterated for all records in the underlying table.
fieldelement Defines a new field element in the XMLport. It's used for XMLport elements that map to a field in the database, which is specified in the SourceField property. You must specify it inside the parent table element of the field.
fieldattribute Defines a new field attribute in the XMLport. It's used for XMLport attributes that map to a field in the database, which is specified in the SourceField property.

Note

There can only be one <root> node, which must be an element. If the Format property is set to Xml, it must be a textelement node.

There can be several attributes for a single element and their order doesn't matter. Attribute nodes must be specified inside the element nodes they refer to and before other element nodes. They can't have nested element nodes.

Snippet support

Typing the shortcut txmlport creates the basic layout for an XMLport object when using the AL Language extension for Microsoft Dynamics 365 Business Central in Visual Studio Code.

Example

The following example adds the Customer table as a table element, the Address field as a field element and the County and City fields as field attributes.

schema
{
    textelement(Customers)
    {
        tableelement(Customer; Customer)
        {
            fieldelement(Address; Customer.Address)
            {
                fieldattribute(County; Customer.County){}
                fieldattribute(City; Customer.City){}
            }
        }
    }
}

Learn more about designing XMLports in XMLport overview.

Learn more about data consistency and validation against possible errors when using XMLports in the blog post Importing and exporting valid data using XMLports in Dynamics 365 Business Central.

Learn more about the use of namespaces in XMLports see Using namespaces with XMLports.

XMLport object
XMLport data type
Using namespaces with XMLports
XMLport triggers Request pages
XMLport overview