Utilities Reference

Forge Json includes 23 built-in utilities organized by category. Each utility can be used as a pipeline step or executed independently via the API.

Visit the Store for interactive examples, detailed configuration options, and user reviews for each utility.

Convert

Utility	Description
CSV to JSON (`convert.csv-to-json`)	Parse a CSV string into a JSON array of objects. Supports custom delimiters, header row detection, and type inference.
JSON to CSV (`convert.json-to-csv`)	Convert a JSON array of objects to CSV format. Supports column selection, custom delimiters, and expression-based column mappings.
Find & Replace (`structure.find-replace`)	Search and replace across keys and values. Supports regex, case sensitivity, and expression-based replacements.

Utility	Description
Add Localization (`convert.add-localization`)	Add translation keys/values to a JSON document for internationalization workflows.

Utility	Description
Deep Merge (`merge.deep-merge`)	Recursively merge two JSON documents. Configurable merge strategy (deep, shallow) and array handling (concat, replace, union). Requires two inputs.

Utility	Description
Flatten / Nest (`structure.flatten-nest`)	Convert between flat key-value pairs and nested objects. Configurable delimiter (`.`, `/`, `_`) and max depth.
Restructure (`structure.restructure`)	Group by key, sort, unwind arrays, or transpose objects.
Pick Fields (`structure.pick-fields`)	Keep only specified field paths, removing everything else.
Remove Fields (`structure.remove-fields`)	Remove fields by path, key name, regex pattern, or value match.
Copy / Move (`structure.copy-move`)	Copy, move, or swap fields within objects.

Utility	Description
Normalize (`schema.normalize`)	Ensure consistent structure across array items — fill missing fields, remove extras, sort keys.
Clean JSON (`schema.clean-json`)	Value-based cleanup: remove nulls, empty strings, trim whitespace, deduplicate arrays, sort keys.
Truncate (`schema.truncate`)	Reduce document size: limit string lengths, array lengths, remove large blobs.
Compute Fields (`schema.compute`)	Create derived fields from template expressions. See Usage Contexts — Compute for expression limitations.

Utility	Description
Aggregate (`analysis.aggregate`)	Calculate statistics on arrays: count, sum, average, min, max, unique values, flatten nested arrays.
Summarize (`analysis.summarize`)	Generate summary statistics, collapse nested structures, or detect anomalies in data.
Diff (`analysis.diff`)	Compare two JSON documents. Modes: changed-only, added-only, removed-only, full-annotated. Requires two inputs.

Utility	Description
Format Values (`cleanup.format-values`)	Transform value formats: uppercase, lowercase, capitalize, trim, toString, toNumber, slugify, and more.
Redact (`cleanup.redact`)	Mask sensitive data matching patterns (email, phone, SSN, etc.). Mask styles: full, partial, hash.
Map Values (`cleanup.map-values`)	Replace values using a lookup table. Configure what happens to unmatched values: keep, remove, or use a default.

Utility	Description
Generate Mock Data (`generate.generate-mock-data`)	Generate realistic fake data from a schema template. Supports names, emails, addresses, dates, numbers, and custom patterns.
Filter (`generate.filter`)	Filter array items using key, value, or JavaScript expressions.

Each utility declares what types of JSON it can work with:

Property	Description
Root types	What the root JSON must be (object, array, string, etc.)
Target types	What types within the document are affected
Destructive	Whether the utility removes data (true/false)
Reversible	Whether the transformation can be undone (true/false)

These are shown as badges on each utility’s Store page.