Blocks
JSON Processor
Process and transform JSON data
Process, transform, validate, and manipulate JSON data with various operations like filtering, mapping, merging, and extracting specific fields. Supports JSONPath queries and schema validation.
Block Preview
JSON Processor
Process and transform JSON data
Usage
- Add the block to your workflow and connect it to the upstream step.
- Configure any required credentials or tokens in the inputs.
- Fill in required inputs and optional parameters for the run.
- Run a test execution, inspect outputs, and iterate before deploying.
- Deploy the json_processor block with monitoring enabled in production.
Inputs (UI)
Input Data
long-inputPlaceholder: Enter JSON data...
Layout: full
Operation
dropdownLayout: half
Options: Validate JSON, Format/Pretty Print, Minify JSON, Extract Field
Output Format
dropdownLayout: half
Options: JSON, String, Array, Object
Field Path / JSONPath
short-inputPlaceholder: e.g., $.users[*].name or data.items
Layout: full
Condition: operation = ["extract","jsonpath"]
Filter Condition
long-inputPlaceholder: item => item.age > 18
Layout: full
Condition: operation = ["filter"]
Map Function
long-inputPlaceholder: item => ({ ...item, fullName: item.firstName + " " + item.lastName })
Layout: full
Condition: operation = ["map"]
Data to Merge
long-inputPlaceholder: Additional JSON data to merge...
Layout: full
Condition: operation = ["merge"]
JSON Schema
long-inputPlaceholder: JSON Schema for validation...
Layout: full
Condition: operation = ["validate"]
Preserve Data Types
switchLayout: half
Sort Keys
switchLayout: half
Inputs (API)
inputData
jsonOptional
operation
stringOptional
outputFormat
stringOptional
fieldPath
stringOptional
filterCondition
stringOptional
mapFunction
stringOptional
mergeData
jsonOptional
schema
jsonOptional
preserveTypes
booleanOptional
sortKeys
booleanOptional
Outputs
Primary response type:
{
"content": "string",
"originalData": "json",
"processedData": "json",
"operation": "string",
"dataType": "string",
"size": "number",
"metadata": "json"
}