Table of Contents
SPLIT JSON ARRAY
Category: Transform / Web
Description
This action splits a JSON array into rows.
Action settings
| Setting | Description |
|---|---|
| Column | Select the column that contains the JSON array structure to split. |
Examples
Example #1
Split the following JSON array into individual rows.
Before (source table)
All text is contained within a single cell.
[
{
"name": "Doug",
"id": 7,
"dept": "Accounting"
},
{
"name": "Sue",
"id": 2,
"dept": "HR"
}
]
After (result table)
Split into individual table rows.
{
"name": "Doug",
"id": 1,
"dept": "Accounting"
}
{
"name": "Sue",
"id": 2,
"dept": "HR"
}
Action parameters
Column: Employees