Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Advanced JSON Toolkit
One JSON package, 47 actions: parse, query, convert, transform, validate and redact. Exact number precision, correctly typed results, nothing to install.
Top Benefits
- 47 actions for parsing, querying, converting, transforming, validating, reshaping datasets and redacting PII, all on one
- Ask for an object, array, number or boolean and get a Dictionary, List, Table, Record, Number or Boolean straight back.
- Errors that tell you where to look. A bad payload gives you the line and column that broke it, not a silent success you
- Nothing to install and nothing to configure. No credentials, no vault lockers, no API account, no licence key, no networ
Tasks
- 47 actions, in the ten groups they appear under in the bot editor.
- Parse and validate (3) Validate JSON, Detect JSON Value Type, Get JSON Parse Error Detail
- Convert out of JSON (8) Dictionary to JSON, List to JSON, Table to JSON, JSON to CSV, JSON to XML, JSON to YAML, J
- Convert into JSON (6) CSV to JSON, CSV to Table, XML to JSON, NDJSON to List, Query String to JSON, Decode JWT (no
- Arrays and datasets (6) Filter Array, Sort Array, Group By and Aggregate, Deduplicate Array, Select Fields (pick o
- Transform (9) Apply JSON Merge Patch (RFC 7386), Apply JSON Patch (RFC 6902), JSON Diff, Deep Merge, Flatten (loss
- Privacy (1) Redact or Mask JSON, by masking, SHA-256 hashing or keeping the last N characters
Advanced JSON Toolkit is the one JSON package an Automation 360 developer needs. 47 actions across parsing, querying, conversion, transformation, schema validation, array and dataset operations, and PII redaction — all driven by one shared, thread-safe engine.
The 47 actions, by group:
Parse / Validate (3) — Validate JSON · Detect JSON Value Type · Get JSON Parse Error Detai
Query (5) — JSONPath Query (single) · JSONPath Query (multiple → List) · JSONPath Query to Table · JSON Pointer Get (RFC 6901) · Key / Path Exists
Convert In (4) — JSON → Dictionary · JSON → List · JSON → Table · JSON → Record
Convert Out (8) — Dictionary → JSON · List → JSON · Table → JSON · JSON → CSV · JSON → XML · JSON → YAML · JSON → NDJSON · JSON → Query String
Transform (9) — Apply JSON Merge Patch (RFC 7386) · Apply JSON Patch (RFC 6902) · JSON Diff (→ RFC 6902) · Deep Merge · Flatten (lossless) · Unflatten · Set Value at Path (immutable) · Remove Value at Path (immutable) · Sort JSON Keys
Schema (1) — Validate Against JSON Schema (structural subset)
Utility (4) — Pretty Print / Minify · Escape / Unescape JSON String · JSON Deep Equals · JSON Size / Count
Convert In — reverse (6) — CSV → JSON · CSV → Table · XML → JSON · NDJSON → List · Query String → JSON · Decode JWT (no verify)
Arrays / Datasets (6) — Filter Array · Sort Array · Group By + Aggregate · Deduplicate Array · Select Fields (pick / omit) · Rename Keys
Privacy (1) — Redact / Mask JSON (mask · SHA-256 hash · keep-last-N)