Create Field Parser of type PATH

33 6 December 2023

Use PATH type field parser to extract value from XML (or HTML) content or email’s HTML content.

For example, use this when need to extract value from table within email body

Field Parser for PATH:

Let’s move on to the Field Parsers section.

  • Click on ‘New‘ to create a new Field Parser.
  • Then Select Output Type as ‘Text’ and enter the ‘Reference Name’ as ‘Name and then select Type as ‘Path’.
  • Afterwards select Source as ‘HTML Body’ and click on ‘Save’ button.
  • Click on the created Field Parser to open the record layout.
  • Click on the ‘Build’ button on the top right corner.
  • When user selects Source as a ‘HTML Body’.
  • Afterwards Put the Regex in the Value field ‘html/head/body/h2’.
  • Choose the correct option from the ‘Multiple Results Configurations‘ and select its value as ‘First’.
  • Write a sample text in the Text Area and click on ‘Test‘ to check the functionality.
  • Click on ‘Save‘. 

Field Parser of Type Path can Extract Data in Deep Mode

Extracting tabular data from email can be tricky. Field parser of type Path can help easily retrieve data using XPath based mechanism, to identify all table nodes to extract information from incoming email. However, as emails being sent from different clients can internally generate varying levels of HTML content, making it tricky to consistently extract data from tables within email content. 

With this new feature, users can enable deep mode data extraction. This allows users to provide a top-level path for node. System will automatically extract all values it can find under this node and its child nodes. To simplify, let’s say you have a table with each row representing a payment transaction. There are two ways to extract information from this table. 

Sample Email 

Example 1 – Extract each cell as separate value 

Within Field Parser build mode, set path to html/body/table/tbody/tr/td  

Note: path value provided was used while testing. It can change for your specific email 

Example 2 – Extract each cell as single value separated by double colons (::) 

Within Field Parser build mode, set path to html/body/table/tbody/tr 

Note: path value provided was used while testing. It can change for your specific email