TotalApp Docs

JSON Transformer

Transform, filter, and reshape JSON data using a visual query builder or jq expressions.

Overview

JSON Transformer is a tool for reshaping and filtering JSON data without writing code. Paste or fetch JSON, then apply transformations using either the visual point-and-click builder or raw jq expressions. The output updates in real time as you build your transformation.

Input Methods

  • Paste — paste raw JSON into the input panel
  • URL Fetch — enter a REST endpoint URL; JSON Transformer fetches the response
  • File Upload — upload a .json file from your computer

Visual Builder

The visual builder lets you:

  • Select fields — check the fields you want to keep; uncheck to remove
  • Rename fields — click a field name to rename it in the output
  • Filter array items — add conditions (field = value, field > number, etc.)
  • Flatten nested objects — expand nested keys into flat fields

jq Mode

Switch to jq Mode to write raw jq expressions for maximum flexibility. Common jq examples:

  • .users[] | select(.active == true) | {id, name} — filter active users
  • [.items[].price] | add — sum all prices in an items array