Flatten JSON

The Flatten JSON Component is used to transform complex and nested JSON structures into a simplified, tabular format. This is especially useful for preparing hierarchical or deeply nested JSON data for downstream processing, analytics, or integration with relational systems.

Key Capabilities

• Convert nested JSON objects into flat, tabular structures.

• Select specific columns for flattening with aliasing and data type options.

• Upload reference files (CSV, JSON) to guide schema mapping.

• Download schema structure in JSON format for reuse or modification.

Configuration Overview

All Flatten JSON configurations are organized into the following sections:

• Basic Information

• Meta Information

• Resource Configuration

Configuring Meta Information

Column Filter

• Enter the column name to read from the JSON.

• Optionally:

  • Assign an alias name.

  • Select a column type from the drop-down menu (e.g., String, Integer, Date).

File Options

• Upload File

  • Upload existing system files in CSV or JSON format.

  • File size limit: 2 MB.

  • Useful for providing schema or sample data.

• Download Data

  • Download the JSON schema structure for the selected dataset.

  • Output is in JSON format, which can be edited or reused in other pipelines.

Example Use Cases

• Flatten customer records stored in nested JSON (e.g., customer → address → city) into tabular rows.

• Simplify IoT sensor data where nested attributes must be exposed as individual columns.

• Convert API responses with embedded objects into relational datasets for SQL processing.