Data Event Wizard - XML Mapping Properties

Data Location	What it is	How to use it
Outer	Enables the user to select the outer XML from the incoming source data field	Click on the drop down and select this option from the list. The selection applies to the source or incoming XML. Selecting this option will the take the entire XML structure, i.e. the root node, child nodes and the values contained therein.
Inner	Enables the user to select the inner XML from the incoming source data field	Click on the drop down and select this option from the list. The selection applies to the source or incoming XML. Click on the drop down and select this option from the list. Selecting this option will ignore the outer XML taking returning only the inner XML structure.
Value	Disregards the XML data structure and selects the Value within the field	Click on the drop down and select this option from the list. This selection enables the developer to return from the incoming XML structure the value held by the XML structure as opposed to the data and the structure that holds it.
Destination
Outer	Enables the user to select the outer XML from the incoming source data field	Click on the drop down and select this option from the list. The selection applies to the destination or location to where the Data Wizard will write the XML data. Selecting this option will the take the entire XML structure, i.e. the root node, child nodes and the values contained therein and write it to the destination provided by the user.
Inner	Enables the user to select the inner XML from the incoming source data field	Click on the drop down and select this option from the list. The selection applies to the destination or location to where the Data Wizard will write the XML data. Selecting this option will ignore the outer XML taking writing only the inner XML structure to the destination.
Value	Writes the XML data value to an existing field within the XML data structure	Click on the drop down and select this option from the list. This selection enables the developer to write to a destination XML structure the value to be held by the XML structure as opposed to the data and the structure that holds it.

Mapping Node Behavior

These define how the combinations of mappings are performed in the ‘Line Properties’ window.

Destination -> Source V	Inner XML	Outer XML	Value
Element to Element
Inner XML	Direct Set	Copy children of source to parent of destination, then delete original destination	Direct Set (Inner Text)
Outer XML Value	Direct Set	Direct Set	Direct Set (Inner Text)
Outer XML Value	Direct Set (Inner Text)	Direct Set (Inner Text)	Direct Set (Inner Text)
Attribute to Attribute
Inner XML	Not Possible	Not Possible	Not Possible
Outer XML Value	Not Possible	Not Possible	Not Possible
Outer XML Value	Not Possible	Not Possible	Direct Set
Element to Attribute
Inner XML	Not Possible	Not Possible	Direct Set
Outer XML Value	Not Possible	Not Possible	Direct Set
Outer XML Value	Not Possible	Not Possible	Direct Set
Attribute to Element
Inner XML	Not Possible	Not Possible	Not Possible
Outer XML Value	Not Possible	Not Possible	Not Possible
Outer XML Value	Direct Set	Direct Set	Direct Set (Inner Text)

XML Example

The following diagram explains how the scopes work. The element scopes are in relation to the “customer” element and the attribute scopes are in relation to the “regionid” attribute.

Scope	Element	Attribute
Inner XML	<firstName>Frank</firstName> <lastName>Jones</lastName>	Not Valid
Outer XML	<customer regionid="100"> <firstName>Frank</firstName> <lastName>Jones</lastName> </customer>	Not Valid
Value	Frank Jones	100

The element value is therefore the concatenated text (without the XML tags) that the element contains. In the following example, the value of the element would be “FrankJones”. This is because there is no whitespace between the “firstName” and “lastName” elements.

XML Example	Copy Code
<customer><firstName>Frank</firstName><lastName>Jones</lastName></customer>

The W3C XML Specification draws a distinction between “Inner Text” and “Value”. The two were combined into “Value” in the Data Event Wizard because “Inner Text” cannot be used on an attribute, and “Value” cannot be used on an element.

Reference - Troubleshooting

InfoPath - Invalid date error in Data Event wizard