Oqtane Tutorials
Oqtane Tutorials

JSON Tutorials

Tutorial Home › JSON
LINQ Relationships - Children, Parents, Grandchildren, ...
#1 Working with JSON Data
Data Sources Tutorial - use in C# / Razor Code
The samples can differ based on your Razor base class or if you're running an old version.
Selected: Typed (2sxc 16+) Switch to Dynamic (Razor14 or below)
Requirements
Resources

Working with JSON Data

JSON data can be tricky. The easiest way is to convert it to a dynamic object using AsDynamic(string). Then you can easily use it in your code.

It's important to note that in Typed mode everything is much more strict. 

Since JSON itself is very flexible, you must know what the JSON will contain, to write code which is really type safe. As an alternative you can also always parse it using System.Text.Json.

⬇️ Result | Source ➡️

  • Title: This is a JSON title
  • IsCool: True
  • Sub-item title: sub-item title
  • Is this a list/array? False
  • Are the tags a list? True 
@inherits Custom.Hybrid.RazorTyped
@using System.Collections;

@{
  var someJson = System.IO.File.ReadAllText(App.Folder.PhysicalPath + "/tutorials/json-use/demo.json");
  var thing = Kit.Json.ToTyped(someJson);
}
<ul>
  <li>Title:
    @thing.String("Title")
  </li>
  <li>IsCool:
    @thing.Bool("IsCool")
  </li>
  <li>Sub-item title:
    @thing.String("SubItem.Title")
  </li>
  <li>Is this a list/array?
    @(thing is IEnumerable)
  </li>
  <li>Are the tags a list?
    @(thing.Get("Tags") is IEnumerable)
  </li>
</ul>

Source Code of demo.json

{
    "title": "This is a JSON title",
    "isCool": true,
    "subItem": {
        "title": "sub-item title"
    },
    "tags": [
        "some tag",
        "another tag",
        "a third tag"
    ]
}

⬇️ Result | Source ➡️

System.Collections.Generic.List`1[System.Object]
  1. some tag
  2. another tag
  3. a third tag
@inherits Custom.Hybrid.RazorTyped

@{
  var someJson = System.IO.File.ReadAllText(App.Folder.PhysicalPath + "/tutorials/json-use/demo.json");
  var thing = Kit.Json.ToTyped(someJson);
}
@thing.Get("Tags")

<ol>
  @foreach (var tag in thing.Get("Tags") as IEnumerable<object>) {
    <li>@tag</li>
  }
</ol>

Source Code of demo.json

{
    "title": "This is a JSON title",
    "isCool": true,
    "subItem": {
        "title": "sub-item title"
    },
    "tags": [
        "some tag",
        "another tag",
        "a third tag"
    ]
}

⬇️ Result | Source ➡️

  1. title (System.String)
    = This is a JSON title
  2. isCool (System.Boolean)
    = True
  3. subItem (ToSic.Sxc.Data.Internal.Typed.WrapObjectTyped)
    = { "title": "sub-item title" }
  4. tags (System.Collections.Generic.List`1[System.Object])
    = System.Collections.Generic.List`1[System.Object] 
@inherits Custom.Hybrid.RazorTyped
@using System.Collections;

@{
  var someJson = System.IO.File.ReadAllText(App.Folder.PhysicalPath + "/tutorials/json-use/demo.json");
  var thing = Kit.Json.ToTyped(someJson);
}
<ol>
  @foreach (var prop in thing.Keys()) {
    <li>
      <strong>@prop</strong> (@thing.Get(prop).GetType()) <br>
      = @thing.Get(prop)
    </li>
  }
</ol>

Source Code of demo.json

{
    "title": "This is a JSON title",
    "isCool": true,
    "subItem": {
        "title": "sub-item title"
    },
    "tags": [
        "some tag",
        "another tag",
        "a third tag"
    ]
}

 

LINQ Relationships - Children, Parents, Grandchildren, ...
#1 Working with JSON Data
Data Sources Tutorial - use in C# / Razor Code