Basic Transformation Options

array transformation flatten flatten an array containing potentially nested arrays to a single array example $arrayflatten(\[1, 2, \[3, 4]]) => \[1, 2, 3, 4] pluckby extract the values of a property or deeply nested property of the objects within an array of objects example $arraypluckby(\[{ “color” “brown”, “type” “dog” },{ “color” “beige”, “type” “cat” }],”type”) => \[“dog”,”cat”] sort sort the items of an array of strings or numbers by value example $arraysort(\[3, 4, 1], “desc”) => \[4, 3, 1] sortby sort the items of an array of objects by the value of a plucked property of the objects within the array example $arraysortby( \[{ “user” { “name” “foo” } }, { “user” { “name” ”bar” } }, { “user” { “name” “around” } }], “user name”, “asc” ) => \[{ “user” { “name” “around” } }, { “user” { “name” “bar” } }, { “user” { “name” “foo” } }] countif count all items of an array that are equal to a specific value example $arraycountif(\[43, 43, 41, 100], 43) => 2 countifby count all items of an array of objects that contain a plucked property equal to a specific value example $arraycountifby( &#x9;\[{ "lastname" "doe" }, { "lastname" "test" }, { "lastname" "doe" }], &#x9;"lastname", &#x9;"doe" ) => 2 sum sum the values of an array of numbers example $arraysum(\[10, 30, 40]) => 80 sumby sum the values of a plucked property of the objects within an array of objects example $arraysumby(\[{ “age” 10 }, { “age” 30 }, { “age” 40 }], “age”) => 80 avg average the values of an array of numbers example $arrayavg(\[10, 30, 40]) => 26 6666 avgby average the values of a plucked property of the objects within an array of objects example $arrayavgby(\[{ “age” 10 }, { “age” 30 }, { “age” 40 }], “age”) => 26 6666 min find the minimum value in an array of numbers example $arraymin(10, 30, 40]) => 10 minby find the minimum value of a plucked property of the objects within an array of objects example $arrayminby(\[{ “age” 10 }, { “age” 30 }, { “age” 40 }], “age”) => 10 max find the maximum value in an array of numbers example $arraymax(\[10, 30, 40]) => 40 maxby find the maximum value of a plucked property of the objects within an array of objects example $arraymaxby(\[{ “age” 10 }, { “age” 30 }, { “age” 40 }], “age”) => 40 filter filter an array to the values that match a regular expression, a specific value, or non null value example $arrayfilter(\[1, 2, 3, 4, 5, 3], 3) => \[3, 3] filterby filter an array of objects to those that contain a property or deeply nested property whose values match a regular expression, a specific value, or non null value example $arrayfilterby(\[{ “age” 10 }, { “age” 30 }, { “age” 40 }], “age”, 10) => \[{ “age” 10 }] numeric transformations round adjust a number rounding or flooring it example $numericround(123 6, 0) => 124 floor adjust a number flooring it example $numericfloor(1234, 1) => 1230 ceil adjust a number ceiling it example $numericceil(1234, 1) => 1240 absolute value compute the absolute value of a number example $numericabs( 1) => 1 less than check if the first number is less than the second example $numericlessthan(2, 7) => true less than or equal check if the first number is less than or equal to the second example $numericlessthanorequal(20, 7) => false greater than check if the first number is greater than the second example $numericgreaterthan(2, 7) => false greater than or equal check if the first number is greater than or equal to the second example $numericgreaterthanorequal(7, 7) => true random generate a random number between inclusive lower and upper bounds example $numericrandombasic(1, 10, “no”) => 3 object transformations remove remove a property on an object example $objectremove({ “name” “john” }, “name”) => {} is equal perform a deep comparison between two values to determine if they are equivalent example $objectisequal({ “age” 30, “name” “joe” }, { “age” 30, “name” “joe” }) => true has by check if an object contains a property or deeply nested property example $objecthasby({ "key" 1 }, "key") => true pick create an object composed of the picked properties example $objectpick({ “person” { “name” “joe” }, “age” 30 }, “age”) => { “age” 30 } pluck by extract the value of a property or deeply nested property of an object example $objectpluckby({ “person” { “name” “joe” }, “age” 30 }, “person name”) => “joe” string transformations strip remove all whitespace (tabs, spaces, and newlines) from both the left and right side of text spaces in between words will not be removed example $stringstrip(“ hello word ”) => “hello word” uuid v4 generate a v4 universally unique identifier (uuid) example $stringuuidv4() => “be407787 14e1 47d1 9b25 9eaa624f7a5f” hash compute that hash of a value example $stringhash(“data”, “md5”) => “8d777f385d3dfec8815d20f7496026dc” pad pad a string on the left and right sides if it's shorter than length padding characters are truncated if they can't be evenly divided by length example $stringpad("abc", 8) => “ abc “ pad start pad a string on the left side if it's shorter than length padding characters are truncated if they can't be evenly divided by length example $stringpadstart(“abc”, 5,”h”) => “hhabc” pad end pad a string on the right side if it's shorter than length padding characters are truncated if they can't be evenly divided by length example $stringpadend("abc", 5,"h") => "abchh" repeat repeat a string n times example $stringrepeat(“abc”, 2) => “abcabc” camel case convert a string to camel case example $stringcamelcase(“hello world”) => “helloworld” capitalize convert the first character of a string to upper case and the remaining to lower case example $stringcapitalize("hello world") => "hello world" starts with check if a string starts with another example $stringstartswith(“abc”, “a”) => true ends with check if a string ends with another example $stringendswith(“abc”, “c”) => true eval expression parse and evaluate a string containing literal json or a jsonata expression example $stringevalexpression(“\[1,$string(number),3]”, { “number” 2 }) => \[1,”2”, 3] value transformations is array check if value is an array example $valueisarray(\[1, 4, 4]) => true is string check if value is a string example $valueisstring(“data”) => true is null or undefined check if value is null or undefined example $valueisnullorundefined(null) => true is object check if a value is an object example $valueisobject({}) => true from xml parse an xml string example $valuefromxml(“\<a/>”) => {“a” {}} from yaml parse a yaml string example $valuefromyaml( “version 1 0 0\ndependencies \n yaml ^1 10 0\npackage \n exclude \n idea/ \n gitignore\n” ) => { “version” “1 0 0”, “dependencies” { “yaml” “^1 10 0”}, “package” {“exclude” \[“ idea/ ”, “ gitignore”]}} from csv parse a csv string example $valuefromcsv(“eruid,description\nbatman,uses technology\nsuperman,flies through the air”) => \[ { “description” “uses technology”, “eruid” “batman” }, { “description” “flies through the air', “eruid” “superman” } ] to xml serialize a value to xml example $valuetoxml({ “a” {} }) => “\<a/>” to yaml serialize a value to yaml example $valuetoyaml({ “version” “1 0 0”, “dependencies” { “yaml” “^1 10 0” }, “package” { “exclude” \[“ idea/ ”, “ gitignore”] } }) => “version 1 0 0\ndependencies \n yaml ^1 10 0\npackage \n exclude \n idea/ \n gitignore\n” to csv serialize a value to csv example $valuetocsv(\[ { “eruid” “batman”, “description” “uses technology” }, { “eruid” “superman”, “description” “flies through the air” } ]) => “eruid,description\nbatman,uses technology\nsuperman,flies through the air\n”