Convert Json string into C# DataTable

Question

I am absolutely new in Json stuff, following is one of my returned JSON string from one of the Internal REST API Call:

{
   "odata.metadata":"https://ABC.XYZ.com/ERP10TESTNSSO/api/v1/Erp.BO.ABCCodeSvc/$metadata#Epicor.RestApi.ABCCodes/@Element",
   "Company":"93100",
   "ABCCode1":"A",
   "CountFreq":1,
   "ExcludeFromCC":false,
   "StockValPcnt":"0",
   "PcntTolerance":"0.00",
   "CalcPcnt":false,
   "CalcQty":false,
   "CalcValue":false,
   "QtyTolerance":"0",
   "ValueTolerance":"0",
   "ShipToCustNum":0,
   "SysRevID":"6066188743",
   "SysRowID":"5b7e2172-7f7a-445e-983d-f230e050153d",
   "BitFlag":0,
   "RowMod":""
}

Please let me know, how may I convert it into C# Data Table?

I tried following code (posted by another kind techie)

dynamic jsonObject = Newtonsoft.Json.JsonConvert.DeserializeObject(jsonContent);
DataTable dt = JsonConvert.DeserializeObject<DataTable>(Convert.ToString(jsonObject.Value));

But this code is throwing error at jsonObject.Value.

Please help me to fix it ...

Using Json.Net you can deserialize directly to a data table... However, your json only contain a single object, not a json array, so I'm not sure that deserializing it to a data table would be the correct choice here... — Zohar Peled
– Zohar Peled, Commented Aug 19, 2020 at 8:22
Every time you use dynamic some part of the world dies a sad lonely death... (with random unhelpful errors) — TheGeneral
– TheGeneral, Commented Aug 19, 2020 at 8:24
you need to do several steps, first of all, read about Json, the main problem that you have got is that dt sees columns, among other things, and you are throwing data, without naming it, it does not make any sense. Secondly, define a class where the properties are the name of the Json properties, then create the object and deserialize, I am sure that you can work out how to transform from an object to a datatable — Iria
– Iria, Commented Aug 19, 2020 at 8:25

24x7 · Accepted Answer · 2020-08-21 07:36:37Z

0

Try this:

 string json = "{\"odata.metadata\":\"https://ABC.XYZ.com/ERP10TESTNSSO/api/v1/Erp.BO.ABCCodeSvc/$metadata#Epicor.RestApi.ABCCodes/@Element\",\"Company\":\"93100\",\"ABCCode1\":\"A\",\"CountFreq\":1,\"ExcludeFromCC\":false,\"StockValPcnt\":\"0\",\"PcntTolerance\":\"0.00\",\"CalcPcnt\":false,\"CalcQty\":false,\"CalcValue\":false,\"QtyTolerance\":\"0\",\"ValueTolerance\":\"0\",\"ShipToCustNum\":0,\"SysRevID\":\"6066188743\",\"SysRowID\":\"5b7e2172-7f7a-445e-983d-f230e050153d\",\"BitFlag\":0,\"RowMod\":\"\"}";

 json = $"[{json}]";

 DataTable dt = JsonConvert.DeserializeObject<DataTable>(json);

Add [ ] in your json string.

edited Aug 21, 2020 at 7:36

24x7

53 bronze badges

answered Aug 19, 2020 at 10:05

逍遥子k

3171 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert Json string into C# DataTable

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related