Need to deserialize an array of arrays in C#

Question

Need to de-serialize an array of array response to List<Model>

This is my response from other endpoint:

"[[{"BillRateCardId":6992,"ExternalRateCardId":"cd77d9b5-a00e-4696"}]]"

Am using the below line of code to deserialize it to the Model but receiving the error "cant de-serialize that":

List<Model> Res = JsonConvert.DeserializeObject<List<Model>>(Response);

Andrejs Ķīlis · Accepted Answer · 2022-09-18 18:42:10Z

1

You need to specify the data type that List is expected to contain, either by modeling it as an object:

using Newtonsoft.Json;
var input = "[[{\"BillRateCardId\":6992,\"ExternalRateCardId\":\"cd77d9b5-a00e-4696\"}]]";
var deserialized = JsonConvert.DeserializeObject<List<List<ResponseModel>>>(input);
class ResponseModel
{
    public int BillRateCardId { get; set; }
    public string? ExternalRateCardId { get; set; }
}

or by using dynamic, but then you lose static type checking:

using Newtonsoft.Json;

var input = "[[{\"BillRateCardId\":6992,\"ExternalRateCardId\":\"cd77d9b5-a00e-4696\"}]]";
var deserialized = JsonConvert.DeserializeObject<List<List<dynamic>>>(input);

Console.WriteLine(JsonConvert.SerializeObject(deserialized));

answered Sep 18, 2022 at 18:42

Andrejs Ķīlis

314 bronze badges

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

3 Comments

karthikeyan sivakumar Over a year ago

Thanks. I have used var externalRateCardIdsResponse = JsonConvert.DeserializeObject<List<Model>>(externalRateCardIdsLambdaResponse); But was receiving error. when changed my code to var externalRateCardIdsResponse = JsonConvert.DeserializeObject<List<List<Model>>>(externalRateCardIdsLambdaResponse); I cant access the properties in it. if (Res.Where(x => x.ExternalRateCardId == (string)rateCard.SelectToken("ExternalRateCardId")) != null) {Sourceid = Res.Where(x => x.ExternalRateCardId == (string)rateCard.SelectToken("ExternalRateCardId")).Select(x => x.BillRateCardId).FirstOrDefault();}

dbc Over a year ago

@karthikeyansivakumar - of course, it is a list of lists, you must loop through the outer list, then through each inner list. Do you know how to do that? If not, see e.g. How to get elements of a List of Lists in C# using linq? or How to Foreach() list of lists? or Iterate over list of lists by the X coordinate?. If you are still unsure, you should ask another question, as the preferred format for questions is one question per post.

dbc Over a year ago

@karthikeyansivakumar - How to merge a list of lists with same type of items to a single list of items? can be used to convert a List<List<ResponseModel>> to a List<ResponseModel> if that is what you require.

Serge · Accepted Answer · 2022-09-19 00:29:34Z

0

since you have only one value, you don't need the custom class

var data =  JArray.Parse(Response);
    
long billRateCardId = data.SelectMany(x=>x)
.Where(x =>(string) x["ExternalRateCardId"]=="cd77d9b5-a00e-4696")
.Select(x=>(long) x["BillRateCardId"]).FirstOrDefault();

answered Sep 19, 2022 at 0:29

Serge

44.4k4 gold badges26 silver badges53 bronze badges

Collectives™ on Stack Overflow

Need to deserialize an array of arrays in C#

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related