Views:

Question:
How do I create an XPath expression to retrieve specific user information from an XML file containing user data, such as name, email, address, and active status?

Answer:
XPath expressions can be written to target each specific field within the <user> node. The following examples retrieve the information for the user with id="1".

Field
Variable
XPath Expression
Name
{{User1Name}}
//user[@id='1']/name
Email
{{User1Email}}
//user[@id='1']/email
Age
{{User1Age}}
//user[@id='1']/age
Street
{{User1Street}}
//user[@id='1']/address/street
City
{{User1City}}
//user[@id='1']/address/city
State
{{User1State}}
//user[@id='1']/address/state
Zipcode
{{User1Zipcode}}
//user[@id='1']/address/zipcode
Active Status
{{User1Active}}
//user[@id='1']/active


Explanation of XPath Structure:
• Double slashes (//) searches through the entire XML document.
• Expression user [@id="1"] identifies the user node with attribute id="1".
• The final segment (such as /name or /city) specifies the exact element to retrieve.

Example:
//user[@id='1']/address/city → Returns 'Springfield'.

To configure your Index files, please refer to the following steps:

  1. Enable the use of index files.
  2. Place your XML file in the sample Index File source path.
  3. Configure the index file type to XmlExtended. 
  4. Add your desired XPath expressions.



After clicking next, assign the meta data of the document of the values you input.


KBA applicable for both Cloud and On-premise Organizations.

This article is valid for DocuWare versions: 7.10, 7.11, 7.12, 7.13, 7.14, storageRobot, XPath Expressions, XML file

Related Articles (5)

Can StorageRobot use a single CSV file to update multiple documents? storageRobot - Configuring the error folder storageRobot - Convert XML dates via macro storageRobot - Separate barcodes, file properties and OCR values using line breaks or tabs storageRobot - XML index files and date format