JSON data, simple display in xamarin forms

Question

Hello I have a big JSON file representing countries and their total cases and deaths from covid. All I want to do is to display the data of the JSON in to my AboutPage. I have tried various ways, but no-one is working for me. Any idea how I should work?

I am giving you a small part of the JSON

[{
  "regionData": [
    {
      "country": "World",
      "totalCases": 157341642,
      "newCases": 651328,
      "totalDeaths": 3278509,
      "newDeaths": 9126,
      "totalRecovered": 135480211,
      "activeCases": 18582922,
      "seriousCritical": 108879,
      "casesPerMil": 20185,
      "deathsPerMil": 420.6,
      "totalTests": 0,
      "testsPerMil": 0,
      "population": 0
    },
    {
      "country": "India",
      "totalCases": 21886556,
      "newCases": 401271,
      "totalDeaths": 238265,
      "newDeaths": 4194,
      "totalRecovered": 17917013,
      "activeCases": 3731278,
      "seriousCritical": 8944,
      "casesPerMil": 15729,
      "deathsPerMil": 171,
      "totalTests": 298601699,
      "testsPerMil": 214596,
      "population": 1391457000
    },  ]
}]

var assembly = typeof(AboutPage).GetTypeInfo().Assembly; Stream stream = assembly.GetManifestResourceStream("MaybeThisOne.testmodel.json");

        using (var reader = new System.IO.StreamReader(stream))
        {
            var json = reader.ReadToEnd();

            List<TestModel> mylist = JsonConvert.DeserializeObject<List<TestModel>>(json);
            myrootobject = new ObservableCollection<TestModel>(mylist);
            MyListView.ItemsSource = myrootobject;

JsonConvert.DeserializeObject<List> In this part i have error saying cannot be used like method. I tried to remove the parenthesis but nothing happened

UPDATED:

I did the steps that were suggested, 1. create a C# model using json2csharp.com, 2. deserialize using newtonsoft. The build is happening and the app starts, but when I try to enter the created page, it terminates the app without any error message.

UPDATED 2:

I started a new project and followed the above steps. The only error I get is about Page3. I have to call it in the shell from jsonarray folder. How should I do it?

e.x <ShellContent Title="About" Icon="icon_about.png" Route="AboutPage" ContentTemplate="{DataTemplate local:AboutPage}" />

Please can you tell me how should I call Page3 from jsonarray folder? Thanks in advance!!!

UPDATE 3

I have started the project from scratch and it partially worked. The only problem is that it doesn't show all the binding fields.

Any idea?

enter image description here

Answer 1

I use Newtonsoft.Json 13.0.1 to convert JSON Array Objects into generic list, and I also modify your json.json file, remove the outer brackets. setting json.json file Build Action as Embedded resource

{
"regionData": [
  {
    "country": "World",
    "totalCases": 157341642,
    "newCases": 651328,
    "totalDeaths": 3278509,
    "newDeaths": 9126,
    "totalRecovered": 135480211,
    "activeCases": 18582922,
    "seriousCritical": 108879,
    "casesPerMil": 20185,
    "deathsPerMil": 420.6,
    "totalTests": 0,
    "testsPerMil": 0,
    "population": 0
  },
  {
    "country": "India",
    "totalCases": 21886556,
    "newCases": 401271,
    "totalDeaths": 238265,
    "newDeaths": 4194,
    "totalRecovered": 17917013,
    "activeCases": 3731278,
    "seriousCritical": 8944,
    "casesPerMil": 15729,
    "deathsPerMil": 171,
    "totalTests": 298601699,
    "testsPerMil": 214596,
    "population": 1391457000
  }
]
}

There is regionData property containing list data, so you need to create new class TestList, contains List regionData property

 public class TestList
{
    public List<TestModel> regionData { get; set; }
}

public class TestModel
{       
    public string country { get; set; }
    public string totalCases { get; set; }
}

ContentPage.cs:

  public Page3()
    {
        InitializeComponent();
        TestList modellist = new TestList();
      

        var assembly = typeof(jsonarray.Page3).GetTypeInfo().Assembly;          
        Stream stream = assembly.GetManifestResourceStream("FormsSample.json3.json");
        using (var reader = new System.IO.StreamReader(stream))
        {
            var jsonString = reader.ReadToEnd();

            //Converting JSON Array Objects into generic list               
            modellist = JsonConvert.DeserializeObject<TestList>(jsonString);

            
            listview1.ItemsSource = modellist.regionData;
        }
    }

Finally, I have the list data in ListView, having no problem.

Update:

My project name is FormsSample, and I add Json3.json file in root directory, Build Action as Embedded resource, you can see the following screenshot.

Page 3 is one ContentPage, contains ListView, to display Json data.

<ContentPage
x:Class="FormsSample.jsonarray.Page3"
xmlns="http://xamarin.com/schemas/2014/forms"
xmlns:x="http://schemas.microsoft.com/winfx/2009/xaml">
<ContentPage.Content>
    <StackLayout>
        <ListView x:Name="listview1">
            <ListView.ItemTemplate>
                <DataTemplate>
                    <ViewCell>
                        <StackLayout Orientation="Horizontal">
                            <Label Text="{Binding country}" />
                            <Label
                                HorizontalOptions="CenterAndExpand"
                                Text="{Binding totalCases}"
                                VerticalOptions="CenterAndExpand" />
                        </StackLayout>
                    </ViewCell>
                </DataTemplate>
            </ListView.ItemTemplate>
        </ListView>
    </StackLayout>
</ContentPage.Content>