How to read data from Json object

Question

How to read data from Json object

Murari Ram 21

Hi All,

I am getting the data as below. Please help me how to read the data of Head_TO_Res_Det and Head_TO_Pos_Det

string jsonString = "{\"d\":{\"Head_TO_Res_Det\":{\"results\":[{\"Status\":\"E\",\"Task\":\"\",\"Pernr\":\"17015263\",\"Reason\":\"Error - Employee currently in Bench\"}]},\"Head_TO_Pos_Det\":{\"results\":[]},\"LvText\":\"\",\"Pernr\":\"00000000\"}}";

Waiting for valuable replies

Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2021-12-18T16:17:14.26+00:00

Can you post the raw json rather than as a value in a variable?
Murari Ram 21 Reputation points

2021-12-18T16:29:18.53+00:00

Thank you for your response.
Through a service i am getting the json as mentioned above. If you can help by considering that please guide me. I will check how i am getting through service.
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator

2021-12-18T17:27:11.09+00:00

But rather than post a string literal of the json, it would be easier if you posted the json. Use the debugger, write to console the actual text.

You typically use a json serializer to read json. See

https://www.newtonsoft.com/json/help/html/SerializingJSON.htm

Note: Head_TO_Pos_Det has an empty array named results, so you need to find out what format it’s content would be.
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2021-12-18T18:48:59.91+00:00

Use Console.WriteLine (for .NET Framework) or Debug.WriteLine (for .NET Core or .NET Framework) which will output the json to Visual Studio's Output window then copy and paste into your question.

1 answer

Your answer

Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2021-12-18T16:17:14.26+00:00

Can you post the raw json rather than as a value in a variable?
Murari Ram 21 Reputation points

2021-12-18T16:29:18.53+00:00

Thank you for your response.
Through a service i am getting the json as mentioned above. If you can help by considering that please guide me. I will check how i am getting through service.
Bruce (SqlWork.com) 77,686 Reputation points Volunteer Moderator

2021-12-18T17:27:11.09+00:00

But rather than post a string literal of the json, it would be easier if you posted the json. Use the debugger, write to console the actual text.

You typically use a json serializer to read json. See

https://www.newtonsoft.com/json/help/html/SerializingJSON.htm

Note: Head_TO_Pos_Det has an empty array named results, so you need to find out what format it’s content would be.
Karen Payne MVP 35,586 Reputation points Volunteer Moderator

2021-12-18T18:48:59.91+00:00

Use Console.WriteLine (for .NET Framework) or Debug.WriteLine (for .NET Core or .NET Framework) which will output the json to Visual Studio's Output window then copy and paste into your question.

Answer 1

@Murari Ram , you could try the following code to get data from json object.

 string jsonString = "{\"d\":{\"Head_TO_Res_Det\":{\"results\":[{\"Status\":\"E\",\"Task\":\"\",\"Pernr\":\"17015263\",\"Reason\":\"Error - Employee currently in Bench\"}]},\"Head_TO_Pos_Det\":{\"results\":[]},\"LvText\":\"\",\"Pernr\":\"00000000\"}}";  
            dynamic stuff = JObject.Parse(jsonString);  
            Console.WriteLine(stuff.d.Head_TO_Res_Det.results);  
            foreach (JObject item in stuff.d.Head_TO_Res_Det.results)  
            {  
                foreach (JProperty jp in item.Properties())  
                {  
                    Console.WriteLine(jp.Name);  
                    Console.WriteLine(jp.Value);  
                    Console.WriteLine("*****");  
                }  
            }  
            Console.WriteLine(stuff.d.Head_TO_Pos_Det);  
  
            Console.ReadKey();

Please note that we need to install nuget-package Newtonsoft.Json first of all.

Result:

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Murari Ram 21 Reputation points

2021-12-20T12:56:55.487+00:00

Instead of using for loop i have done it in different way. I learned a new concept. Thank you all for your valuable suggestions.
Jack J Jun 25,296 Reputation points

2021-12-21T01:31:17.18+00:00

@Murari Ram , If you have another way to do it, Please share it here. Then accepted it as an accepted answer, which will help others to solve the similar issue.

Thanks for understanding.

Share via

How to read data from Json object

1 answer

Your answer