JSONPathValue

this function allows you to query a web service response to find and return a single value based on the provided json path syntax jsonpathvalue(textvalue, path) enabled for for a description of the business object categories, see notes on "enabled for" docid\ u26v9fecfs6ilwa0 pvjd 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 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 except when this field appears on a form or is triggered by such a field parameters parameter description textvalue input json document path json path return value returns a single value based on the provided json path example $(jsonpathvalue('{ "store" { "book" \[ { "author" "nigel rees", "category" "reference", "price" 8 95 "title" "sayings of the century", }, { "author" "evelyn waugh", "category" "fiction", "price" 12 99 "title" "sword of honour", }, { "author" "herman melville", "category" "fiction", "isbn" "0 553 21311 3", "price" 8 99 "title" "moby dick", }, { "author" "j r r tolkien", "category" "fiction", "isbn" "0 395 19395 8", "price" 22 99 "title" "the lord of the rings", }, ] } }', "$ store book\[?(@ author= /melville$/)]")) returns { "author" "herman melville", "category" "fiction", "isbn" "0 553 21311 3", "price" 8 99, "title" "moby dick" }