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.
string
required
JSON string to parse.
Example request:
Example response:
Serialize data to a JSON string.
any
required
Data to serialize.
boolean
default:"true"
Pretty-print with indentation.
number
default:"2"
Number of indentation spaces.
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.
any
required
JSON data to query.
string
required
JSONPath expression (e.g., $.store.book[*].author).
Example request:
Example response:
Convert nested objects to flat dot-notation keys.
any
required
JSON data to flatten.
string
default:"."
Key separator.
boolean
default:"false"
Preserve arrays instead of flattening them.
Example request:
Example response:
Convert flat dot-notation keys back to nested objects.
any
required
Flattened data.
string
default:"."
Key separator.
Example request:
Example response:
Deep merge multiple objects together.
any[]
required
Array of objects to merge.
Example request:
Example response:
Find differences between two JSON objects.
any
required
First object.
any
required
Second object.
Example request:
Example response:
Extract selected keys from an object.
any
required
Source object.
string[]
required
Keys to pick.
Example request:
Example response:
Remove selected keys from an object.
any
required
Source object.
string[]
required
Keys to remove.
Example request:
Example response:
Retrieve a value using dot-notation path.
any
required
Source object.
string
required
Dot-notation path (e.g., user.address.city).
any
Default value if path not found.
Example request:
Example response:
Set a value at a dot-notation path.
any
required
Source object.
string
required
Dot-notation path.
any
required
Value to set.
Example request:
Example response:
Remove all whitespace from a JSON string.
string
required
JSON string to minify.
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.
string
required
JSON string to format.
number
default:"2"
Number of indentation spaces.
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.
any
required
Source object.
boolean
default:"false"
Include nested keys with dot-notation.
Example request:
Example response:
Extract all values from an object.
any
required
Source object.
Example request:
Example response:
Check if a string is valid JSON.
string
required
String to validate.
Example request:
Example response: