{{ transformations:SplitJsonAction.png}}
======SPLIT JSON ARRAY======
Category: Transform / Web \\

\\ 
=====Description=====
This action splits a [[https://en.wikipedia.org/wiki/JSON|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:**
<code>
[
  {
    "name": "Doug",
    "id": 7,
    "dept": "Accounting"
  },
  {
    "name": "Sue",
    "id": 2,
    "dept": "HR"
  },
  {
    "name": "Mark",
    "id": 5,
    "dept": "Maintenance"
  },
  {
    "name": "Tamara",
    "id": 1,
    "dept": "Administration"
  }
]
</code>


\\ 
**Action parameters:**
> Column is "Employees"
\\ 
**Result:**\\

**Employees** (Individual rows)
<code>
{
  "name": "Doug",
  "id": 1,
  "dept": "Accounting"
}
</code>
<code>
{
  "name": "Sue",
  "id": 2,
  "dept": "HR"
}
</code>
<code>
{
  "name": "Mark",
  "id": 5,
  "dept": "Maintenance"
}
</code>
<code>
{
  "name": "Tamara",
  "id": 1,
  "dept": "Adminstration"
}
</code>



\\ 
===== See also =====
  * [[transformations:extractjson|Extract JSON properties]]
  * [[transformations:modifyjson|Modify JSON]]
  * [[transformations:parsejson|Parse JSON]]
  * [[syntax:functions:isjson|Functions:  IsJson()]]
  * [[https://community.easymorph.com/t/example-constructing-json/1279/5|Community example: Constructing JSON]]