jsonata

What problem does it solve?

This Skill simplifies the complex task of querying and transforming JSON data, enabling users to extract specific information or reshape data structures efficiently.

Core Features & Use Cases

• JSON Querying: Select specific data points from nested JSON objects and arrays using a powerful path-based syntax.
• Data Transformation: Reshape JSON data into different structures, aggregate values, and apply complex logic.
• Use Case: You have a large JSON payload representing user activity logs. Use this Skill to extract all user IDs and their corresponding timestamps, then transform this data into a new JSON object where each key is a user ID and the value is an array of their activity timestamps.

Quick Start

Use the jsonata skill to transform the provided JSON data using the expression '$sum(data.value)'.