Data Functions
List of data functions
PICK
RAW_VALUE
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") --> 11Keep the same type without auto-casting (RAW_VALUE)
For the given argument, it ignores auto-casting and the return value of the same type. In most cases, we want to call this function first, because the output of the function cell is automatically auto-casted, and this function prevents this behaviour.
Take 1 argument of any type
RAW_VALUE function examples:
Last updated
Was this helpful?

