i have got one json . i want to read it in following way

Question

hi , ihave following json in mongo db. i can get the rows from mongo db but then i have to do this in c# core. id :1 /** * Paste one or more documents here */ { "nodeHierarchy": { "L1": "Mechanical" }, "weightage": { "$numberDouble": "100" }, "dateFrom": { "$date": { "$numberLong": "1581445800000" } }, "dateTo": { "$date": { "$numberLong": "1582914600000" } }, "WSID": "PRJ1", "scope": { "$numberDecimal": "1000" }, "IsLeafNode": false } id :2 /** * Paste one or more documents here */ { "nodeHierarchy": { "L1": "Mechanical", "L2": "Act1" }, "weightage": { "$numberDouble": "100" }, "dateFrom": { "$date": { "$numberLong": "1581445800000" } }, "dateTo": { "$date": { "$numberLong": "1582914600000" } }, "WSID": "PRJ1", "scope": { "$numberDecimal": "1000" }, "IsLeafNode": true } i have many rows in above formate, but i have take only two rows for brevity, the first row is parent row which has "L1":mechanical, and second row is child of "mechanical" which is at "L2":"Act1" this hierarchy could be at n level. what i have to do is i have to get the child row the last row by filtering "IsleafNode"; true and then divide the weightage of child node with weightage of parent row, and then so on, till i get the top most parent. note; u can suggest to change our json also. how can do it in c# core.

Joginder Banger · Answer

please check collection1 data before the DeserializeObject, becuase i can't imagine what's going on data. So if really need this, if possible you share the project. joginder.banger19@gmail.com

rajesh yadav · Answer

i used newtonsoft and removed $ , now it is deserialising but it is showing error while convesrion. for simplicity i chaned the json, /** * Paste one or more documents here */ { "nodeHierarchy" : "Mechanical" , "leafNode" : "N11" , "weightage" : "100" , "dateFrom" : "1581445800000" , "dateTo" : "1582914600000" , "WSID" : "Rky4" , "scope" : "1000" , "IsLeafNode" : true } var collection = database.GetCollection ( "PlanningData" ); var filter = Builders .Filter.Eq( "WSID" , "Rky4" ); var projection = Builders .Projection.Exclude( "_id" ); ar collection1 = collection.Find (filter).Project(projection).ToList(); //Console.WriteLine(studentDocument.ToString()); object obj = JsonConvert.DeserializeObject(collection1.ToJson()); above obj gets following {[ { "nodeHierarchy" : "Mechanical" , "leafNode" : "N11" , "weightage" : "100" , "dateFrom" : "1581445800000" , "dateTo" : "1582914600000" , "WSID" : "Rky4" , "scope" : "1000" , "IsLeafNode" : true } ]} --belwo is showing error List routes_list = (List )JsonConvert.DeserializeObject(collection1.ToString()); JsonReaderException: Unexpected character encountered while parsing value: S. Path '' , line 0, position 0.

rajesh yadav · Answer

making object is fine , but is there any library for json in .net core c# like xmldocument which itrate xml,

Joginder Banger · Answer

Hi rajesh yadav , please convert to all json in c#, then apply to own logic. Replace the $ value in empty space. public class NodeHierarchy { public string L1 { get ; set ; } } public class Weightage { public string numberDouble { get ; set ; } } public class Date { public string numberLong { get ; set ; } } public class DateFrom { public Date date { get ; set ; } } public class Date2 { public string numberLong { get ; set ; } } public class DateTo { public Date2 date { get ; set ; } } public class Scope { public string numberDecimal { get ; set ; } } public class RootObject { public NodeHierarchy nodeHierarchy { get ; set ; } public Weightage weightage { get ; set ; } public DateFrom dateFrom { get ; set ; } public DateTo dateTo { get ; set ; } public string WSID { get ; set ; } public Scope scope { get ; set ; } public bool IsLeafNode { get ; set ; } } convert json to c#. JavaScriptSerializer json_serializer = new JavaScriptSerializer(); List RootObject> routes_list = (List RootObject> )json_serializer.DeserializeObject( JsonTypeStringData ); above mention code you just got the example of data. Thanks Joginder Singh