How to read complex objects from json file in .net core

Question

I have a json like this to read in c# but it showing null.

Provices.json contains this json

{
   "Provinces": {
        "States": [
          {
            "CountryId": 1,
            "Name": "AA (Armed Forces Americas)",
            "Abbreviation": null,
            "Published": false,
            "DisplayOrder": 0,
            "Country": null,
            "Id": 1
          },
          {
            "CountryId": 1,
            "Name": "AE (Armed Forces Europe)",
            "Abbreviation": null,
            "Published": false,
            "DisplayOrder": 0,
            "Country": null,
            "Id": 54
          }
    ]
  }
}

start up file contains

 services.Configure<AppSettings>(Configuration.GetSection("AppSettings"));
 services.Configure<Provinces>(Configuration.GetSection("Provinces"));

This is c# models

   public class Provinces
    {
        public Provinces()
        {
            this.States = new List<State>();
        }
        public List<State> States { get; set; }
    }

    public class State
    {
        public int CountryId { get; set; }

        public string Name { get; set; }

        public string Abbreviation { get; set; }

        public bool Published { get; set; }

        public bool DisplayOrder { get; set; }

        public string Country { get; set; }

        public int Id { get; set; }

    }

This is how I am reading this file which is giving me null values

public class UserService
{
 public UserService(IOptions<AppSettings> appSettings, 
  IOptions<Provinces> states)
    {
           _appSettings = appSettings;
            _states = states;
     }

//Getting value from json


 public List<State> GetStates()
        {
            var data = this._states.Value.States; // Zero count shows here
            return new List<State>(); 
        }

}

I am also reading AppSettings.json which is working fine but province.json is not working.Can You please tell what's wrong i did

you meant to say that here no values are coming right "_states = states"? — Samaritan_Learner
– Samaritan_Learner, Commented May 30, 2019 at 6:52
You are taking the Provinces as section in your startup, try to add it as separate file like this " .AddJsonFile("Provinces.json") — Samaritan_Learner
– Samaritan_Learner, Commented May 30, 2019 at 7:01
Instead of doing it as separate file you can place them in config file only then take the section from configuration like above your code then it will work. — Samaritan_Learner
– Samaritan_Learner, Commented May 30, 2019 at 7:04

Samaritan_Learner · Accepted Answer · 2019-05-30 07:08:28Z

1

var config = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJson(yourconfigSetting.json optional: true, reloadOnChange: true)
.AddJsonFile("Provinces.json", optional: true, reloadOnChange: true)
.Build();

If you call as separate file like this then it will come, or else you can add the contents of Provinces to your appconfig json file and get it as section for that your current code will work.

answered May 30, 2019 at 7:08

Samaritan_Learner

5572 gold badges5 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sweetie Over a year ago

No. Its not working. Moreover If I add this array in appsettings, then also this does not work. There is something else which is wrong

Amélie Dupré · Accepted Answer · 2019-05-30 08:16:11Z

1

You have both Published and DisplayOrder declared as bool but in the file, the values are:

"Published": false,
"DisplayOrder": 0,

Also, when you read your values into data in the code below, you return a new empty list. You need to return data instead.

public List<State> GetStates()
    {
        var data = this._states.Value.States; // Zero count shows here
        return new List<State>(); 
    }

answered May 30, 2019 at 8:16

Amélie Dupré

781 silver badge6 bronze badges

Comments

Shahzad Khan · Accepted Answer · 2019-05-30 08:02:02Z

0

What is observe, some of fields are missing to make them as nullable like DisplayOrder e.g. json is not loading because of null property.

public class State
    {
        public int CountryId { get; set; }

        public string Name { get; set; }

        public string Abbreviation { get; set; }

        public bool Published { get; set; }

        public bool DisplayOrder { get; set; }

        public string Country { get; set; }

        public int Id { get; set; }

    }

Note: Expect string property no need make them as null, rest type of parameter we need to make him as null and if you sure property also contain value then no need made him as a null parameter.

answered May 30, 2019 at 8:02

Shahzad Khan

5303 silver badges14 bronze badges

Comments

Sweetie · Accepted Answer · 2019-05-30 09:07:45Z

0

I got my problem.

Well, the answer was in type.

        "CountryId": 1,
        "Name": "AE (Armed Forces Europe)",
       // "Abbreviation": null,
       // "Published": false,
       //"DisplayOrder": 0,
       // "Country": null,
        "Id": 54

On commenting out these lines, it started working.

Second Mistake is to add json file in Program.cs[.net core version 2.0]

edited May 30, 2019 at 9:07

answered May 30, 2019 at 7:34

Sweetie

1,3788 gold badges26 silver badges52 bronze badges

Collectives™ on Stack Overflow

How to read complex objects from json file in .net core

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related