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