[Solved] Newtonsoft Json Error: Cannot deserialize the current JSON object into type System.Collections.Generic.List

maideen

SOLVED CLOSED ACTIVE ANSWERED
User: maideen
Posted: on Jul 06, 2021 01:22 AM
Forum: ASP.Net Web Forms
Answer: 1
Views: 41639
Sample Code: Download

Hi Sir,

I have used below link by Mr. dharmendr previously and also using now for API and web service is working well.

But some url cannot work and prompt error.

Newtonsoft.Json.JsonSerializationException: 
'Cannot deserialize the current JSON object (e.g. {"name":"value"}) into type 'System.Collections.Generic.List`1[JsonData_Nwide+BouncesAndBlocks]' because the type requires a JSON array (e.g. [1,2,3]) to deserialize correctly.
To fix this error either change the JSON to a JSON array (e.g. [1,2,3]) or change the deserialized type so that it is a normal .NET type (e.g. not a primitive type like integer, not a collection type like an array or List<T>) that can be deserialized from a JSON object. JsonObjectAttribute can also be added to the type to force it to deserialize from a JSON object.
Path 'status', line 1, position 10.'

The json format like this

{"status":true,"message":"Success",
"data":
[{"cn_no":"R3151248","record_at":"2020-12-24 23:39:37","status_code":"POD","status_description":"Delivered to","location_code":"JHB","location_name":"JOHOR BAHRU","remark":"SYAZWANI"},
{"cn_no":"R3151248","record_at":"2020-12-24 09:05:19","status_code":"CKL","status_description":"Arrived at delivery branch ","location_code":"JHB","location_name":"JOHOR BAHRU","remark":""},
{"cn_no":"R3151248","record_at":"2020-12-24 00:41:24","status_code":"CKO","status_description":"Item dispatched out","location_code":"HUB","location_name":"HUB in Nationwide Shah Alam","remark":""},
{"cn_no":"R3151248","record_at":"2020-12-23 18:51:33","status_code":"CKI","status_description":"Item received","location_code":"NMB","location_name":"Nationwide Main Branch S Alam","remark":""}]}

my code

Public Class BouncesAndBlocks
    Public Property data As List(Of Response)
    Public Property status As String
    Public Property message As String
    Public Property cn_no As String
    Public Property record_at As String
    Public Property status_code As String
    Public Property status_description As String
    Public Property location_code As String
    Public Property location_name As String
    Public Property remark As String
End Class
 
    Dim cnno As String = Me.txtCNNo.Text
    Dim url = New RestClient("https://api.nationwide.com.my/api/track?cn_no=" & cnno)
    url.Timeout = -1
    Dim request = New RestRequest(Method.POST)
    request.AddHeader("Authorization", "Bearer 31|xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx")
    Dim response As IRestResponse = url.Execute(request)
    'Console.WriteLine(response.Content)
    Dim json As String = response.Content
    Dim res As List(Of BouncesAndBlocks) =
        JsonConvert.DeserializeObject(Of List(Of BouncesAndBlocks))(json)

I have debugged. error prompt once reach this line Dim res As List(Of BouncesAndBlocks) = JsonConvert.DeserializeObject(Of List(Of BouncesAndBlocks))(json)

Where I did wrong, I don't know.

Please advice me

Thank you

Maideen

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Jul 06, 2021 01:38 AM
Modified: on Jul 06, 2021 07:23 AM
Report

Hi maideen,

Check this example. Now please take its reference and correct your code.

Code

protected void Page_Load(object sender, EventArgs e)
{
    string json = System.IO.File.ReadAllText(Server.MapPath("~/json.json"));
    BouncesAndBlocks res = Newtonsoft.Json.JsonConvert.DeserializeObject<BouncesAndBlocks>(json);
}
public class Data
{
    public string cn_no { get; set; }
    public string record_at { get; set; }
    public string status_code { get; set; }
    public string status_description { get; set; }
    public string location_code { get; set; }
    public string location_name { get; set; }
    public string remark { get; set; }
}

public class BouncesAndBlocks
{
    public bool status { get; set; }
    public string message { get; set; }
    public IEnumerable<Data> data { get; set; }
}

VB.Net

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
    Dim json As String = IO.File.ReadAllText(Server.MapPath("~/json.json"))
    Dim res As BouncesAndBlocks = Newtonsoft.Json.JsonConvert.DeserializeObject(Of BouncesAndBlocks)(json)
End Sub
Public Class Data
    Public Property cn_no As String
    Public Property record_at As String
    Public Property status_code As String
    Public Property status_description As String
    Public Property location_code As String
    Public Property location_name As String
    Public Property remark As String
End Class

Public Class BouncesAndBlocks
    Public Property status As Boolean
    Public Property message As String
    Public Property data As IEnumerable(Of Data)
End Class

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

[Solved] Newtonsoft Json Error: Cannot deserialize the current JSON object into type System.Collections.Generic.List

Read JSON data from URL and Insert (Save) into database using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us