Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Version: Available or changed with runtime version 1.0.
Sets the data that is being imported or exported as XML data types or as the standard AL data types.
Applies to
- Xml Port
Property value
| Value | Available or changed with | Description |
|---|---|---|
| Legacy | runtime version 1.0 | The data uses the standard AL data types. |
| Xml | runtime version 1.0 | The data uses the standard XML data types. |
Syntax
FormatEvaluate = XML;
Remarks
Importing
If the XML document that you want to import contains data that corresponds to the standard AL data types, use AL Format/Evaluate (default value). The data is then evaluated before being inserted into the database.
If the XML document that you want to import contains data that uses the standard XML data types, use the XML Format/Evaluate setting. This ensures that the data is evaluated and converted to the AL data types before being inserted into the database.
If the data that you want to import does not follow either the Standard AL formats or the XML formats, import the data into a temporary table in text format. You can then use AL code to convert the data before inserting it into the database.
Exporting
If you want to export data that uses the standard AL data types to an XML document and use these data types in the XML document, use AL Format/Evaluate (default value). The data from the database is then formatted according to the standard rules for AL data types.
If you want to export data in the standard XML formats to an XML document, use the XML Format/Evaluate setting. This ensures that the data you export from the database is formatted and exported in the standard XML formats.
The following XML Data types require evaluation.
| XML Data Type | Dynamics 365 Business Central Data Type |
|---|---|
| Decimal Float Double |
Decimal |
| Boolean | Boolean |
| Datetime | DateTime |
| Time | Time |
| Date | Date |
| Integer | Integer |
| Duration | Duration |
This is an XMLport property and therefore applies to all the data that is being streamed. It cannot be applied only to specific fields.
For more information about formatting AL data types, see Formatting Values, Dates, and Time. For more information about evaluating variables, see EVALUATE Method. For more information about using temporary tables, see UseTemporary Property (XMLport).
Related information
Format Property (XMLports)
Evaluate Method
UseTemporary Property (XMLport)