How to convert JSON string to Class with Newtonsoft while ignoring named json sub objects

Question

Im not sure exactly the right phrasing to as this question but here is the problem. I'm getting data from CoinMarketCap and trying to convert its json response into a Object. My class looks like this:

namespace CryptoCharter.CoinMarketCap
{
    public class LatestQuotes
    {
        public List<LatestQuote> Data { get; set; }
    }
    public class LatestQuote
    {
        public string Name { get; set; }
        public string Symbol { get; set; }
        public string Slug { get; set; }
    }
}

With my Deserialize call looking like this:

LatestQuotes latestQuote = JsonConvert.DeserializeObject<LatestQuotes>(data);

Unfortunately the problem i have is that the json return is like this:

{
  "status": {
    "timestamp": "2022-07-14T18:52:04.589Z",
  },
  "data": {
    "BTC": {
      "name": "aozn4bq7ss",
      "symbol": "BTC",
      "slug": "7sh2jotqs8q",
    },
    "ETH": {
      "name": "4x98y18ibem",
      "symbol": "ETH",
      "slug": "nibbc2nhejg",
    }
  }
}

So my question is how do I get around the fact that data has more json in it. Is there a way to get newtonsoft to treat it as if it looks like this:

{
  "status": {
    "timestamp": "2022-07-14T18:52:04.589Z",
  },
  "data": [
      {"name": "aozn4bq7ss",
      "symbol": "BTC",
      "slug": "7sh2jotqs8q",
    },
    {
      "name": "4x98y18ibem",
      "symbol": "ETH",
      "slug": "nibbc2nhejg",
    }
  ]  
}

I'm having trouble finding a solution to this since the list of items could be any size I can't just assume BTC and ETH are always there and what others will be. Thanks in advance.

Serge · Accepted Answer · 2022-07-14 19:51:15Z

1

try this

    var jsonParsed = JObject.Parse(json);

    LatestQuotes latestQuotes = new LatestQuotes { 
           Timestamp = (DateTime)jsonParsed["status"]["timestamp"] };

    if (jsonParsed["data"].Type.ToString() == "Array") 
       latestQuotes.Data = jsonParsed["data"].ToObject<List<LatestQuote>>();
        else latestQuotes.Data = ((JObject)jsonParsed["data"]).Properties()
                .Select(e => e.Value.ToObject<LatestQuote>()).ToList();

public class LatestQuotes
{
    public DateTime Timestamp { get; set; }
    public List<LatestQuote> Data { get; set; }
}

edited Jul 14, 2022 at 19:51

answered Jul 14, 2022 at 19:40

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

Comments

tmaj · Accepted Answer · 2022-07-15 02:36:48Z

0

I suggest deserialising the json to a dedicated class and then picking out what you need.

The model:

public class LatestQuotesResponseDto
{
   public Dictionary<string,LatestQuote> Data { get; set; }
}

Then:

// TODO error handling
var deserialised = JsonConvert.DeserializeObject<LatestQuotesResponseDto>(data);

var latestQuotes = new LatestQuotes
{
    Data = deserialised.Data.Select(kvp => kvp.Value).ToList();
}

answered Jul 15, 2022 at 2:36

tmaj

35.9k12 gold badges108 silver badges143 bronze badges

1 Comment

Caleb Over a year ago

The solution was using the Dictionary class. i didn't realize you could do that. Thanks for the thelp.

Collectives™ on Stack Overflow

How to convert JSON string to Class with Newtonsoft while ignoring named json sub objects

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related