User Tools

Site Tools


transformations:constructjson

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
transformations:constructjson [2021/06/04 13:23]
craigt [See also]
transformations:constructjson [2021/07/18 00:59] (current)
craigt
Line 76: Line 76:
 \\  \\ 
 ===== Nesting JSON objects ===== ===== Nesting JSON objects =====
-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:+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 instanceconverting the table below:
  
 ^ Track ^ Country  ^ State/province ^ City     ^ Location ^ Hiatus ^  ^ Track ^ Country  ^ State/province ^ City     ^ Location ^ Hiatus ^ 
Line 97: Line 97:
 </code> </code>
 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. 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.
 +
 +\\ 
 +=====Community examples=====
 +  * [[https://community.easymorph.com/t//1279/6|Example: Constructing JSON]] ([[https://community.easymorph.com/uploads/short-url/qlhc3zdusCyuxWf2u0h0dqvgo0v.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //comments//; Action position: //2//)
 +  * [[https://community.easymorph.com/t//1661/1|How to create JSON for Airtable API]] ([[https://community.easymorph.com/uploads/short-url/kBrGoLczmNrnMt0SnXUhqOwjjRF.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //6//)
 +  * [[https://community.easymorph.com/t//2142/2|Constructing JSON issue]] ([[https://community.easymorph.com/uploads/short-url/aSWREiaUoC1qFEYRqTyu4Nwzdls.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Construct main JSON//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//2641/1|How to publish real-time data to streaming dataset in Power BI]] ([[https://community.easymorph.com/uploads/short-url/22DTxfF295TVGQhGyvWGsHyadRt.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //5//)
 +  * [[https://community.easymorph.com/t/webrequest-and-parameters/2758/3|Community example:  Webrequest and parameters]]
  
 \\  \\ 
Line 102: Line 110:
   * [[transformations:parsejson|Parse JSON]]   * [[transformations:parsejson|Parse JSON]]
   * [[syntax:functions:isjson|Functions:  IsJson()]]   * [[syntax:functions:isjson|Functions:  IsJson()]]
-  * [[https://community.easymorph.com/t/example-constructing-json/1279/5|Community example: Constructing JSON]] 
-  * [[https://community.easymorph.com/t/webrequest-and-parameters/2758/3|Community example:  Webrequest and parameters]] 
  
transformations/constructjson.txt · Last modified: 2021/07/18 00:59 by craigt