Need help deserializing a json response

Hello everyone,

Ive been stucked on this for quite some time, kindly help look into this, I can't seem to pick out what the error is here....

{ "code": 500, "message": "Cannot deserialize the current JSON array (e.g. [1,2,3]) into type 'ChakaIntegration.API.Models.Response.Instruments.InstrumentsAnalytics' because the type requires a JSON object

(e.g. {\"name\":\"value\"}) to deserialize correctly.\r\nTo fix this error either change the JSON to a JSON object (e.g. {\"name\":\"value\"}) or change the deserialized type to an array or a type that implements a collection interface (e.g. ICollection, IList) like List that can be deserialized from a JSON array.

JsonArrayAttribute can also be added to the type to force it to deserialize from a JSON array.\r\nPath 'data', line 1, position 45.", "data": null, "success": false }

Here is my json:

{

"code": "200",

"message": "Successful",

"data": {

"code": "200",

"message": "Successful",

"data": [

{

"consensusEndDate": null,

"consensusStartDate": 1596153600000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 23,

"ratingHold": 8,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.434211,

"ratingSell": 2,

"ratingUnderweight": 2

{

"consensusEndDate": 1596067200000,

"consensusStartDate": 1595376000000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 23,

"ratingHold": 8,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.447368,

"ratingSell": 3,

"ratingUnderweight": 1

{

"consensusEndDate": 1595289600000,

"consensusStartDate": 1594944000000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 23,

"ratingHold": 9,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.421053,

"ratingSell": 2,

"ratingUnderweight": 1

{

"consensusEndDate": 1594857600000,

"consensusStartDate": 1594598400000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 23,

"ratingHold": 10,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.435897,

"ratingSell": 2,

"ratingUnderweight": 1

{

"consensusEndDate": 1594512000000,

"consensusStartDate": 1594166400000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 23,

"ratingHold": 11,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.45,

"ratingSell": 2,

"ratingUnderweight": 1

{

"consensusEndDate": 1594080000000,

"consensusStartDate": 1591920000000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 23,

"ratingHold": 11,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.4375,

"ratingSell": 1,

"ratingUnderweight": 2

{

"consensusEndDate": 1591833600000,

"consensusStartDate": 1591660800000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 24,

"ratingHold": 11,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.426829,

"ratingSell": 1,

"ratingUnderweight": 2

{

"consensusEndDate": 1591574400000,

"consensusStartDate": 1589500800000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 24,

"ratingHold": 10,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.45122,

"ratingSell": 2,

"ratingUnderweight": 2

{

"consensusEndDate": 1589414400000,

"consensusStartDate": 1589328000000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 25,

"ratingHold": 10,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.440476,

"ratingSell": 2,

"ratingUnderweight": 2

{

"consensusEndDate": 1589241600000,

"consensusStartDate": 1588896000000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 24,

"ratingHold": 10,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.45122,

"ratingSell": 2,

"ratingUnderweight": 2

{

"consensusEndDate": 1588809600000,

"consensusStartDate": 1588291200000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 25,

"ratingHold": 10,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.440476,

"ratingSell": 2,

"ratingUnderweight": 2

{

"consensusEndDate": 1588204800000,

"consensusStartDate": 1587427200000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 25,

"ratingHold": 9,

"ratingNone": 0,

"ratingOverweight": 3,

"ratingScaleMark": 1.426829,

"ratingSell": 2,

"ratingUnderweight": 2

{

"consensusEndDate": 1587340800000,

"consensusStartDate": 1586995200000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 26,

"ratingHold": 9,

"ratingNone": 0,

"ratingOverweight": 2,

"ratingScaleMark": 1.414634,

"ratingSell": 2,

"ratingUnderweight": 2

{

"consensusEndDate": 1586908800000,

"consensusStartDate": 1586822400000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 26,

"ratingHold": 10,

"ratingNone": 0,

"ratingOverweight": 2,

"ratingScaleMark": 1.390244,

"ratingSell": 1,

"ratingUnderweight": 2

{

"consensusEndDate": 1586736000000,

"consensusStartDate": 1586304000000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 26,

"ratingHold": 11,

"ratingNone": 0,

"ratingOverweight": 2,

"ratingScaleMark": 1.378049,

"ratingSell": 1,

"ratingUnderweight": 1

{

"consensusEndDate": 1586217600000,

"consensusStartDate": 1586131200000,

"corporateActionsAppliedDate": 1402272000000,

"ratingBuy": 26,

"ratingHold": 10,

"ratingNone": 0,

"ratingOverweight": 2,

"ratingScaleMark": 1.3625,

"ratingSell": 1,

"ratingUnderweight": 1

}

"success": true

}

And here are my POCO Classes:

public class InstrumentsAnalyticsResponse
{
[JsonProperty("code")]
public long Code { get; set; }
[JsonProperty("message")]
public string Message { get; set; }
[JsonProperty("data")]
public InstrumentAnalytics Data { get; set; }
[JsonProperty("success")]
public bool Success { get; set; }
}
public class InstrumentAnalytics
{
[JsonProperty("code")]
public long Code { get; set; }
[JsonProperty("message")]
public string Message { get; set; }
[JsonProperty("data")]
public List Data { get; set; }
[JsonProperty("success")]
public bool Success { get; set; }
}
public class AnalyticsData
{
[JsonProperty("consensusEndDate")]
public long? ConsensusEndDate { get; set; }
[JsonProperty("consensusStartDate")]
public long ConsensusStartDate { get; set; }
[JsonProperty("corporateActionsAppliedDate")]
public long CorporateActionsAppliedDate { get; set; }
[JsonProperty("ratingBuy")]
public long RatingBuy { get; set; }
[JsonProperty("ratingHold")]
public long RatingHold { get; set; }
[JsonProperty("ratingNone")]
public long RatingNone { get; set; }
[JsonProperty("ratingOverweight")]
public long RatingOverweight { get; set; }
[JsonProperty("ratingScaleMark")]
public double RatingScaleMark { get; set; }
[JsonProperty("ratingSell")]
public long RatingSell { get; set; }
[JsonProperty("ratingUnderweight")]
public long RatingUnderweight { get; set; }
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Varun Setia6y ago
Thanks for updating with solution :)
Oyedepo Olufemi6y ago
thanks everyone, problem solved. the cause of the json not desirializing was because of the long dates (ConsensusEndDate, ConsensusStartDate, CorporateActionsAppliedDate).
Navaneeth Krishnan6y ago
https://www.newtonsoft.com/json/help/html/DeserializeObject.htm

https://stackoverflow.com/questions/34302845/deserialize-json-into-object-c-sharp
Nisha Regil6y ago
Your POCO classes needs modification.
Try using this link https://json2csharp.com/
Varun Setia6y ago
Hi,

Try this:
// Root myDeserializedClass = JsonConvert.DeserializeObject(myJsonResponse);
    public class InstrumentsAnalyticsResponse {
        public long? consensusEndDate { get; set; }
        public object consensusStartDate { get; set; }
        public object corporateActionsAppliedDate { get; set; }
        public int ratingBuy { get; set; }
        public int ratingHold { get; set; }
        public int ratingNone { get; set; }
        public int ratingOverweight { get; set; }
        public double ratingScaleMark { get; set; }
        public int ratingSell { get; set; }
        public int ratingUnderweight { get; set; }
    }

    public class Data    {
        public string code { get; set; }
        public string message { get; set; }
        public List data { get; set; }
        public bool success { get; set; }
    }

    public class Root    {
        public string code { get; set; }
        public string message { get; set; }
        public Data data { get; set; }
        public bool success { get; set; }
    }