Click here to Skip to main content
15,888,401 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I am struggling to create classes for this JSON response from a service in VB.NET. All help is very much apreciate.

VB
{"response":[[{"type":"picking","picking":[{"employee":"Employee 8","order":1,"line":2,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":17,"line":31,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":21,"line":102,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":33,"line":152,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":4,"line":5,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":56,"line":159,"mins":0,"o/h":0,"l/h":0}],"recordcount":6,"freq":"today"},{"type":"picking","picking":[{"employee":"Employee 8","order":1,"line":2,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":17,"line":118,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":2,"line":2,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":34,"line":122,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":34,"line":205,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":5,"line":10,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":66,"line":277,"mins":0,"o/h":0,"l/h":0}],"recordcount":7,"freq":"yesterday"},{"type":"picking","picking":[{"employee":"Employee 5","order":10,"line":19,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":120,"line":377,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":142,"line":538,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":2,"line":4,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":5,"line":10,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":58,"line":289,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":6,"line":30,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":89,"line":560,"mins":0,"o/h":0,"l/h":0}],"recordcount":8,"freq":"thisweek"},{"type":"picking","picking":[{"employee":"Employee 6","order":12,"line":71,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":120,"line":736,"mins":990,"o/h":7.27,"l/h":44.61},{"employee":"Employee 5","order":14,"line":21,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":145,"line":787,"mins":675,"o/h":12.89,"l/h":69.96},{"employee":"Employee 4","order":19,"line":49,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":307,"line":1074,"mins":510,"o/h":36.12,"l/h":126.35},{"employee":"Employee 1","order":4,"line":5,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":55,"line":194,"mins":120,"o/h":27.5,"l/h":97},{"employee":"Employee 7","order":71,"line":265,"mins":450,"o/h":9.47,"l/h":35.33}],"recordcount":9,"freq":"lastweek"},{"type":"picking","picking":[{"employee":"Employee 1","order":1,"line":2,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":115,"line":749,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":131,"line":691,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":14,"line":34,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":14,"line":23,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":14,"line":88,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":149,"line":563,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":24,"line":87,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":264,"line":903,"mins":0,"o/h":0,"l/h":0}],"recordcount":9,"freq":"thismonth"},{"type":"picking","picking":[{"employee":"Employee 7","order":110,"line":393,"mins":1800,"o/h":3.67,"l/h":13.1},{"employee":"Employee 10","order":12,"line":56,"mins":30,"o/h":24,"l/h":112},{"employee":"Labour H / Casual","order":151,"line":447,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 1","order":17,"line":33,"mins":45,"o/h":22.67,"l/h":44},{"employee":"Employee 11","order":19,"line":40,"mins":45,"o/h":25.33,"l/h":53.33},{"employee":"Employee 4","order":19,"line":41,"mins":30,"o/h":38,"l/h":82},{"employee":"Employee 8","order":207,"line":716,"mins":360,"o/h":34.5,"l/h":119.33},{"employee":"Employee 6","order":21,"line":107,"mins":0,"o/h":0,"l/h":0},{"employee":"Jonathan Matilainen","order":261,"line":1431,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":557,"line":2908,"mins":2300,"o/h":14.53,"l/h":75.86},{"employee":"Employee 2","order":648,"line":3124,"mins":2970,"o/h":13.09,"l/h":63.11},{"employee":"Employee 5","order":70,"line":126,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":807,"line":2688,"mins":2650,"o/h":18.27,"l/h":60.86}],"recordcount":13,"freq":"lastmonth"},{"type":"picking","picking":[{"employee":"Employee 3","order":1020,"line":5402,"mins":2300,"o/h":26.61,"l/h":140.92},{"employee":"Employee 2","order":1045,"line":4901,"mins":2970,"o/h":21.11,"l/h":99.01},{"employee":"Employee 5","order":120,"line":204,"mins":0,"o/h":0,"l/h":0},{"employee":"Labour H / Casual","order":153,"line":477,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":1806,"line":5981,"mins":2650,"o/h":40.89,"l/h":135.42},{"employee":"Employee 10","order":22,"line":96,"mins":30,"o/h":44,"l/h":192},{"employee":"Employee 7","order":259,"line":956,"mins":1800,"o/h":8.63,"l/h":31.87},{"employee":"Employee 8","order":353,"line":1300,"mins":360,"o/h":58.83,"l/h":216.67},{"employee":"Employee 6","order":38,"line":198,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 1","order":45,"line":80,"mins":45,"o/h":60,"l/h":106.67},{"employee":"Jonathan Matilainen","order":488,"line":2827,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":54,"line":142,"mins":30,"o/h":108,"l/h":284},{"employee":"Employee 11","order":83,"line":239,"mins":45,"o/h":110.67,"l/h":318.67}],"recordcount":13,"freq":"thisyear"},{"type":"checking","checking":[{"employee":"Employee 3","order":1,"line":1,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":1,"line":12,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":18,"line":62,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":27,"line":105,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":4,"line":5,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":5,"line":10,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":76,"line":256,"mins":0,"o/h":0,"l/h":0}],"recordcount":7,"freq":"today"},{"type":"checking","checking":[{"employee":"Employee 11","order":1,"line":1,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":3,"line":16,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":3,"line":7,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":38,"line":213,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":40,"line":152,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":74,"line":347,"mins":0,"o/h":0,"l/h":0}],"recordcount":6,"freq":"yesterday"},{"type":"checking","checking":[{"employee":"Employee 5","order":10,"line":20,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":100,"line":406,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":122,"line":443,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":13,"line":134,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":169,"line":744,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":3,"line":30,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":7,"line":14,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":8,"line":36,"mins":0,"o/h":0,"l/h":0}],"recordcount":8,"freq":"thisweek"},{"type":"checking","checking":[{"employee":"Employee 1","order":1,"line":1,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":11,"line":13,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":112,"line":399,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":119,"line":492,"mins":510,"o/h":14,"l/h":57.88},{"employee":"Employee 4","order":163,"line":728,"mins":60,"o/h":163,"l/h":728},{"employee":"Employee 11","order":21,"line":48,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":267,"line":1251,"mins":920,"o/h":17.41,"l/h":81.59},{"employee":"Employee 2","order":4,"line":19,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":4,"line":33,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":45,"line":218,"mins":385,"o/h":7.01,"l/h":33.97}],"recordcount":10,"freq":"lastweek"},{"type":"checking","checking":[{"employee":"Employee 11","order":13,"line":27,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":134,"line":499,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":14,"line":26,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":172,"line":738,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":275,"line":1281,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":3,"line":15,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":3,"line":30,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":31,"line":206,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":81,"line":318,"mins":0,"o/h":0,"l/h":0}],"recordcount":9,"freq":"thismonth"},{"type":"checking","checking":[{"employee":"Jonathan Matilainen","order":113,"line":586,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":209,"line":771,"mins":1515,"o/h":8.28,"l/h":30.53},{"employee":"Employee 10","order":3,"line":14,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":39,"line":117,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":5,"line":31,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":57,"line":93,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":590,"line":2328,"mins":1765,"o/h":20.06,"l/h":79.14},{"employee":"Employee 1","order":6,"line":12,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":876,"line":3899,"mins":980,"o/h":53.63,"l/h":238.71},{"employee":"Employee 8","order":893,"line":3715,"mins":3500,"o/h":15.31,"l/h":63.69},{"employee":"Employee 6","order":9,"line":74,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":99,"line":470,"mins":1890,"o/h":3.14,"l/h":14.92}],"recordcount":12,"freq":"lastmonth"},{"type":"checking","checking":[{"employee":"Employee 1","order":10,"line":29,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":103,"line":161,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":120,"line":435,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":13,"line":173,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":1305,"line":5844,"mins":980,"o/h":79.9,"l/h":357.8},{"employee":"Employee 4","order":1320,"line":5289,"mins":1765,"o/h":44.87,"l/h":179.8},{"employee":"Employee 8","order":1597,"line":6545,"mins":3500,"o/h":27.38,"l/h":112.2},{"employee":"Jonathan Matilainen","order":166,"line":878,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":189,"line":1209,"mins":1890,"o/h":6,"l/h":38.38},{"employee":"Employee 2","order":42,"line":155,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":612,"line":2047,"mins":1515,"o/h":24.24,"l/h":81.07},{"employee":"Employee 10","order":9,"line":38,"mins":0,"o/h":0,"l/h":0}],"recordcount":12,"freq":"thisyear"},{"type":"packing","packing":[{"employee":"Employee 8","order":43,"line":172,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":1,"line":12,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":4,"line":5,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":10,"line":37,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":74,"line":225,"mins":0,"o/h":0,"l/h":0}],"recordcount":5,"freq":"today"},{"type":"packing","packing":[{"employee":"Employee 3","order":2,"line":31,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":86,"line":391,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":1,"line":1,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":1,"line":2,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":2,"line":2,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":14,"line":90,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":48,"line":193,"mins":0,"o/h":0,"l/h":0},{"employee":"Labour H / Casual","order":5,"line":26,"mins":0,"o/h":0,"l/h":0}],"recordcount":8,"freq":"yesterday"},{"type":"packing","packing":[{"employee":"Employee 3","order":16,"line":161,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":231,"line":939,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":1,"line":1,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":1,"line":2,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":3,"line":30,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":16,"line":70,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":9,"line":15,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":24,"line":127,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":126,"line":456,"mins":0,"o/h":0,"l/h":0},{"employee":"Labour H / Casual","order":5,"line":26,"mins":0,"o/h":0,"l/h":0}],"recordcount":10,"freq":"thisweek"},{"type":"packing","packing":[{"employee":"Employee 3","order":35,"line":216,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":102,"line":605,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":14,"line":23,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":8,"line":64,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":3,"line":10,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":382,"line":1493,"mins":450,"o/h":50.93,"l/h":199.07},{"employee":"Employee 5","order":10,"line":10,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":86,"line":358,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":107,"line":423,"mins":0,"o/h":0,"l/h":0}],"recordcount":9,"freq":"lastweek"},{"type":"packing","packing":[{"employee":"Employee 3","order":21,"line":207,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":267,"line":1167,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":6,"line":8,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":7,"line":51,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":3,"line":30,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":221,"line":881,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":12,"line":18,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":57,"line":295,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":127,"line":457,"mins":0,"o/h":0,"l/h":0},{"employee":"Labour H / Casual","order":5,"line":26,"mins":0,"o/h":0,"l/h":0}],"recordcount":10,"freq":"thismonth"},{"type":"packing","packing":[{"employee":"Employee 3","order":129,"line":870,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":1154,"line":4790,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":137,"line":405,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 10","order":4,"line":33,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":5,"line":27,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":8,"line":51,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":177,"line":682,"mins":450,"o/h":23.6,"l/h":90.93},{"employee":"Employee 5","order":57,"line":94,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":396,"line":1593,"mins":0,"o/h":0,"l/h":0},{"employee":"Jonathan Matilainen","order":121,"line":555,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":711,"line":3010,"mins":0,"o/h":0,"l/h":0}],"recordcount":11,"freq":"lastmonth"},{"type":"packing","packing":[{"employee":"Employee 3","order":194,"line":1526,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":2190,"line":9019,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":619,"line":1938,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 10","order":5,"line":35,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":102,"line":513,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":11,"line":81,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":398,"line":1563,"mins":450,"o/h":53.07,"l/h":208.4},{"employee":"Employee 1","order":1,"line":3,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":103,"line":172,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":734,"line":3032,"mins":0,"o/h":0,"l/h":0},{"employee":"Jonathan Matilainen","order":130,"line":632,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":989,"line":4242,"mins":0,"o/h":0,"l/h":0},{"employee":"Labour H / Casual","order":10,"line":47,"mins":0,"o/h":0,"l/h":0}],"recordcount":13,"freq":"thisyear"},{"type":"shipping","shipping":[{"employee":"Employee 11","order":127,"line":443,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":2,"line":4,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":3,"line":4,"mins":0,"o/h":0,"l/h":0}],"recordcount":3,"freq":"today"},{"type":"shipping","shipping":[{"employee":"Employee 4","order":13,"line":75,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":146,"line":661,"mins":0,"o/h":0,"l/h":0}],"recordcount":2,"freq":"yesterday"},{"type":"shipping","shipping":[{"employee":"Employee 4","order":15,"line":79,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":2,"line":18,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":403,"line":1693,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":6,"line":12,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":6,"line":25,"mins":0,"o/h":0,"l/h":0}],"recordcount":5,"freq":"thisweek"},{"type":"shipping","shipping":[{"employee":"Employee 3","order":1,"line":4,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":10,"line":41,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":10,"line":10,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":11,"line":68,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":2,"line":3,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":22,"line":80,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":691,"line":2996,"mins":1065,"o/h":38.93,"l/h":168.79}],"recordcount":7,"freq":"lastweek"},{"type":"shipping","shipping":[{"employee":"Employee 3","order":1,"line":4,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":16,"line":66,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":2,"line":18,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":26,"line":147,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":672,"line":2890,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":9,"line":15,"mins":0,"o/h":0,"l/h":0}],"recordcount":6,"freq":"thismonth"},{"type":"shipping","shipping":[{"employee":"Employee 9","order":1,"line":3,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":2597,"line":10990,"mins":2595,"o/h":60.05,"l/h":254.1},{"employee":"Employee 2","order":44,"line":141,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 8","order":48,"line":156,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":53,"line":65,"mins":0,"o/h":0,"l/h":0},{"employee":"Labour H / Casual","order":57,"line":197,"mins":0,"o/h":0,"l/h":0},{"employee":"Jonathan Matilainen","order":6,"line":61,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":6,"line":46,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":79,"line":401,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 6","order":8,"line":50,"mins":0,"o/h":0,"l/h":0}],"recordcount":10,"freq":"lastmonth"},{"type":"shipping","shipping":[{"employee":"Employee 6","order":10,"line":68,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 4","order":135,"line":683,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 7","order":16,"line":66,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 2","order":264,"line":1109,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 9","order":3,"line":12,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 11","order":4842,"line":20267,"mins":2595,"o/h":111.95,"l/h":468.6},{"employee":"Employee 8","order":51,"line":163,"mins":0,"o/h":0,"l/h":0},{"employee":"Labour H / Casual","order":57,"line":197,"mins":0,"o/h":0,"l/h":0},{"employee":"Jonathan Matilainen","order":7,"line":62,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 3","order":9,"line":58,"mins":0,"o/h":0,"l/h":0},{"employee":"Employee 5","order":92,"line":118,"mins":0,"o/h":0,"l/h":0}],"recordcount":11,"freq":"thisyear"},{"type":"inbound","inbound":[{"employee":"team","order":15,"line":52,"mins":0,"o/h":0,"l/h":0}],"recordcount":1,"freq":"today"},{"type":"inbound","inbound":[{"employee":"team","order":8,"line":56,"mins":0,"o/h":0,"l/h":0}],"recordcount":1,"freq":"yesterday"},{"type":"inbound","inbound":[{"employee":"team","order":41,"line":173,"mins":0,"o/h":0,"l/h":0}],"recordcount":1,"freq":"thisweek"},{"type":"inbound","inbound":[{"employee":"team","order":43,"line":272,"mins":1895,"o/h":1.36,"l/h":8.61}],"recordcount":1,"freq":"lastweek"},{"type":"inbound","inbound":[{"employee":"team","order":59,"line":247,"mins":0,"o/h":0,"l/h":0}],"recordcount":1,"freq":"thismonth"},{"type":"inbound","inbound":[{"employee":"team","order":253,"line":1107,"mins":6205,"o/h":2.45,"l/h":10.7}],"recordcount":1,"freq":"lastmonth"},{"type":"inbound","inbound":[{"employee":"team","order":492,"line":2304,"mins":6205,"o/h":4.76,"l/h":22.28}],"recordcount":1,"freq":"thisyear"},{"return":null,"recordcount":0},{"type":"return","return":[{"employee":"team","order":10,"line":22,"mins":0,"o/h":0,"l/h":0}],"recordcount":1,"freq":"yesterday"},{"type":"return","return":[{"employee":"team","order":12,"line":25,"mins":0,"o/h":0,"l/h":0}],"recordcount":1,"freq":"thisweek"},{"type":"return","return":[{"employee":"team","order":18,"line":56,"mins":390,"o/h":2.77,"l/h":8.62}],"recordcount":1,"freq":"lastweek"},{"type":"return","return":[{"employee":"team","order":12,"line":25,"mins":0,"o/h":0,"l/h":0}],"recordcount":1,"freq":"thismonth"},{"type":"return","return":[{"employee":"team","order":85,"line":152,"mins":1170,"o/h":4.36,"l/h":7.79}],"recordcount":1,"freq":"lastmonth"},{"type":"return","return":[{"employee":"team","order":121,"line":208,"mins":1170,"o/h":6.21,"l/h":10.67}],"recordcount":1,"freq":"thisyear"}]]}


What I have tried:

I have tried using quicktype to crate the classes in C# and then convert them using convert.net to convert the code to VB.


VB
Namespace NetSuiteKPI


    Public Class NetsuiteKpi
        Public Property Response() As List(Of List(Of Response))
            Get
                Return m_Response
            End Get
            Set
                m_Response = Value
            End Set
        End Property
        Private m_Response As List(Of List(Of Response))
    End Class

    Public Class Response
        Public Property Type() As String
            Get
                Return m_Type
            End Get
            Set
                m_Type = Value
            End Set
        End Property
        Private m_Type As String
        Public Property Picking() As List(Of Checking)
            Get
                Return m_Picking
            End Get
            Set
                m_Picking = Value
            End Set
        End Property
        Private m_Picking As List(Of Checking)
        Public Property Recordcount() As Long
            Get
                Return m_Recordcount
            End Get
            Set
                m_Recordcount = Value
            End Set
        End Property
        Private m_Recordcount As Long
        Public Property Freq() As String
            Get
                Return m_Freq
            End Get
            Set
                m_Freq = Value
            End Set
        End Property
        Private m_Freq As String
        Public Property Checking() As List(Of Checking)
            Get
                Return m_Checking
            End Get
            Set
                m_Checking = Value
            End Set
        End Property
        Private m_Checking As List(Of Checking)
        Public Property Packing() As List(Of Checking)
            Get
                Return m_Packing
            End Get
            Set
                m_Packing = Value
            End Set
        End Property
        Private m_Packing As List(Of Checking)
        Public Property Shipping() As List(Of Checking)
            Get
                Return m_Shipping
            End Get
            Set
                m_Shipping = Value
            End Set
        End Property
        Private m_Shipping As List(Of Checking)
        Public Property Inbound() As List(Of Checking)
            Get
                Return m_Inbound
            End Get
            Set
                m_Inbound = Value
            End Set
        End Property
        Private m_Inbound As List(Of Checking)
        Public Property [Return]() As List(Of Checking)
            Get
                Return m_Return
            End Get
            Set
                m_Return = Value
            End Set
        End Property
        Private m_Return As List(Of Checking)
    End Class

    Public Class Checking
        Public Property Employee() As String
            Get
                Return m_Employee
            End Get
            Set
                m_Employee = Value
            End Set
        End Property
        Private m_Employee As String
        Public Property Order() As Long
            Get
                Return m_Order
            End Get
            Set
                m_Order = Value
            End Set
        End Property
        Private m_Order As Long
        Public Property Line() As Long
            Get
                Return m_Line
            End Get
            Set
                m_Line = Value
            End Set
        End Property
        Private m_Line As Long
        Public Property Mins() As Long
            Get
                Return m_Mins
            End Get
            Set
                m_Mins = Value
            End Set
        End Property
        Private m_Mins As Long
        Public Property OH() As Double
            Get
                Return m_OH
            End Get
            Set
                m_OH = Value
            End Set
        End Property
        Private m_OH As Double
        Public Property LH() As Double
            Get
                Return m_LH
            End Get
            Set
                m_LH = Value
            End Set
        End Property
        Private m_LH As Double
    End Class
End Namespace
Posted
Updated 12-Mar-18 12:40pm
v2

There's a functionality in Visual Studio which enables you to copy JSON data as classes.

Steps to do:
1. Copy JSON data
2. In Visual Studio: Menu Edit -> Paste Special -> Paste JSON as Classes


Another way is to use on-line converter (generates c# classes): Instantly parse JSON in any language | quicktype[^]

That's all!
 
Share this answer
 
v2
Comments
JANeets 12-Mar-18 16:23pm    
Thanks Maciej Los,
I have tried your first solution but the resulting class structure still throw an error an when using JSON.NET.
and your second solution using quick type is how i generated the class structure that i included in my question.
Regards,
Joel
Used Instantly parse JSON in any language | quicktype[^] to crate the class structure in C# and then used Tangable Software Solutions Instant VB converter to convert the C# to VB.

thanks to Maciej Los for your response as it was what prompted me to go looking for a solution to better convert the C# output of Quicktype.

Regards,
Joel
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900