This is the code. I am getting Diesel rate through API . And i have sample code, i Don't know how to implement this code in my C#.net Code Like in my Page load
public class cities
{
public string city { get; set; }
public string petrol { get; set; }
public string diesel { get; set; }
public string petrol_yesterday { get; set; }
public string state { get; set; }
public string date { get; set; }
}
and Deserialize your json result to your class
cities list = Newtonsoft.Json.JsonConvert.DeserializeObject<cities>(jsonInput);
public class cities
{
public string city { get; set; }
public string petrol { get; set; }
public string diesel { get; set; }
public string petrol_yesterday { get; set; }
public string state { get; set; }
public string date { get; set; }
}
dynamic jsonObject = Newtonsoft.Json.Linq.JObject.Parse(json);
string jsonToDeserializeStrongType = jsonObject["cities"].ToString();
List<cities> result = Newtonsoft.Json.JsonConvert.DeserializeObject<List<cities>>(jsonToDeserializeStrongType); ;
var singleRow = result.Find(x => x.city.Equals("Chennai"));// this line return as same as you want
Response.Write(singleRow.city + " " + singleRow.date + " " + singleRow.diesel);
And i try to eat individual data like chennai only you sent me
publicclass cities
{publicstring city {get;set;}publicstring petrol {get;set;}publicstring diesel {get;set;}publicstring petrol_yesterday {get;set;}publicstring state {get;set;}publicstring date {get;set;}}
Member
147 Points
239 Posts
json format to c#.Net Code
Jun 05, 2018 07:41 AM|vivekbuv|LINK
Dear Friends
This is the code. I am getting Diesel rate through API . And i have sample code, i Don't know how to implement this code in my C#.net Code Like in my Page load
Task<HttpResponse<MyClass>> response = Unirest.get("https://newsrain-petrol-diesel-prices-india-v1.p.mashape.com/state?state=Tamil+Nadu") .header("X-Mashape-Key", "VZznHLmshqH7p1Ka9DrjsnVHOyyRYeYOo3") .header("Accept", "application/json") .asJson();I don't know what type of code this. Please tell me how to transfer this code to C#.net code format. I am new this
Star
8059 Points
2780 Posts
Re: json format to c#.Net Code
Jun 05, 2018 08:13 AM|vahid bakkhi|LINK
hi
you can use WebRequest below like:
string URL = "https://newsrain-petrol-diesel-prices-india-v1.p.mashape.com/state?state=Tamil+Nadu"; HttpWebRequest request = (HttpWebRequest)WebRequest.Create(URL); request.Headers.Add("X-Mashape-Key", "VZznHLmshqH7p1Ka9DrjsnVHOyyRYeYOo3"); request.Method = "GET"; request.ContentType = "application/json"; WebResponse response = request.GetResponse(); using (var reader = new StreamReader(response.GetResponseStream())) { var jsonResponse = reader.ReadToEnd(); Response.Write(String.Format("Response: {0}", jsonResponse)); }Please MARK AS ANSWER if suggestion helps.
Member
147 Points
239 Posts
Re: json format to c#.Net Code
Jun 05, 2018 08:18 AM|vivekbuv|LINK
Thanks Vahid,
Thank you and i need one more, i am getting data like that
"cities": [ { "city": "Delhi", "petrol": "77.83", "diesel": "68.88", "petrol_yesterday": "78.11", "diesel_yesterday": "69.11", "state": "Delhi", "date": "05-06-2018" }, { "city": "Chennai", "petrol": "80.80", "diesel": "72.72", "petrol_yesterday": "81.09", "diesel_yesterday": "72.97", "state": "Tamil Nadu", "date": "05-06-2018" }, { "city": "Mumbai", "petrol": "85.65", "diesel": "73.33", "petrol_yesterday": "85.92", "diesel_yesterday": "73.58", "state": "Maharashtra", "date": "05-06-2018" }, { "city": "Kolkata", "petrol": "80.47", "diesel": "71.43", "petrol_yesterday": "80.75", "diesel_yesterday": "71.66", "state": "West Bengal", "date": "05-06-2018" },How can i separate each data... Thanks
Star
8059 Points
2780 Posts
Re: json format to c#.Net Code
Jun 05, 2018 08:25 AM|vahid bakkhi|LINK
you have create a class same as your json result
public class cities { public string city { get; set; } public string petrol { get; set; } public string diesel { get; set; } public string petrol_yesterday { get; set; } public string state { get; set; } public string date { get; set; } }and Deserialize your json result to your class
Please MARK AS ANSWER if suggestion helps.
Star
8059 Points
2780 Posts
Re: json format to c#.Net Code
Jun 05, 2018 08:38 AM|vahid bakkhi|LINK
I created a sample for parse json result
public class cities { public string city { get; set; } public string petrol { get; set; } public string diesel { get; set; } public string petrol_yesterday { get; set; } public string state { get; set; } public string date { get; set; } }and
string json = @" { ""cities"": [ { ""city"": ""Delhi"", ""petrol"": ""77.83"", ""diesel"": ""68.88"", ""petrol_yesterday"": ""78.11"", ""diesel_yesterday"": ""69.11"", ""state"": ""Delhi"", ""date"": ""05-06-2018"" }, { ""city"": ""Chennai"", ""petrol"": ""80.80"", ""diesel"": ""72.72"", ""petrol_yesterday"": ""81.09"", ""diesel_yesterday"": ""72.97"", ""state"": ""Tamil Nadu"", ""date"": ""05-06-2018"" }, { ""city"": ""Mumbai"", ""petrol"": ""85.65"", ""diesel"": ""73.33"", ""petrol_yesterday"": ""85.92"", ""diesel_yesterday"": ""73.58"", ""state"": ""Maharashtra"", ""date"": ""05-06-2018"" }, { ""city"": ""Kolkata"", ""petrol"": ""80.47"", ""diesel"": ""71.43"", ""petrol_yesterday"": ""80.75"", ""diesel_yesterday"": ""71.66"", ""state"": ""West Bengal"", ""date"": ""05-06-2018"" }] } "; dynamic jsonObject = Newtonsoft.Json.Linq.JObject.Parse(json); string jsonToDeserializeStrongType = jsonObject["cities"].ToString(); List<cities> result = Newtonsoft.Json.JsonConvert.DeserializeObject<List<cities>>(jsonToDeserializeStrongType); ; foreach (var item in result) { }Please MARK AS ANSWER if suggestion helps.
Member
147 Points
239 Posts
Re: json format to c#.Net Code
Jun 05, 2018 10:12 AM|vivekbuv|LINK
Thnaks for reply,
How can i get exact one data. Like i need one data
""city"": ""Chennai"", ""petrol"": ""80.80"", ""diesel"": ""72.72"", ""petrol_yesterday"": ""81.09"", ""diesel_yesterday"": ""72.97"", ""state"": ""Tamil Nadu"", ""date"": ""05-06-2018""How can i get exact data??
Star
8059 Points
2780 Posts
Re: json format to c#.Net Code
Jun 05, 2018 10:23 AM|vahid bakkhi|LINK
please try below code :
dynamic jsonObject = Newtonsoft.Json.Linq.JObject.Parse(json); string jsonToDeserializeStrongType = jsonObject["cities"].ToString(); List<cities> result = Newtonsoft.Json.JsonConvert.DeserializeObject<List<cities>>(jsonToDeserializeStrongType); ; var singleRow = result.Find(x => x.city.Equals("Chennai"));// this line return as same as you wantResponse.Write(singleRow.city + " " + singleRow.date + " " + singleRow.diesel);
Please MARK AS ANSWER if suggestion helps.
Member
147 Points
239 Posts
Re: json format to c#.Net Code
Jun 05, 2018 10:36 AM|vivekbuv|LINK
Thank you so much .... Its very useful
Member
147 Points
239 Posts
Re: json format to c#.Net Code
Jun 11, 2018 07:29 AM|vivekbuv|LINK
Dear Friend,
This Line not working
ERROR
{"Cannot perform runtime binding on a null reference"}
i am getting this error.
Star
8059 Points
2780 Posts
Re: json format to c#.Net Code
Jun 11, 2018 07:41 AM|vahid bakkhi|LINK
your json value is null, you must check it before
string jsonToDeserializeStrongType = ""; if (jsonObject["cities"]!=null) { jsonToDeserializeStrongType = jsonObject["cities"].ToString(); }Please MARK AS ANSWER if suggestion helps.
Member
147 Points
239 Posts
Re: json format to c#.Net Code
Jun 11, 2018 07:49 AM|vivekbuv|LINK
Dear Friend,
Already you sent me set of code for my request but when i use i am getting error i put it full code.
And i try to eat individual data like chennai only you sent me
Here i am getting this error
string jsonToDeserializeStrongType = jsonObject["cities"].ToString();