Query XML

The 'Selector' property defines the XPATH expression used to select nodes from the XML document for extraction. This is the primary mechanism for targeting specific elements, attributes, or text nodes in structured XML.

• The selector determines the scope of extraction. If no nodes match, no values are returned.
• XPATH supports a wide range of queries, including absolute, relative, and conditional expressions.
• For best results, test your selector using sample XML and review the nodes returned.

Examples:

1. Select all invoice numbers: Matches all <InvoiceNumber> elements under <Invoice> nodes.

2. Select customer names with a specific attribute: Matches <Name> elements under <Customer type="VIP">.

3. Select all items in a list: Matches all <Item> elements under <Items> in an <Order>.

Learn more about XPATH syntax

Can be one of the following types:

The 'Filter Pattern' property allows you to restrict which nodes are included in the output by matching their text content against a regular expression. This is useful for excluding unwanted values, enforcing formats, or extracting only relevant data.

• The filter is applied before any parsing pattern.
• If left blank, all nodes matched by the Selector are included.
• Use .NET regular expression syntax.

Examples:

1. Only include five-digit numbers: Matches text like 12345, excludes 1234A or 123456.

2. Only include names starting with 'A': Matches Alice, Andrew, excludes Bob.

3. Only include dates in YYYY-MM-DD format: Matches 2024-06-01, excludes 06/01/2024.

Regular expression help

The 'Attribute Name' property allows you to extract the value of a specific attribute from each selected node, rather than the node's inner text. This is useful when the desired data is stored as an attribute.

• Enter the attribute name (e.g., id, type, code) to extract its value.
• If left blank, the extractor will return the inner text of the node.
• If the attribute does not exist on a node, that node will return no value.

Examples:

1. Extract the 'id' attribute from <Customer id="C123">:

   • Attribute Name: id
   • Result: C123

2. Extract the 'status' attribute from <Order status="Shipped">:

   • Attribute Name: status
   • Result: Shipped

3. Extract the 'code' attribute from <Product code="A100">:

   • Attribute Name: code
   • Result: A100

Can be one of the following types:

The 'Parsing Pattern' property enables advanced extraction by applying a regular expression to the value extracted from each node (after filtering, if a Filter Pattern is set). Each match found by the regular expression will be returned as a separate extracted value.

• Use this property to extract specific parts of a value, such as numbers, codes, or dates within a larger string.
• If left blank, the entire value from each node is returned as-is.
• Supports named groups for targeted extraction.

Examples:

1. Extract all numbers from a value: Input: Order 123, Item 456 Output: 123, 456

2. Extract words from a name: Input: John Steven Doe Output: John, Steven, Doe

3. Extract a date in the format YYYY-MM-DD: Input: Invoice Date: 2024-06-01 Output: 2024-06-01

Regular expression help