JSON Format WebAPI Entity Framework

Question

Currently the JSON I'm using looks like this:

The JSON file is huge so I'm only showing the first few rows in the file so not all data is shown. I'd like to get this JSON structured so I can use in a TreeView menu so I'd like to see get the out put to be: I'm getting the data using EF Core, C# in a WebAPI.

OR will this JSON work and I just need to figure out how to build the TreeView navigation from it?

New:

   Lot

     Chevy

      Ford

Used:

    Lot

        Ford

    back  lot

         Ford

[
    {
       "node" : "New",
       "node1" : 
        [
           {
              "node2" : 
               [
                 { 
                   "node2" : "Chevy",
                    "location" : [ 
                           "lot" 
                        ]
                     }
                 ]
           },
          { "node2" : [ 
                { 
                   "node2" : "Ford",
                    "location" : [
                       "lot"
                      ] 
                  }
               ]
           }
  
        ]

     },
     {
       "node" : "Used",
       "node1" : 
        [
           {
              "node2" : 
               [
                 { 
                   "node2" : "Ford",
                    "location" : [ 
                           "back lot" 
                        ]
                     }
                 ]
           },
          { "node2" : [ 
                { 
                   "node2" : "Ford",
                    "location" : [
                       "lot"
                      ] 
                  }
               ]
           }
  
        ]

     }  
]
   {
      "node" : "New" ,
      "node1" : [
       {
         "node2" : [ 
          {
             "node2" : "Chevy",
             "location" :   [ "lot" ]
        }] 
       }  
   ]},
   
 {

      "node" : "New" ,

      "node1" : [

       {

         "node2" : [ 

          {

             "node2" : "Chevy",

             "location" :   [ "lot" ]

        }] 

       }  

   ]},
]

Answer 1

Hello @TheCoder

Your JSON look's OK.

For create Treeview from JSON. Please check below link.

[https://www.youtube.com/watch?v=f7tHyxWd_UA

Thanks

Naimish Makwana