Version: 17.06 +
Type: all types
The formula 'ReadXPathScalar' evaluates an XPathExpression.
The XmlNode for which the XPath query is evaluated XPathExpression:
The XPath expression to evaluate ReturnDefaultIfEmpty:
If set to true, the formula will return the default value if the node is empty. This parameter is available from version 18.08+; in previous versions, this value was false by default ReturnDefaultIfAbsent:
If set to true, the formula will return the default value if no node is found. This parameter is available from version 18.08+; in previous versions, this value was false by default
The formula gives the same result as you would get from an XmlField that is placed under the same XmlNode as you use as the parameter. This formula will always throw an error if the result is a table. If you want a table as a result, you can use an XPathExpression that returns a table. By doing that that you can create XPathExpressions that return a dynamic number of items based on input formulas. It is also possible to use ReadXPathVector (18.08+).