{{ 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=====
====Example #1====
>Split the following JSON array into individual rows.

===Before (source table)===
All text is contained within a single cell.
<code>
[
  {
    "name": "Doug",
    "id": 7,
    "dept": "Accounting"
  },
  {
    "name": "Sue",
    "id": 2,
    "dept": "HR"
  }
]
</code>

===After (result table)===
Split into individual table rows.
<code>
{
  "name": "Doug",
  "id": 1,
  "dept": "Accounting"
}
</code>
<code>
{
  "name": "Sue",
  "id": 2,
  "dept": "HR"
}
</code>

===Action parameters===
> Column: Employees

\\
=====Community examples=====
  * [[https://community.easymorph.com/t/example-constructing-json/1279/5|Community example: Constructing JSON]]

\\ 
===== See also =====
  * [[transformations:extractjson|Extract JSON properties]]
  * [[transformations:modifyjson|Modify JSON]]
  * [[transformations:parsejson|Parse JSON]]
  * [[syntax:functions:isjson|Functions:  IsJson()]]