使用动态对象或模型反序列化 Json

Question

我一直在尝试将以下json转换为C#模型：

{
"Meta Data": {
"1. Information": "Intraday (1min) prices and volumes",
"2. Symbol": "MSFT",
"3. Last Refreshed": "2017-07-25 16:00:00",
"4. Interval": "1min",
"5. Output Size": "Compact",
"6. Time Zone": "US/Eastern"
},
"Time Series (1min)": {
"2017-07-25 16:00:00": {
"1. open": "74.2500",
"2. high": "74.2800",
"3. low": "74.1900",
"4. close": "74.1900",
"5. volume": "2698886"
},
"2017-07-25 15:59:00": {
"1. open": "74.1400",
"2. high": "74.2600",
"3. low": "74.1400",
"4. close": "74.2550",
"5. volume": "375097"
},
"2017-07-25 15:58:00": {
"1. open": "74.1400",
"2. high": "74.1500",
"3. low": "74.1400",
"4. close": "74.1450",
"5. volume": "133209"
}
}
}

我尝试了以下方法：

控制器：

public async Task<IActionResult> Index()
{
var client = new HttpClient();
var task = await client.GetAsync("https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=MSFT&interval=apiKey");
var jsonString = await task.Content.ReadAsStringAsync();
//DAY LIST SHOWS NULL
var dayList = JsonConvert.DeserializeObject<Root>(jsonString).Data;
dynamic fyn = JsonConvert.DeserializeObject(jsonString); 
var returntype = fyn.GetType();
//below i am going to try and format TimeSeriesIntraDayJsonClass which is a manually created model rather than a dynamically created model
RootTwo obj = new RootTwo();
obj.Property1 = JsonConvert.DeserializeObject<RootTwo>(jsonString).Property1;
//trying to get properties individually
JToken token = JObject.Parse(jsonString);
string high = (string)token.SelectToken("2. high");            
return View(dayList);

时间序列日内.cs

namespace ApiTest.Models
{
public class RootTwo
{
public Class1[] Property1 { get; set; }
}
public class Class1
{
[JsonProperty(PropertyName = "Meta Data")]
public string MetaName { get; set; }
public Dictionary<string, HeadData> Meta { get; set; }
[JsonProperty(PropertyName = "Time Series (1min)")]
public string Title { get; set; }
//name of each dictionary is the date which is a dynamic value then that name holds the dictionary which has the actual data
public List<Dictionary<string, Dictionary<ChildrenData, string>>> DateName { get; set; }
}
public class HeadData
{
[JsonProperty(PropertyName = "1. Information")]
public string Information { get; set; }
[JsonProperty(PropertyName = "2. Symbol")]
public string Symbol { get; set; }
[JsonProperty(PropertyName = "3. Last Refreshed")]
public string LastRefrshed { get; set; }
[JsonProperty(PropertyName = "4. Interval")]
public string Interval { get; set; }
[JsonProperty(PropertyName = "5. Output Size")]
public string OutputSize { get; set; }
[JsonProperty(PropertyName = "6. Time Zone")]
public string TimeZone { get; set; }
}
public class ChildrenData
{
[JsonProperty(PropertyName = "1. open")]
public string Open { get; set; }
[JsonProperty(PropertyName = "2. high")]
public string High { get; set; }
[JsonProperty(PropertyName = "3. low")]
public string Low { get; set; }
[JsonProperty(PropertyName = "4. close")]
public string Close { get; set; }
[JsonProperty(PropertyName = "5. volume")]
public string Volume { get; set; }
}
}

时间序列日内类2.cs

namespace ApiTest.Models
{
public class Root
{
public List<Dictionary<string, TimeSeriesIntraDayJsonClass>> Data { get; set; }
}
public class TimeSeriesIntraDayJsonClass
{
[JsonProperty(PropertyName = "1. open")]
public double open { get; set; }
[JsonProperty(PropertyName = "2. high")]
public double high { get; set; }
[JsonProperty(PropertyName = "3. low")]
public double low { get; set; }
[JsonProperty(PropertyName = "4. close")]
public double close { get; set; }
[JsonProperty(PropertyName = "5. volume")]
public double volume { get; set; }
}
}

在控制器中，我尝试将 json 添加到我创建的模型中。

我也尝试通过编辑 -> 选择性粘贴 -> 粘贴 json 作为类创建一个模型类，但它不起作用。

最后，我创建了一个返回 2 个子令牌的动态对象;"元数据"和"时间序列(1分钟("。"时间序列(1分钟("在字典中，我尝试将此数据添加到我创建的模型中，并使用JToken并按属性获取数据，但我的运气为0。 我知道有很多关于在堆栈溢出上转换 JSON 数据的信息，但我无法弄清楚这一点。 有人可以帮忙吗？

Answer 1

已更新

---

感谢奥里尔。我试图将 JSON 反序列化为字典，它可以工作。 所以这里是类和动态解析的示例：

以下是您需要的课程：

public class Root
{
[JsonProperty(PropertyName = "Meta Data")]
public MetaData metaData { get; set; }
[JsonProperty(PropertyName = "Time Series (15min)")] // You will need to change 15min to the interval you will use
public Dictionary<string, TimeSeriesIntraDayJsonClass> Data { get; set; }
}
public class MetaData
{
[JsonProperty(PropertyName = "1. Information")]
public string Information { get; set; }
[JsonProperty(PropertyName = "2. Symbol")]
public string Symbol { get; set; }
[JsonProperty(PropertyName = "3. Last Refreshed")]
public DateTime LastRefreshed { get; set; }
[JsonProperty(PropertyName = "4. Interval")]
public string Interval { get; set; }
[JsonProperty(PropertyName = "5. Output Size")]
public string OutputSize { get; set; }
[JsonProperty(PropertyName = "6. Time Zone")]
public string TimeZone { get; set; }
}
public class TimeSeriesIntraDayJsonClass
{
[JsonProperty(PropertyName = "1. open")]
public double open { get; set; }
[JsonProperty(PropertyName = "2. high")]
public double high { get; set; }
[JsonProperty(PropertyName = "3. low")]
public double low { get; set; }
[JsonProperty(PropertyName = "4. close")]
public double close { get; set; }
[JsonProperty(PropertyName = "5. volume")]
public double volume { get; set; }
}

这是去实现的代码：

var client = new HttpClient();
var task = await client.GetAsync("https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=MSFT&interval=15min&outputsize=full&apikey=5RO0LRV8R1L6H6ES");
var jsonString =await task.Content.ReadAsStringAsync().Result;

dynamic fyn = JsonConvert.DeserializeObject(jsonString);
Console.WriteLine(fyn["Time Series (15min)"]["2017-07-25 16:00:00"]["1. open"]);
Root res = JsonConvert.DeserializeObject<Root>(jsonString);