Introduction to JSONata

A short introduction to JSONata using the JSONata Exerciser.

Transcript

1. Introduction to JSONata A JSON Query and Transformation Language
2. • Lightweight JSON query language • Inspired by XPath & XQuery • XPath is a query language for selecting nodes from an XML document • XQuery is a query and functional programming language that queries and transforms collections of structured XML data. • Query expressions with minimal syntax and built in operators to manipulate and combine data • Allows user defined functions
3. • Supported by IBM and used in Node-RED* as the default JSON query engine. * Node-RED is a flow-based visual programming environment that one can write code to use APIs, hardware devices, online services and easily wire them together.
4. Demo (Using JSONata Exerciser)
5. Account.Order{ "orders": $.{ "id": OrderID, "products": Product.{ "name": $."Product Name", "price": $.Price, "quantity": $.Quantity } }, "totalOrders": $count(OrderID), "totalCost": $sum(Product.(Price*Quantity)) } Sample JSONata Query