GET

Retrieves a value from an object using a key or dot-notation path. Use GET to safely access nested data without errors when keys are missing.

Syntax

GET(object, path)

Parameters:

• object (Object) – The object to retrieve data from

• path (String) – Key or dot-separated path like "user.name" or "address.city"

Returns: The value at the path, or NULL if not found.

Aliases: GETVALUE, ACCESS, EXTRACT

Examples

Basic retrieval

data = OBJECT("user", OBJECT("name", "Alice", "age", 30))

GET(data, "user.name")  // "Alice"
GET(data, "user.age")   // 30
GET(data, "user.email") // NULL (doesn't exist)

Customer region lookup

GET(customer_profile, "account.location.region")

Returns "Europe" or NULL if the path doesn't exist. Prevents formula errors when optional data is missing.

Configuration settings

GET(settings, "notifications.email.enabled")

Safely check if email notifications are enabled without breaking when settings aren't configured.

Dynamic pricing

GET(OBJECT("plan", OBJECT("price", 49)), "plan.price")

Extract pricing values for calculators or conditional logic.

Tips

• Dot notation works for nested objects but not arrays

• For dynamic paths, use string concatenation: GET(config, CONCAT("user.", user_id))

• Use KEYS() to explore which fields are available in an object

Tests

GET(OBJECT("a", 1, "b", 2), "a") == 1
// true

GET(OBJECT("user", OBJECT("name", "Bob")), "user.name") == "Bob"
// true

GET(OBJECT("settings", OBJECT("dark_mode", true)), "settings.dark_mode") == true
// true

GET(OBJECT("x", 10), "y") == NULL
// true

See also

OBJECT · KEYS · TOJSON · ISOBJECT