JSONPathArray
Returns a JSON string describing an array of values based on the provided JSON path.
Syntax
JSONPathArray(textValue, 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 |
|---|---|
| textValue | Input JSON document |
|
path |
JSON path |
Return Value
Returns a JSON string with replaced values.
Example
$(JSONPathArray('{"store":{"book":[{"category":"reference","author":"Nigel Rees","title":"Sayings of the Century","price":8.95},{"category":"fiction","author":"Evelyn Waugh","title":"Sword of Honour","price":12.99},{"category":"fiction","author":"Herman Melville","title":"Moby Dick","isbn":"0-553-21311-3","price":8.99},{"category":"fiction","author":"J. R. R. Tolkien","title":"The Lord of the Rings","isbn":"0-395-19395-8","price":22.99}],"bicycle":{"color":"red","price":19.95,"used":"True","returnDate":"2012-04-23T18:25:43.5111Z"}}}', "$.store.bicycle"))
Returns this array value:
[{"color":"red","price":19.95,"used":"True","returnDate":"2012-04-23T18:25:43.5111Z"}]