Question 1

What is JSONata?

Accepted Answer

JSONata is a lightweight query and transformation language for JSON data. It allows you to extract, filter, and reshape JSON using expressive path expressions, operators, and built-in functions — similar to XPath for XML.

Question 2

How do I select a nested field with JSONata?

Accepted Answer

Use dot notation to navigate nested objects. For example, "Account.Name" selects the Name field inside the Account object. To select across an array of objects, simply chain the path: "Orders.Product.Price" returns all prices from every product in every order.

Question 3

Can JSONata filter and transform arrays?

Accepted Answer

Yes. Use square-bracket predicates to filter: "Products[Price > 50]" returns only products with a price above 50. Use the curly-brace syntax to reshape data: "items.{ \"id\": SKU, \"cost\": Price }" maps each item to a new object shape.

Question 4

What built-in functions does JSONata support?

Accepted Answer

JSONata includes over 70 built-in functions covering strings ($string, $uppercase, $join), numbers ($sum, $round, $abs), arrays ($count, $sort, $distinct), objects ($keys, $merge), and more. You can also define your own functions using the $lambda syntax.

ilmaiset web-kehittäjän työkalut

JSONata Expression Tester