User Tools

Site Tools


transformations:splitjsonarray

SPLIT JSON ARRAY

Category: Transform / Web


Description

This action splits a JSON array into rows.


Action settings

Setting Description
ColumnSelect 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

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki