JSON: Parsing Odata Example?

Getting Started
1

I have a SAP OData JSON:

{"d":{"results":[{"__metadata":{"id":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K1')","uri":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K1')","type":"ZODATA_STORE_SRV.MatGprItm"},"Materialgroup":"Materialgroup2","Shortname":"K1","Name":"C&A K1 F/S"},{"__metadata":{"id":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K2')","uri":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K2')","type":"ZODATA_STORE_SRV.MatGprItm"},"Materialgroup":"Materialgroup2","Shortname":"K2","Name":"C&A K2 F/S"},{"__metadata":{"id":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K3')","uri":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K3')","type":"ZODATA_STORE_SRV.MatGprItm"},"Materialgroup":"Materialgroup2","Shortname":"K3","Name":"C&A K2 F/S"},{"__metadata":{"id":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K5')","uri":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K5')","type":"ZODATA_STORE_SRV.MatGprItm"},"Materialgroup":"Materialgroup2","Shortname":"K5","Name":"C&A K1 H/W"},{"__metadata":{"id":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K6')","uri":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K6')","type":"ZODATA_STORE_SRV.MatGprItm"},"Materialgroup":"Materialgroup2","Shortname":"K6","Name":"C&A K2 H/W"},{"__metadata":{"id":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K7')","uri":"http://127.0.0.1/odata/sap/http://127.0.0.1/MatGprItmSet(Materialgroup='Materialgroup2',Shortname='K7')","type":"ZODATA_STORE_SRV.MatGprItm"},"Materialgroup":"Materialgroup2","Shortname":"K7","Name":"C&A K2 H/W"}]}}

I want to get the "Shortname"s and “Names”. For example, I want to have an Dictionary with:

K1:C&A K1 F/S
K2:C&A K2 F/S
K3:C&A K2 F/S

Which is the best way to parse this image, with the goal of these Dicts?

2

Try it this way:

    dim root as new JSONItem( NAMEOFTHEJSONVARIABLE)
    dim rootItem as JSONItem = root.Value( "d" )
    dim root2Item as JSONItem = rootItem.Value( "results" )
    
    If root2Item.IsArray then
      dim c as integer = root2Item.Count
      For i As Integer = 0 to c-1
        Dim root3item as JSONItem = root2Item.Child(i)
        
        Dim nameauslesen as String = root3item.Value( "Shortname")
        
       // SAVE TO DICT
        
      Next i
    End If