XPathValue

Returns a value based on the provided XPath.

Only version 1.0 of XPath is supported.

Syntax

XPathValue(xmlValue, path)

Enabled For

For a description of the business object categories, see Notes on "Enabled For".

Business Object Category Yes/No
Business Rules: Before-Save Rules Yes
Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load) Yes1
Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load) Yes
Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load) Yes1
Business Rules: Editing Rules Yes2
Business Rules: Initialization Rules Yes
Business Rules: Read Only Rules No
Business Rules: Required Rules Yes2
Business Rules: Validation Rules Yes
Client Expressions No
Object Permissions No
Services No
LDAP No
Mobile No
Quick Actions (except UI Quick Actions) Yes
UI Quick Actions No
Reports Yes
Search/Dashboard without field references No
Search/Dashboard with field references No

1. Not fully supported in calculation rules that have a condition of After Save or the Also Recalculate on Load option selected. It may fail if the rule's field is used in a grid, form, or saved search.

2. Except when this field appears on a form or is triggered by such a field.

Parameters

Parameter Description
xmlValue XML input string

path

XML element path

Return Value

Returns a value based on the provided XPath.

Examples

$(XPathValue('<catalog><book id="B1001"><in_stock>True</in_stock><title>The Rest API</title><price>3.50</price></book><book id="B1002"><in_stock>False</in_stock><title>XML Modifiers and You</title><price><priceUS>48.95</priceUS><priceUK>48.96</priceUK></price></book></catalog>', '//book[2]/price'))

Returns this value: <priceUS>48.95</priceUS><priceUK>48.96</priceUK>