jsonata

Query and transform JSON data using JSONata expressions.

3|Updated Dec 24, 2025
One-click install
npx skills add https://github.com/hairyf/damn-reports --skill jsonata
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: jsonata
Source: https://github.com/hairyf/damn-reports/tree/main/tauri/workspace/skills/jsonata
Command: npx skills add https://github.com/hairyf/damn-reports --skill jsonata

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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)'.

Frequently Asked Questions about jsonata

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query and extract specific data from nested JSON objects?

To query JSON data, you can use a path-based syntax to select specific data points from nested JSON objects and arrays. This approach allows you to extract targeted information efficiently without manual parsing.

What is the best way to transform JSON data into a different structure?

Transforming JSON data involves reshaping existing structures, aggregating values, and applying logic to generate new objects. You can map values like user activity logs into new keys and arrays for structured reporting.

Can I aggregate values and apply complex logic during JSON data manipulation?

Yes, JSON data manipulation supports aggregating values and applying complex logic. You can use built-in functions like '$sum' and variables to calculate totals and process semi-structured data declaratively.

How do I process API response payloads to generate structured reports?

Processing API responses involves using a declarative expression syntax to extract specific fields and reshape the semi-structured data. This enables you to wrangle API payloads directly into structured report formats.

Does this JSON transformation approach support variables and custom functions?

Yes, this JSON transformation approach supports advanced features including variables and custom functions. You can define declarative expressions to apply complex data manipulation logic dynamically.

When should I use a declarative query language for JSON parsing instead of manual extraction?

You should use a declarative query language for JSON parsing when dealing with large payloads or complex data wrangling. It simplifies extracting specific data points and reshaping structures compared to manual extraction.