Convert Multi-Row JSON to a Datatable

[Jeff Smith - Verizon]

I have users pasting in a JSON string into a textbox for my application to process. I need to take the JSON string and process it into a datatable for further downstream processing. I develop in vb.net. An example string is shown below. The string will always have seven columns and x number of rows.

I have about 12+ hours searching google attempting to figure this out so far. I suspect I am not asking the right questions. I am familiar will creating and decoding single object JSON. Having a tough time doing anything with multiple objects. Any help here would be greatly appreciated.

Thank you!



[

{
"Id": "001",

"Event ID": 1001,

"Zip Code": "75035",

"CalcVal": "50.5%",

"City based on Zipcode": "Frisco",

"State": "TX",

"County": "Collin"

},
{
"Id": "002",

"Event ID": 1002,

"Zip Code": "75019",

"CalcVal": "50.5%",

"City based on Zipcode": "Coppell",

"State": "TX",

"County": "Dallas"

},
{
"Id": "003",

"Event ID": 1003,

"Zip Code": "75252",

"CalcVal": "50.5%",

"City based on Zipcode": "Dallas",

"State": "TX",

"County": "Dallas"

}
]

Continue reading...