Description
The Flatten JSON Array activity helps transform structured tabular data by expanding JSON arrays stored in one or more specified columns. It reads each row, extracts the array from the configured column(s), and flattens each array item into a new row while preserving all other fields.
This is useful when your data source (e.g., an API or a connector) provides one or more columns containing arrays of JSON objects, and you need to break them out into individual rows to support downstream activities like transformations, aggregations, or exports.
Example:
Suppose you’re fetching order data from an API where each order includes a column named Items, which holds a list of purchased items in JSON format. You can use Flatten JSON Array to break out each item into its own row, making it easier to join, filter, or summarize line items later.
- Data – Required
Requires tabular structured input where specific columns contain valid JSON arrays.
Output
| Output Type | Format | Notes |
|---|
| Data | Tabular | Each JSON object in the array is expanded into rows |
Configuration Fields
| Field Name | Description |
|---|
| JSON Columns | List of column names that contain JSON arrays to flatten. Required field. |
| Id | Name | JsonArrayColumn |
|---|
| 1 | Record A | [{"Attr": "A1"}, {"Attr": "A2"}] |
| 2 | Record B | [{"Attr": "B1"}] |
Sample Configuration
| JSON Columns |
["JsonArrayColumn"] |
Sample Output
| Id | Name | Attr |
|---|
| 1 | Record A | A1 |
| 1 | Record A | A2 |
| 2 | Record B | B1 |
