Not able to parse JSON data properly

Question

I have a JSON as below

var source = "{'Departments': {'Department': [{'DeptName': 'HR','Deptid': '9228590'},{'DeptName': 'Finance','Deptid': '9295426' }]}}";

I need to get all the Deptid and DeptName

I am using Newtonsoft.Json and tried as under

using Newtonsoft.Json;
using System;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            GetInformation();
        }

        private static void GetInformation()
        {
            try
            {
                var source = "{'Departments': {'Department': [{'DeptName': 'HR','Deptid': '9228590'},{'DeptName': 'Finance','Deptid': '9295426' }]}}";
                dynamic stuff =  JsonConvert.DeserializeObject(source);

                string DeptId = stuff.Deparments.Department[0].Deptid;
                string DeptName = stuff.Deparments.Department[0].DeptName;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}

But I am getting Null Reference exception.

http://stackoverflow.com/questions/4535840/deserialize-json-object-into-dynamic-object-using-json-net — MichaelMao, Aug 17 '16 at 10:34

Dheeraj Kumar · Answer 1 · 2016-08-17T10:47:53.730

2

You are using Depid instead of Deptid

It should be: string DeptId = stuff.Departments.Department[0].Deptid;

edited Aug 17 '16 at 10:47

answered Aug 17 '16 at 10:40

Dheeraj Kumar

3,917
8
43
80

Apologies, I thought Rafal's answer had already stated that but it looks like he is only talking about the raw JSON. – sr28 Aug 17 '16 at 10:45
2

Having said that, it looks like he has a typo with stuff.Deparments, where it looks like it should be stuff.Departments ('t' missing). – sr28 Aug 17 '16 at 10:46

score 1 · Accepted Answer · edited Aug 17 '16 at 11:00

1

Your object does not have property DeptId, only Depid. Also, these properties are nested so I guess you need to use something like this:

string DeptId = stuff.Departments.Department[0].Depid;
string DeptName = stuff.Departments.Department[0].DeptName;

edited Aug 17 '16 at 11:00

Martijn Pieters

1,048,767
296
4,058
3,343

answered Aug 17 '16 at 10:33

Rafal Wiliński

2,240
1
21
26

hi, i have modified that..it was a typo – priyanka.sarkar Aug 17 '16 at 10:34
stuff.Deparments is coming as null, so it is coming as null reference exception...i have edited my question – priyanka.sarkar Aug 17 '16 at 10:37

score 1 · Answer 3 · answered Aug 17 '16 at 10:38

1

Try this

stuff.Departments.Department[0].DeptName
stuff.Departments.Department[0].Depid

This is just an example to get the first element from the Array. You need to iterate over array to get the name and id for all the objects in the Array.

answered Aug 17 '16 at 10:38

AmanSinghal

2,404
21
22

score 0 · Answer 4 · answered Aug 17 '16 at 11:27

0

Actually you are using wrong names for Objects like Departments, Depid. IF you correct this objects name it will work.

 string DeptId = stuff.Departments.Department[0].Deptid;
 string DeptName = stuff.Departments.Department[0].DeptName;

answered Aug 17 '16 at 11:27

Paarth

580
3
10

Not able to parse JSON data properly

4 Answers4