For XML files, the syntax of Data Items can be as follows:
Static values
You can indicate that an Item should always evaluate to a specific value by prefixing that value with "0,"
EX: Item=0,static text
Dynamic values
You can also use the internal XPath expression evaluator to pull in data from the file dynamically.
Given the XML data:
<Orders>
<Order>
[...]
<Origin>
<Name>CXT Software</Name>
<Address>3030 N. Central Ave</Address>
<Suite>708</Suite>
<City>Phoenix</City>
<State>AZ</State>
<PostalCode>85012</PostalCode>
[...]
</Origin>
[...]
</Order>
[...]
</Orders>
You can pull in information by specifying the XML Node using XPath expressions.
EX:
OrderNode=/Orders/Order
OriginName=Origin/Name
OriginAddress=Origin/Address
OriginSuite=Origin/Suite
OriginCity=Origin/City
OriginState=Origin/State
OriginZip=Origin/PostalCode
Given the XML data:
<Orders>
<Order>
[...]
<Origin
Name="CXT Software"
Address="3030 N. Central Ave"
Suite="708"
City="Phoenix"
State="AZ"
PostalCode="85012" />
[...]
</Order>
[...]
</Orders>
You can pull in information by specifying the XML node using XPath expressions, separating the node from the property with the '$' character.
EX:
OrderNode=/Orders/Order
OriginName=Origin$Name
OriginAddress=Origin$Address
OriginSuite=Origin$Suite
OriginCity=Origin$City
OriginState=Origin$State
OriginZip=Origin$PostalCode
Given the XML data:
<Orders>
<Order>
[...]
<comment type="origin">Room 200B</comment>
<comment type="destination">Leave with front desk</comment>
[...]
</Order>
[...]
</Orders>
You can use a conditional XPath expression.
EX:
OrderNode=/Orders/Order
OriginComments=comment[@type="origin"]
DestComments=comment[@type="destination"]
Given the XML data:
<Orders>
<Order>
<TrackingInfo>
<RouteID>WW314159</RouteID>
<StopID>Z112358</StopID>
</TrackingInfo>
</Order>
</Orders>
XML fields may also be concatenated by separating the values with a comma. If one or more XPath expressions need to be combined with static data, surround the static data with quotes.
EX:
OrderNode=/Orders/Order
Reference1="RouteID: ",TrackingInfo/RouteID,"; StopID: ",TrackingInfo/StopID