JSON Tools: Parse, Query and Transform JSON

parse: Parse a JSON string

Parse a JSON string into a structured object.

string

required

JSON string to parse.

Example request:

{
  "json": "{\"name\":\"Alice\",\"age\":30,\"active\":true}"
}

Example response:

{
  "name": "Alice",
  "age": 30,
  "active": true
}

stringify: Convert to JSON string

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:

{
  "data": { "name": "Alice", "roles": ["admin", "user"] },
  "pretty": false
}

Example response:

"{\"name\":\"Alice\",\"roles\":[\"admin\",\"user\"]}"

query: Query with JSONPath

Extract data using JSONPath expressions.

any

required

JSON data to query.

string

required

JSONPath expression (e.g., $.store.book[*].author).

Example request:

{
  "data": {
    "store": {
      "books": [
        { "title": "Dune", "price": 12.99 },
        { "title": "Neuromancer", "price": 9.99 },
        { "title": "Foundation", "price": 14.99 }
      ]
    }
  },
  "path": "$.store.books[?(@.price<13)]"
}

Example response:

[
  { "title": "Dune", "price": 12.99 },
  { "title": "Neuromancer", "price": 9.99 }
]

flatten: Flatten nested JSON

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:

{
  "data": {
    "user": {
      "name": "Alice",
      "address": { "city": "Portland", "zip": "97201" }
    }
  }
}

Example response:

{
  "user.name": "Alice",
  "user.address.city": "Portland",
  "user.address.zip": "97201"
}

unflatten: Unflatten dot notation

Convert flat dot-notation keys back to nested objects.

any

required

Flattened data.

string

default:"."

Key separator.

Example request:

{
  "data": {
    "user.name": "Alice",
    "user.address.city": "Portland",
    "user.address.zip": "97201"
  }
}

Example response:

{
  "user": {
    "name": "Alice",
    "address": { "city": "Portland", "zip": "97201" }
  }
}

merge: Deep merge objects

Deep merge multiple objects together.

any[]

required

Array of objects to merge.

Example request:

{
  "objects": [
    { "theme": "dark", "lang": "en", "notifications": { "email": true } },
    { "lang": "fr", "notifications": { "sms": true } }
  ]
}

Example response:

{
  "theme": "dark",
  "lang": "fr",
  "notifications": {
    "email": true,
    "sms": true
  }
}

diff: Compare two objects

Find differences between two JSON objects.

any

required

First object.

any

required

Second object.

Example request:

{
  "obj1": { "name": "Alice", "age": 30, "city": "Portland" },
  "obj2": { "name": "Alice", "age": 31, "role": "admin" }
}

Example response:

[
  { "path": "age", "type": "changed", "oldValue": 30, "newValue": 31 },
  { "path": "city", "type": "removed", "oldValue": "Portland" },
  { "path": "role", "type": "added", "newValue": "admin" }
]

pick: Pick specific keys

Extract selected keys from an object.

any

required

Source object.

string[]

required

Keys to pick.

Example request:

{
  "data": { "id": 1, "name": "Alice", "email": "alice@example.com", "password": "hashed_pw" },
  "keys": ["id", "name", "email"]
}

Example response:

{
  "id": 1,
  "name": "Alice",
  "email": "alice@example.com"
}

omit: Remove specific keys

Remove selected keys from an object.

any

required

Source object.

string[]

required

Keys to remove.

Example request:

{
  "data": { "id": 1, "name": "Alice", "email": "alice@example.com", "password": "hashed_pw" },
  "keys": ["password"]
}

Example response:

{
  "id": 1,
  "name": "Alice",
  "email": "alice@example.com"
}

get: Get value at path

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:

{
  "data": {
    "user": {
      "address": { "city": "Portland", "state": "OR" }
    }
  },
  "path": "user.address.city"
}

Example response:

"Portland"

set: Set value at path

Set a value at a dot-notation path.

any

required

Source object.

string

required

Dot-notation path.

any

required

Value to set.

Example request:

{
  "data": { "user": { "name": "Alice" } },
  "path": "user.address.city",
  "value": "Portland"
}

Example response:

{
  "user": {
    "name": "Alice",
    "address": { "city": "Portland" }
  }
}

minify: Minify JSON

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:

{
  "json": "{\n  \"name\": \"Alice\",\n  \"age\": 30\n}"
}

Example response:

"{\"name\":\"Alice\",\"age\":30}"

prettify: Prettify JSON

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:

{
  "json": "{\"name\":\"Alice\",\"age\":30}",
  "indent": 4
}

Example response:

"{\n    \"name\": \"Alice\",\n    \"age\": 30\n}"

keys: Get all keys

Extract all keys from an object.

any

required

Source object.

boolean

default:"false"

Include nested keys with dot-notation.

Example request:

{
  "data": {
    "name": "Alice",
    "address": { "city": "Portland", "zip": "97201" }
  },
  "deep": true
}

Example response:

["name", "address.city", "address.zip"]

values: Get all values

Extract all values from an object.

any

required

Source object.

Example request:

{
  "data": { "name": "Alice", "age": 30, "active": true }
}

Example response:

["Alice", 30, true]

validate: Validate JSON string

Check if a string is valid JSON.

string

required

String to validate.

Example request:

{
  "json": "{name: 'Alice'}"
}

Example response:

{
  "valid": false,
  "error": "Expected property name or '}' at position 1"
}

Overview

Integrations

Remote MCP Servers

Databases

Data Processing

Text and Strings

Numbers and Dates

Files and Media

Encoding and Validation

Developer Tools

JSON Tools: Parse, Query and Transform JSON

Tools