Category: Transform / Web

This action constructs a JSON object from a tabular dataset. It has two modes: Object per row, array from objects; and Array per column. A constructed JSON object is effectively a regular text value that is stored in a datagrid cell in EasyMorph.

EasyMorph data types are converted to JSON types as follows:

Note that the action fails if the source dataset contains an error value.

EasyMorph automatically detects if a text value is already a JSON object or a JSON array. In this case, the text value is inserted verbatim, i.e. without wrapping in double-quotes. This feature allows creating complex hierarchical JSON objects that nest other JSON objects. For instance, converting the table below:

would produce the following JSON:

{
  "Track":"Circuit Gilles Villeneuve",
  "Country":"Canada",
  "State/province":"QC",
  "City":"Montreal",
  "Location": {
    "lat":45.500578, 
    "long":-73.522461
  },
  "Hiatus": [1987, 2009]
}

Notice that "Location" is inserted as a JSON object, not as text. Also, the field "Hiatus" is inserted as a JSON array, not as text.

Construct a flat JSON object from the tabular dataset.

{
  "Name":"Rabbit",
  "Kingdom":"Animalia",
  "Phylum":"Chordata",
  "Class": "Mammalia",
}

Mode: Object per row

Create flat JSON objects (inside an array) from the multi-row tabular dataset.

[
  {
    "ID":1,
    "Name":"Apple"
  },
  {
    "ID":2,
    "Name":"Orange"
  }
]

Mode: Object per row

Convert the source table into a dataset in which values of each column are rolled up into a JSON array.

Mode: Array per column

Always return an array, even when the table has only one row (useful for APIs that expect an array). Without this option, the result would be a single object: {"ID":1,"Name":"Apple"}

[
  {
    "ID":1,
    "Name":"Apple"
  }
]

Mode: Object per row, array from objects
Make an array even for single object: checked

Leave empty values out of the arrays. Without this option, the "Discount" column would contain [10,null,5].

Mode: Array per column
Exclude nulls from arrays: checked

Construct one JSON per customer. Bob has only one row, so his value is a single object. Check "Make an array even for single object" to get [{"Product":"Banana","Qty":2}] instead.

Alice:

[
  {
    "Product":"Apple",
    "Qty":3
  },
  {
    "Product":"Orange",
    "Qty":1
  }
]

Bob:

{
  "Product":"Banana",
  "Qty":2
}

Mode: Object per row, array from objects
Column name: Items
Group by selected columns: Customer

Roll up the values of each column into arrays per customer. In this mode, an array is created even for a group with a single row.

Mode: Array per column
Group by selected columns: Customer

• Example: Constructing JSON (Project; Module: Main; Group: Tab 1; Table: comments; Action position: 2)
• How to create JSON for Airtable API (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 6)
• Constructing JSON issue (Project; Module: Main; Group: Tab 1; Table: Construct main JSON; Action position: 4)
• How to publish real-time data to streaming dataset in Power BI (Project; Module: Main; Group: Tab 1; Table: Table 1; Action position: 5)
• Community example: Webrequest and parameters

• Parse JSON
• Functions: IsJson()