Extracting Information from a particular node of json string and add it to a list in C#

Question

I am new in json. I want information user in various time and add them to diffrent lists.

My json text is like this -

{    "201322052":{  
  "Sat Aug 04 04:14:03":"https://blablabla",
  "Sat Aug 04 04:19:55":"https://blablabla2"},
"Doctor 201322052":{  
  "Sat Aug 04 04:19:35":"https://bla bla bla 3" }, 

"JrPwbApfIHbQhCUmVIoiVJcPYv93":{ 
"Sat Aug 04 04:02:47":{  
     "Misc":"sdasd",
     "Product":"asd",
     "address":"sd",
     "name":"Dr. Bua"
  },
  "Sat Aug 04 04:03:21":{  
     "Misc":"sdasd",
     "Product":"asd",
     "address":"sd",
     "name":"Dr. Bua"
  },
  "Sat Aug 04 04:03:28":{  
     "Misc":"sdasd",
     "Product":"asd",
     "address":"sd",
     "name":"Dr. Bua"
  },
  "Sat Aug 04 04:03:31":{  
     "Misc":"sdasd",
     "Product":"asd",
     "address":"sd",
     "name":"Dr. Bua"
  }
   }}

from a firebase database. I want to extract information of "JrPwbApfIHbQhCUmVIoiVJcPYv93" in this format-

DocName-----------Adress------Product----------Misc-------time

Dr. Bua---------Mirpur---------asd-------------sdsds------Sat Aug 04 04:02:47

Dr. Bua---------Mirpur---------asd-------------sdsds------Sat Aug 04 04:03:28

Dr. Bua---------Mirpur---------asd-------------sdsds------Sat July 04 04:03:28

I guess you get the idea. In my last question about extracting information I got a huge help from Mr. John Wu. I understand I need to do the same in here, but cannot get how to extract node "JrPwbApfIHbQhCUmVIoiVJcPYv93" from whole json separately and then apply that again.

Why didn't accept the answer provided to the question you liked to? — Nkosi
– Nkosi, Commented Aug 4, 2018 at 23:37
You can follow a similar structure for this data as well.. Load the JSON. get the desired key value as a JObject and parse it as a dictionary. — Nkosi
– Nkosi, Commented Aug 4, 2018 at 23:40
Why is this not a duplicate of Extracting Information from json string and add it to a list in C#? Do you not know how to filter out the "201322052" and "Doctor 201322052" properties whose values are inconsistent with the schema? — dbc
– dbc, Commented Aug 5, 2018 at 1:04

Saikat halder · Accepted Answer · 2018-08-05 03:24:05Z

0

Sorry for bothering, all I needed to do is

JObject jobject = JObject.Parse(jsonString); JObject user = (JObject)jobject["JrPwbApfIHbQhCUmVIoiVJcPYv93"];

user.toString() gives the following data

{     "Sat Aug 04 04:02:47":{  
  "Misc":"sdasd",
  "Product":"asd",
  "address":"sd",
  "name":"Dr. Bua"},"Sat Aug 04 04:03:21":{  
  "Misc":"sdasd",
  "Product":"asd",
  "address":"sd",
  "name":"Dr. Bua",
"Sat Aug 04 04:03:28":{  
  "Misc":"sdasd",
  "Product":"asd",
  "address":"sd",
  "name":"Dr. Bua"},
"Sat Aug 04 04:03:31":{  
  "Misc":"sdasd",
  "Product":"asd",
  "address":"sd",
  "name":"Dr. Bua"}}

which I actually needed. Then I extracted the information separately by this help previously provided. Thank you everyone for your response.

edited Aug 5, 2018 at 3:24

answered Aug 5, 2018 at 2:07

Saikat halder

6188 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Extracting Information from a particular node of json string and add it to a list in C#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related