How to convert the json string into list?

Question

0.00/5 (No votes)

See more:

I am consuming the rest post service in my c# application which sends the jsonstring result. I want to convert that result into the list but it is giving error.

Output String:-

{"SearchDocumentResult":"[{\"ContextType\":\"ddd\",\"ContextIDPrimary\":\"TestContextP\",\"ContextIDSecondary\":\"TestContextS\",\"ContextIDTertiary\":\"\",\"RequirementID\":\"17\",\"Source\":\"image\",\"DocumentName\":\"4.pdf\",\"DocumentImage\":\"\",\"ErrorCode\":\"0\",\"ErrorDescription\":\"\",\"createdBy\":\"\",\"createdDate\":\"12-07-2017 15:39:57\"},{\"ContextType\":\"ddd\",\"ContextIDPrimary\":\"TestContextP\",\"ContextIDSecondary\":\"TestContextS\",\"ContextIDTertiary\":\"\",\"RequirementID\":\"18\",\"Source\":\"image\",\"DocumentName\":\"4.pdf\",\"DocumentImage\":\"\",\"ErrorCode\":\"0\",\"ErrorDescription\":\"\",\"createdBy\":\"\",\"createdDate\":\"12-07-2017 15:42:07\"}]"}

I am getting above output as json string . I am unable to convert above string to List. Can anyone guide me on this.

What I have tried:

public class test
        {
            public string ContextType { get; set; }
            public string ContextIDPrimary { get; set; }
            public string ContextIDSecondary { get; set; }
            public string ContextIDTertiary { get; set; }
            public string Source{get;set;}
            public string DocumentID { get; set; }
                
        }

public class JsonHelper
   {
       /// <summary>
       /// JSON Serialization
       /// </summary>
       public static string JsonSerializer<T>(T t)
       {
           DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(T));
           MemoryStream ms = new MemoryStream();
           ser.WriteObject(ms, t);
           string jsonString = Encoding.UTF8.GetString(ms.ToArray());
           ms.Close();
           return jsonString;
       }
       /// <summary>
       /// JSON Deserialization
       /// </summary>
       public static T JsonDeserialize<T>(string jsonString)
       {
           DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(T));
           MemoryStream ms = new MemoryStream(Encoding.UTF8.GetBytes(jsonString));
           T obj = (T)ser.ReadObject(ms);
           return obj;
       }
   }

public class RootObject
    {
       // public List<SearchDocumentResult> SearchDocumentResult { get; set; }

        public IEnumerable<SearchDocumentResult> SearchDocumentResult { get; set; }

        //public List<Person> People1 { get; set; }
    }

protected void Button1_Click(object sender, EventArgs e)
        {
          

            test t = new test
            {
                ContextType = "ddd",
                ContextIDPrimary = "",
                ContextIDSecondary = "",
                ContextIDTertiary = " ",
                Source = "",
                DocumentID = ""

            };

            DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(test));
            MemoryStream mem = new MemoryStream();
            ser.WriteObject(mem, t);
            string data = Encoding.UTF8.GetString(mem.ToArray(), 0, (int)mem.Length);
            WebClient webClient = new WebClient();
            webClient.Headers["Content-type"] = "application/json";
            webClient.Encoding = Encoding.UTF8;
            string result = webClient.UploadString("http://192.168.0.151:222/Service1.svc/SearchDocument", "POST", data);

            var result11 = JsonHelper.JsonDeserialize<RootObject1>(result);

            //JavaScriptSerializer serializer = new JavaScriptSerializer();
            //serializer.MaxJsonLength = Int32.MaxValue;
           
           // var a = serializer.Deserialize(result, typeof(object));
          

          // string json = "{\"People\":[{\"FirstName\":\"Hans\",\"LastName\":\"Olo\"},{\"FirstName\":\"Jimmy\",\"LastName\":\"Crackedcorn\"}]}";

          //// var result11 = JsonHelper.JsonDeserialize<RootObject1>(json);

          // var firstNames = result11.People.Select(p => p.FirstName).ToList();
          // var lastNames = result11.People.Select(p => p.LastName).ToList();

        }

Posted 16-Jul-17 22:52pm

dattaprasaddhuri

Updated 17-Jul-17 1:40am

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andy Lanng · Answer 1 · 2017-07-16T23:00:00

Look up Newtonsoft[^]. It's pretty much industry standard these days.

Get it with NuGet. There are loads of instructions all over the interwebs, but here's how to use it:

C#

var myTest = Movie m = JsonConvert.DeserializeObject<test[]>(json);

You "can" even just deserialize into a dynamic object, but it's always better to create your own classes, just as you have done

UPDATE: fair point, this won't work out of the box with the json above.

You can deserialise an array but you have to deserialize into a List object.

The first issue is that your json contains a json sub-string. You will have to deserialize this first:

C#

var searchResult = JObject.Parse(json).SearchDocumentResult; //dynamic but gets string
//then you can deserialize that:
var myTest = Movie m = JsonConvert.DeserializeObject<List<test>>(json);

F-ES Sitecore · Answer 2 · 2017-07-16T23:22:00

It depends what is in "result". If it is just the JSON then you need to deserialise to a List<test> as it represents is an array of test objects.

string result = "[{\"ContextType\":\"ddd\",\"ContextIDPrimary\":\"TestContextP\",\"ContextIDSecondary\":\"TestContextS\",\"ContextIDTertiary\":\"\",\"RequirementID\":\"17\",\"Source\":\"image\",\"DocumentName\":\"4.pdf\",\"DocumentImage\":\"\",\"ErrorCode\":\"0\",\"ErrorDescription\":\"\",\"createdBy\":\"\",\"createdDate\":\"12-07-2017 15:39:57\"},{\"ContextType\":\"ddd\",\"ContextIDPrimary\":\"TestContextP\",\"ContextIDSecondary\":\"TestContextS\",\"ContextIDTertiary\":\"\",\"RequirementID\":\"18\",\"Source\":\"image\",\"DocumentName\":\"4.pdf\",\"DocumentImage\":\"\",\"ErrorCode\":\"0\",\"ErrorDescription\":\"\",\"createdBy\":\"\",\"createdDate\":\"12-07-2017 15:42:07\"}]";

var result11 = JsonHelper.JsonDeserialize<List<test>>(result);

If "result" has the xml around it you'll need to use something like XmlDocument to extract the JSON from the XML then do as above.

londhess · Answer 3 · 2017-07-17T01:40:00

try something like this.

var testString={"SearchDocumentResult":"[{\"ContextType\":\"ddd\",\"ContextIDPrimary\":\"TestContextP\",\"ContextIDSecondary\":\"TestContextS\",\"ContextIDTertiary\":\"\",\"RequirementID\":\"17\",\"Source\":\"image\",\"DocumentName\":\"4.pdf\",\"DocumentImage\":\"\",\"ErrorCode\":\"0\",\"ErrorDescription\":\"\",\"createdBy\":\"\",\"createdDate\":\"12-07-2017 15:39:57\"},{\"ContextType\":\"ddd\",\"ContextIDPrimary\":\"TestContextP\",\"ContextIDSecondary\":\"TestContextS\",\"ContextIDTertiary\":\"\",\"RequirementID\":\"18\",\"Source\":\"image\",\"DocumentName\":\"4.pdf\",\"DocumentImage\":\"\",\"ErrorCode\":\"0\",\"ErrorDescription\":\"\",\"createdBy\":\"\",\"createdDate\":\"12-07-2017 15:42:07\"}]"};

var result = JsonConvert.DeserializeObject<List<test>>(json);

How to convert the json string into list?

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0