Skip to main content
The JSON Tools connector provides operations for parsing, querying with JSONPath, and transforming JSON data within your workflows.
No connection required; this utility connector works out of the box.

Tools

Parse a JSON string into a structured object.
json
string
required
JSON string to parse.
Example request:
Example response:
Serialize data to a JSON string.
data
any
required
Data to serialize.
pretty
boolean
default:"true"
Pretty-print with indentation.
indent
number
default:"2"
Number of indentation spaces.
encoding
enum
default:"utf8"
Output encoding for the result field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
Example response:
Extract data using JSONPath expressions.
data
any
required
JSON data to query.
path
string
required
JSONPath expression (e.g., $.store.book[*].author).
Example request:
Example response:
Convert nested objects to flat dot-notation keys.
data
any
required
JSON data to flatten.
delimiter
string
default:"."
Key separator.
safe
boolean
default:"false"
Preserve arrays instead of flattening them.
Example request:
Example response:
Convert flat dot-notation keys back to nested objects.
data
any
required
Flattened data.
delimiter
string
default:"."
Key separator.
Example request:
Example response:
Deep merge multiple objects together.
objects
any[]
required
Array of objects to merge.
Example request:
Example response:
Find differences between two JSON objects.
obj1
any
required
First object.
obj2
any
required
Second object.
Example request:
Example response:
Extract selected keys from an object.
data
any
required
Source object.
keys
string[]
required
Keys to pick.
Example request:
Example response:
Remove selected keys from an object.
data
any
required
Source object.
keys
string[]
required
Keys to remove.
Example request:
Example response:
Retrieve a value using dot-notation path.
data
any
required
Source object.
path
string
required
Dot-notation path (e.g., user.address.city).
defaultValue
any
Default value if path not found.
Example request:
Example response:
Set a value at a dot-notation path.
data
any
required
Source object.
path
string
required
Dot-notation path.
value
any
required
Value to set.
Example request:
Example response:
Remove all whitespace from a JSON string.
json
string
required
JSON string to minify.
encoding
enum
default:"utf8"
Output encoding for the result field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
Example response:
Format a JSON string with indentation.
json
string
required
JSON string to format.
indent
number
default:"2"
Number of indentation spaces.
encoding
enum
default:"utf8"
Output encoding for the result field: utf8 (default) or base64 (for email attachments, SFTP uploads, or knowledge-base embedding). The response includes an encoding tag.
Example request:
Example response:
Extract all keys from an object.
data
any
required
Source object.
deep
boolean
default:"false"
Include nested keys with dot-notation.
Example request:
Example response:
Extract all values from an object.
data
any
required
Source object.
Example request:
Example response:
Check if a string is valid JSON.
json
string
required
String to validate.
Example request:
Example response: