Inside Dynamics AX 4.0: The XML Structure

[Blog bot]

Источник: http://feeds.feedburner.com/~r/Insid...structure.html
==============

The primary goal for the Dynamics AX XML document feature was a reduction in implementation time for new XML documents. Because most systems integrating with Dynamics AX need mapping columns regardless of the schema, the product team decided to implement the Dynamics AX internal schema as the API. This way, only one mapping per integration endpoint is needed, and most Dynamics AX developers are already familiar with the internal schema.

It was clear that this should be expressed using AOT queries. The data sources for the AOT query directly associate with tables, and these tables carry fields which in the XML translate into properties. Benefiting from the extended data type definitions in the AOT, the XML schema definition (XSD) can be constrained using the available metadata describing data type, field sizes, and so on.

The widely adopted approach in the XML community regarding properties appearing in a fixed sort order in the documents is supported by the query structure, in which tables are addressed in the order of appearance in the query. The XML document framework automatically addresses the fields in alphabetical order; individual documents therefore require no manual development. Note that if the same table will be referenced in several nodes in the query, XML schema restrictions require that the name be unique. The table fields, when referenced in the XML, are referenced with their field names from the table, but the table names are the name under which they are identified on the query.

The limitations are that only one root table per query is allowed, and the unique entity key of an XML document can be associated with this root table. When constructing the queries, you should outer-join the child data sources to uphold 1:n relationships. If 1:1 relationships are to be enforced, you should choose an inner join.


In below image illustrates the mapping between the query in the AOT, which is referenced by the Axd class, and the XML document structure.

Correlation between the AOT query and the XML document structure

http://insidedynamicsax.blogspot.com/
</img> </img> </img> </img> </img>


Источник: http://feeds.feedburner.com/~r/Insid...structure.html