transformations:splitjsonarray
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
Source JSON: (All text contained within a single cell).
Employees:
[
{
"name": "Doug",
"id": 7,
"dept": "Accounting"
},
{
"name": "Sue",
"id": 2,
"dept": "HR"
},
{
"name": "Mark",
"id": 5,
"dept": "Maintenance"
},
{
"name": "Tamara",
"id": 1,
"dept": "Administration"
}
]
Action parameters:
Column is "Employees"
Result:
Employees (Individual rows)
{
"name": "Doug",
"id": 1,
"dept": "Accounting"
}
{
"name": "Sue",
"id": 2,
"dept": "HR"
}
{
"name": "Mark",
"id": 5,
"dept": "Maintenance"
}
{
"name": "Tamara",
"id": 1,
"dept": "Adminstration"
}
See also
transformations/splitjsonarray.txt · Last modified: 2022/10/07 22:39 by craigt