How to consume Json result?

Question

0.00/5 (No votes)

See more:

VS2012

Hi,
Using VB in VS2012 and completely new to Json. Have been reading a lot of posts without finding the help I need.
I would like to read Json string below into dataset(s). I think my major problem is there are subsets within the string. The Json string is also dynamic, different results (same structure though) for different customers.
Would prefer to work in basic VB, not using third party libraries.

JavaScript

{"objectClasses":
{"objectClasses":
{"values":[
{"classId":"127","name":"h3_struct","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Mark","subClasses":false},
{"classId":"128","name":"h3_floor","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Markdel","subClasses":false},
{"classId":"110","name":"root","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"root","subClasses":false},
{"classId":"111","name":"document","parentId":"","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"Dokument","values":
[
{"classId":"116","name":"vs","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"VS","subClasses":false},
{"classId":"117","name":"ventilation","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"V","subClasses":false},
{"classId":"114","name":"mark","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"Mark","subClasses":false},
{"classId":"115","name":"konstr","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"K","subClasses":false},
{"classId":"122","name":"historisk","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"Historisk","subClasses":false},
{"classId":"113","name":"arkitekt","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"Arkitekt","subClasses":false},
{"classId":"124","name":"brand","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"Brand","subClasses":false},
{"classId":"130","name":"tekdok","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"Tek.dok","subClasses":false},
{"classId":"118","name":"el","parentId":"111","hasContent":true,"isExternalContent":false,"templateUrl":"","label":"El","subClasses":false}
]
,"subClasses":true},
{"classId":"129","name":"h3_space","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Objekt Mark","subClasses":false},
{"classId":"108","name":"space","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Rum","subClasses":false},
{"classId":"107","name":"floor","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Plan","subClasses":false},
{"classId":"105","name":"struct","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Byggnad","subClasses":false},
{"classId":"104","name":"prop","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Objekt","subClasses":false},
{"classId":"103","name":"org2grp","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Typ","subClasses":false},
{"classId":"102","name":"org3grp","parentId":"","hasContent":false,"isExternalContent":false,"templateUrl":"","label":"Kommun","subClasses":false}]},
"classFieldsList":{
"116":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doc_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"2","label":"Ritningsnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"3","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":11,"name":"hd_scale_id","seq":"4","label":"Skala","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"5","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"6","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilename","seq":"7","label":"Cadfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":18,"name":"hd_doccustom9","seq":"8","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":7}]},
"117":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doc_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"2","label":"Ritningsnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"3","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":11,"name":"hd_scale_id","seq":"4","label":"Skala","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"5","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"6","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilename","seq":"7","label":"Originalfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":18,"name":"hd_doccustom9","seq":"8","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":7}]},
"127":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2struct_name","seq":"1","label":"Mark","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_objcustom1","seq":"2","label":"Adress","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2struct_fullname","seq":"3","label":"Typ","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2struct_guid","seq":"4","label":"GUID","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]},
"114":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doc_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"2","label":"Ritningsnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"3","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":11,"name":"hd_scale_id","seq":"4","label":"Skala","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"5","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"6","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilename","seq":"7","label":"Cadfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":18,"name":"hd_doccustom9","seq":"8","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":7}]},
"115":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doc_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"2","label":"Ritningsnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"3","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":11,"name":"hd_scale_id","seq":"4","label":"Skala","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"5","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"6","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilename","seq":"7","label":"Originalfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":18,"name":"hd_doccustom9","seq":"8","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":7}]},
"128":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2spsys_name","seq":"1","label":"Markdel","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2spsys_guid","seq":"2","label":"GUID","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]},
"113":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doc_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"2","label":"Ritningsnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"3","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":11,"name":"hd_scale_id","seq":"4","label":"Skala","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"5","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"6","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilename","seq":"7","label":"Originalfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":18,"name":"hd_doccustom9","seq":"8","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":7}]},
"122":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Dictionary","isDynamicField":false,"dictId":21,"name":"hd_doccustom10","seq":"1","label":"Dok.disciplin","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doc_id","seq":"2","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"3","label":"Ritningsnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"4","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":11,"name":"hd_scale_id","seq":"5","label":"Skala","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"6","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"7","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilename","seq":"8","label":"Cadfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":18,"name":"hd_doccustom9","seq":"9","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":7}]},
"110":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"tabcaption","seq":"1","label":"Tab Caption","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"rootlabel","seq":"2","label":"Root Label","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"displayname","seq":"3","label":"Name","required":true,"isLabelField":true,"isIdField":false,"typeId":2}]},
"124":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doc_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"2","label":"Ritningsnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"3","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":11,"name":"hd_scale_id","seq":"4","label":"Skala","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"5","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"6","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilename","seq":"7","label":"Cadfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":18,"name":"hd_doccustom9","seq":"8","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":7}]},
"111":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"document_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":17,"name":"document_type_id","seq":"2","label":"Disciplin","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"3","label":"Ritnings/Dokumentnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"4","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"5","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doccustom2","seq":"7","label":"Ursprungsfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]},
"129":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2space_name","seq":"1","label":"Objektnummer","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2space_fullname","seq":"2","label":"Typ","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":7,"name":"fi2space_function","seq":"3","label":"Objekt","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"Dictionary","isDynamicField":false,"dictId":8,"name":"fi2space_status","seq":"4","label":"Obj.Typ","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2space_guid","seq":"5","label":"GUID","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]},
"118":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doc_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"2","label":"Ritningsnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"3","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":11,"name":"hd_scale_id","seq":"4","label":"Skala","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"5","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docrevdate","seq":"6","label":"Rev.datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilename","seq":"7","label":"Originalfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":18,"name":"hd_doccustom9","seq":"9","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":7}]},
"108":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2space_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2space_name","seq":"2","label":"Rum","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2space_fullname","seq":"3","label":"Benämning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_objcustom1","seq":"4","label":"Klass","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_objcustom2","seq":"5","label":"Användning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Float","isDynamicField":false,"dictId": 0,"name":"fi2space_areabra","seq":"6","label":"BRA","required":false,"isLabelField":false,"isIdField":false,"typeId":3},{"typeName":"Float","isDynamicField":false,"dictId": 0,"name":"fi2space_areabta","seq":"7","label":"BTA","required":false,"isLabelField":false,"isIdField":false,"typeId":3},{"typeName":"Float","isDynamicField":false,"dictId": 0,"name":"fi2space_areanta","seq":"8","label":"NTA","required":false,"isLabelField":false,"isIdField":false,"typeId":3},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2space_guid","seq":"9","label":"GUID","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]},
"107":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2spsys_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2spsys_name","seq":"2","label":"Plan","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2spsys_fullname","seq":"3","label":"Populärnamn","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2spsys_guid","seq":"4","label":"GUID","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]},
"105":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2struct_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2struct_name","seq":"2","label":"Byggnad","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_objcustom2","seq":"3","label":"Populärnamn","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2struct_descr","seq":"4","label":"Adress","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2struct_guid","seq":"5","label":"GUID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_objcustom1","seq":"6","label":"Nummer","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_objcustom3","seq":"7","label":"Kod","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]},
"104":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2prop_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2prop_name","seq":"2","label":"Nummer","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2prop_fullname","seq":"3","label":"Populärnamn","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2prop_descr","seq":"4","label":"Fastighetsbet.","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_objcustom1","seq":"5","label":"Bolagsnamn","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"fi2prop_guid","seq":"6","label":"GUID","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]},
"103":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"borgitm_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"borgitm_descr","seq":"2","label":"Typ","required":true,"isLabelField":true,"isIdField":false,"typeId":2}]},
"102":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"borgitm_id","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"borgitm_descr","seq":"2","label":"Namn","required":true,"isLabelField":true,"isIdField":false,"typeId":2}]},
"130":{"list":[{"typeName":"Integer","isDynamicField":false,"dictId": 0,"name":"hdid","seq":"0","label":"App ID","required":true,"isLabelField":false,"isIdField":true,"typeId":4},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docid","seq":"1","label":"ID","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docname","seq":"2","label":"Dokumentnr.","required":true,"isLabelField":true,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docdescr","seq":"3","label":"Beskrivning","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"DateTime","isDynamicField":false,"dictId": 0,"name":"hd_docdate","seq":"4","label":"Datum","required":false,"isLabelField":false,"isIdField":false,"typeId":5},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doccustom10","seq":"5","label":"Installation","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doccustom4","seq":"6","label":"Systemtillhörighet","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Dictionary","isDynamicField":false,"dictId":19,"name":"hd_opma_mgrp_id","seq":"7","label":"Huvudgrupp","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"Dictionary","isDynamicField":false,"dictId":10,"name":"hd_opma_disc_id","seq":"8","label":"Disciplin","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"Dictionary","isDynamicField":false,"dictId":20,"name":"hd_opma_sgrp_id","seq":"9","label":"Undergrupp","required":false,"isLabelField":false,"isIdField":false,"typeId":7},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_docfilname","seq":"12","label":"Originalfil","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doccustom1","seq":"13","label":"Fastighet","required":false,"isLabelField":false,"isIdField":false,"typeId":2},{"typeName":"Text","isDynamicField":false,"dictId": 0,"name":"hd_doccustom9","seq":"14","label":"Informationsklass","required":false,"isLabelField":false,"isIdField":false,"typeId":2}]}}}}

Posted 16-Aug-15 21:43pm

zi_zu

Updated 16-Aug-15 21:58pm

Andy Lanng

v3

Add a Solution

Comments

Andy Lanng 17-Aug-15 4:00am

First off: don't code dump. All we need is an example of what you are working with.
You can reduce the size of the post by adding code tags (which I have done for you).

zi_zu 17-Aug-15 4:03am

Ok, thanks.

Kornfeld Eliyahu Peter 17-Aug-15 4:04am

Are you sure you don't want to use 3rd party?
In that case you have to write a lot!
Consider to use something like JSON.NET (http://www.newtonsoft.com/json) - it will make your life much easier...

zi_zu 17-Aug-15 4:06am

Is there any licensing costs involved? I could use 3rd party library if it's the best way. For now, I try to solve this actual problem I have.

Andy Lanng 17-Aug-15 4:07am

Nope. You can get it via NuGet - I suggest it in my solution too :)

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andy Lanng · Answer 1 · 2015-08-16T22:06:00

There are many libraries for parsing JSON. I would suggest using them. There is no need to avoid 3rd Party utilities. I use Newtonsoft.Json because it came with SignalR. It is available via NuGet.

The only alternative it to parse the string yourself. To do this, I suggest you create a class that specifically deals with your Json format and deserializes the string.

UPDATE:
Newtonsoft.Json:

Here is how to use it:

Create a class for your objects in the array. Match parameter names and types with the variable names in your Json.
Create another class that has an array of the first class called "values".

Then:

VB

Dim argPoco as MyClass = JsonConvert.DeserializeObject<MyClass>(Json.ToString());

My VB is a little rusty btw ^_^

smsheethal · Answer 2 · 2015-08-16T23:02:00

Hi
I created Json as below. it is working.

using Newtonsoft.Json;

public driverDetailsBO getDriverDetails(driverDetailsBO objDriverDetailsBO)
{
string fileLocationpath = @"Cache\DriverDetails\DriverDetails_01.json";
string fileLocation = FileLocation(fileLocationpath);
string jsonText = fnReadJson(fileLocation);
driverDetailsBO objdrive = null;
if (jsonText == string.Empty)
{
jsonText = JsonConvert.SerializeObject(objDriverDetailsBO, Formatting.Indented);
jsonText = jsonText.Replace("\r\n", "");
fnCreateFile(jsonText, fileLocation);
}
else
{
objdrive =JsonConvert.DeserializeObject<driverdetailsbo>(jsonText);
}
return objdrive;
}

C#

private static string FileLocation(string fileLocation)
      {
          string path = "";
          int stindex = 0;
          int endindex = 0;
          path = System.IO.Path.GetDirectoryName(
              System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
          stindex = path.IndexOf("\\") + 1;
          endindex = path.IndexOf("bin");
          path = path.Substring(stindex, (endindex - stindex));
          fileLocation = path + fileLocation;
          return fileLocation;
      }

  public String fnReadJson(String fileLocation)
       {
           String jsonText = string.Empty;
           try
           {
               if (File.Exists(fileLocation))
               {
                   using (TextReader textReader = new StreamReader(fileLocation))
                   {
                       jsonText = textReader.ReadLine().ToString();
                   }
               }
           }
           catch { }
           return jsonText;
       }

How to consume Json result?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0