Differences

This shows you the differences between two versions of the page.

--- transformations:constructjson [2020/01/11 15:26] – created dmitry
+++ transformations:constructjson [2020/01/11 15:44] – dmitry
@@ Line 4: / Line 4: @@
   * Object per row, array from objects
   * Array per column
+A constructed JSON object is effectively a regular text value that is stored in a datagrid cell in EasyMorph.
 ==== Mode "Object per row" ====
@@ Line 23: / Line 25: @@
   "Family": "Leporidae"
 }
+</code>
+If the source dataset contains multiple rows, they will be converted into an array of JSON objects where each object corresponds to one row. Example:
+^ ID ^ Name ^
+| 1 | Apple  |
+| 2 | Orange |
+Result:
+<code>
+[
+  {
+    "ID":1,
+    "Name":"Apple"
+  },
+  {
+    "ID":2,
+    "Name":"Orange"
+  }
+]
 </code>
 ==== Mode "Array per column" ====
+In this mode the source dataset is converted into a new dataset in which values of each column are rolled up into a JSON array. For instance the table from the example above would be converted into the following table:
+^ ID ^ Name ^
+| [1,2] | [Apple,Orange]  |
 ==== Data type conversion ====
@@ Line 62: / Line 90: @@
 </code>
 Notice that Location is inserted as a JSON object, not as text. Field "Hiatus" is inserted as a JSON array, not as text too.
+==== See also ====
+  * [[https://community.easymorph.com/t/example-constructing-json/1279/5|Example: Constructing JSON]]
+  * [[transformations:parsejson|Parse JSON]]
+  * [[syntax:functions:isjson|isjson]]