I have been trying to convert the below json into a C# model:
{
"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"
}
}
}
I have tried the following:
Controller:
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);
TimeSeriesIntraDay.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; }
}
}
TimeSeriesIntraDayClass2.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; }
}
}
In the controller I have tried to add the json to a model I have created.
I have tried to also create a model class through Edit -> Paste Special -> Paste Json as Classes but it did not work.
Lastly, I created a dynamic object which is returning 2 children tokens; "Meta Data" and "Time Series (1min)". "Time Series (1min)" is in a dictionary, I have tried adding this data to a model I created and also using JToken and getting the data by property but I have had 0 luck. I know there is alot of info on converting JSON data on stackoverflow but I have not been able to figure this out. Can someone please help?