Data Functions
List of data functions
PICK
Pick a value from an array or object (PICK)
Given an array or object and a JSON path to certain value inside it, the PICK function picks this value and returns it.
Takes 2 arguments, the array / object and the path.
The first argument must be a variable or another function returning the object or array.
The second argument must be a string specifying JSON path to the desired string values.
PICK function examples:
input1 = {"order":{"code":"A"}}
input2 = ["A", "B", "C"]
input3 = { "order": [ {"code":"A2", "price":22}, {"code":"B3", "price":11} ] }
[function] --> [output]
PICK({input1}, "order.code") --> "A"
PICK({input2}, "[2]") --> "C"
PICK({input3}, "order[0].code") --> "A2"
PICK({input3}, "order[1].price") --> 11
Last updated
Was this helpful?