General Functions
General functions support common checks and utility operations.
| Function | Description | Examples |
|---|---|---|
| IS_EMPTY | Check if value is empty | IS_EMPTY("") → true IS_EMPTY([]) → true IS_EMPTY({}) → true IS_EMPTY(NULL) → true IS_EMPTY(0) → false IS_EMPTY(" ") → false IS_EMPTY(FALSE) → false |
| LEN | Length of text or array | LEN("hello") → 5 LEN("") → 0LEN([1, 2, 3]) → 3 |
| GET | Returns the value at path of an object or array. Use dot notation for nested access. Array indices start at 1. | GET({"name": "John"}, "name") -> "John" GET([10, 20, 30], "1") -> 10 GET({"user": {"name": "Jane"}}, "user.name") -> "Jane" |
| TO_BOOLEAN | Convert a value to a boolean | TO_BOOLEAN("true") → TRUE TO_BOOLEAN("false") → FALSE TO_BOOLEAN(1) → TRUE TO_BOOLEAN(0) → FALSE TO_BOOLEAN("") → FALSE |
| TO_NUMBER | Convert a value to a number | TO_NUMBER("42") → 42 TO_NUMBER(TRUE) → 1 TO_NUMBER(FALSE) → 0 TO_NUMBER(NULL) → 0 |
| TO_TEXT | Convert a value to text | TO_TEXT(42) → "42" TO_TEXT(TRUE) → "TRUE" TO_TEXT(NULL) → "" |
