Parse JSON to C# object using NewtonSoft JSON.net

Question

I am trying to deserialize a JSON response I get from a webservice. I am trying to use NewtonSoft Json.NET.

I am trying this to parse the response

var results = JArray.Parse(response.Content);

I get following exception

Newtonsoft.Json.JsonReaderException occurred HResult=0x80131500
Message=Error reading JArray from JsonReader. Current JsonReader item is not an array: StartObject. Path '', line 1, position 1.
Source=Newtonsoft.Json

I probably need to define the object to return but am not sure how to specify following response (sorry about the formatting, the indentions was removed by the editor here):

{"result": [
      {
      "recordType": "sys_ui_script",
      "hits": [],
      "tableLabel": "UI Script"
   },
      {
      "recordType": "sys_script",
      "hits":       [
                  {
            "name": "Approval Events (Non-Task)",
            "className": "sys_script",
            "tableLabel": "sys_script",
            "matches": [            {
               "field": "script",
               "fieldLabel": "Script",
               "lineMatches":                [
                                    {
                     "line": 21,
                     "context": "         updateRecord(current, current.approver.getDisplayValue() + \" rejected the task.\", ",
                     "escaped": "         updateRecord(current, current.approver.getDisplayValue() + &quot; rejected the task.&quot;, "
                  }
               ],
               "count": 2
            }],
            "sysId": "ad15c8149f4010008f88ed93ee4bcc9f",
            "modified": 1489179469000
         }
      ],
      "tableLabel": "Business Rule"
   }

]}

Does you JSON have a method call in it? Whats the final output you get? This isn't valid. — Sam Marion
– Sam Marion, Commented Sep 20, 2017 at 15:44
{"result": [ is an object, not an array (and the error says so! "item is not an array"). Did you try JObject.Parse(...)? — crashmstr
– crashmstr, Commented Sep 20, 2017 at 15:46
Above is the output I get which I cannot change as it is an existing rest service on the net. — Tommy
– Tommy, Commented Sep 20, 2017 at 15:46

KreepN · Accepted Answer · 2017-09-20 15:50:27Z

5

Define a class and deserialize it:

var results =  JsonConvert.DeserializeObject<RootObject>(response.Content);   

public class LineMatch
{
    public int line { get; set; }
    public string context { get; set; }
    public string escaped { get; set; }
}

public class Match
{
    public string field { get; set; }
    public string fieldLabel { get; set; }
    public List<LineMatch> lineMatches { get; set; }
    public int count { get; set; }
}

public class Hit
{
    public string name { get; set; }
    public string className { get; set; }
    public string tableLabel { get; set; }
    public List<Match> matches { get; set; }
    public string sysId { get; set; }
    public long modified { get; set; }
}

public class Result
{
    public string recordType { get; set; }
    public List<Hit> hits { get; set; }
    public string tableLabel { get; set; }
}

public class RootObject
{
    public List<Result> result { get; set; }
}

answered Sep 20, 2017 at 15:50

KreepN

8,5981 gold badge43 silver badges58 bronze badges

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

2 Comments

Tommy Over a year ago

Thank you KreepN, Much appreciated.

David Siegel Over a year ago

You can also generate this code from the sample data with csharp.quicktype.io

DaniCE · Accepted Answer · 2017-09-20 15:48:26Z

4

As you are parsing an json object you should use

var results = JObject.Parse(response.Content);

JArray.Parse is for arrays as

 ['Small', { 'oneProp': 'Medium' }, 'Large' ]

You can see the documentation here.

edited Sep 20, 2017 at 15:48

answered Sep 20, 2017 at 15:45

DaniCE

2,4211 gold badge20 silver badges28 bronze badges

Collectives™ on Stack Overflow

Parse JSON to C# object using NewtonSoft JSON.net

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related