Example of an XPath
For an API call returning content of type application/xml, this sample could be part of the reply:
<?xml version="1.0"?>
<SalesOrder>
<SalesOrderHeader>
<CustomerParty>
<PartyIDs>
<ID
accountingEntity="customer180"
lid="lid://infor.app.nldv1180">RGT000043</ID>
</PartyIDs>
<Name>Purchasing Business Partner</Name>
<Location type="Office">
<Address>
<AttentionOfName>Millers & Co.</AttentionOfName>
<AddressLine sequence="1">De Dam 1</AddressLine>
<AddressLine sequence="2"/>
<CityName>Amsterdam</CityName>
<CountrySubDivisionCode>NH</CountrySubDivisionCode>
<CountryCode>NL</CountryCode>
<PostalCode>1001 BA</PostalCode>
</Address>
</Location>
<Location type="Billing">
<ID
accountingEntity="customer180"
lid="lid://infor.app.nldv1180">D_RGSLS1</ID>
<Name>Regional Office</Name>
</Location>
</CustomerParty>
</SalesOrderHeader>
</SalesOrder>
To retrieve the city name where the customer’s office is located, you can use
an XPath expression with a filter on the Location
attribute
@type
:
SalesOrder/SalesOrderHeader/CustomerParty/Location[@type=”Office”]/Address/CityName
The resulting value in this case is "Amsterdam
".
Note: The XPaths are run in the default
namespace of the XML document. If there are explicit namespace prefixes used in the tag
names, you can use standard XPath syntax to find the right value.