# Deserialize Json to DataTable error

**URL:** <https://forum.uipath.com/t/deserialize-json-to-datatable-error/754760>\
**Category:** Activities\
**Tags:** web, webapi, activities\
**Created:** [July 19, 2024, 5:21am UTC](https://forum.uipath.com/t/deserialize-json-to-datatable-error/754760 "2024-07-19T05:21:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ecosy6065](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ecosy6065/32/491012_2.png) [@ecosy6065](https://forum.uipath.com/u/ecosy6065)\
**Post date:** [July 19, 2024, 5:21am UTC](https://forum.uipath.com/t/deserialize-json-to-datatable-error/754760/1 "2024-07-19T05:21:48Z")

</div>

Hi, I’ve been trying to deserialize json into a datatable, but it’s still not working out. My json data is as below.

{  
“result”: {  
“list”: [  
{  
“atclNo”: “2435400759”,  
“vrfcTpCd”: “OWNER”,  
“atclNm”: “서신광진”,  
“bildNm”: “106동”,  
“tradTpNm”: “매매”,  
“spc1”: “74.82”,  
“spc2”: “59.98”,  
“flrInfo”: “15/15”,  
“atclFetrDesc”: “부분리모델링.빠른입주가능”,  
“cfmYmd”: “24.07.18”,  
“prcInfo”: “1억 2,300”,  
“sameAddrCnt”: 7,  
“sameAddrDirectCnt”: 0,  
“sameAddrMaxPrc”: “1억 2,300”,  
“sameAddrMinPrc”: “1억 2,300”,  
“tradCmplYn”: “N”,  
“atclStatCd”: “R0”,  
“cpid”: “bizmk”,  
“cpCnt”: 2,  
“rltrNm”: “광진부동산공인중개사사무소”,  
“direction”: “남향”,  
},  
{  
“atclNo”: “2435304824”,  
“vrfcTpCd”: “OWNER”,  
“atclNm”: “서신광진”,  
“bildNm”: “106동”,  
“tradTpNm”: “매매”,  
“spc1”: “74.82”,  
“spc2”: “59.98”,  
“flrInfo”: “2/15”,  
“atclFetrDesc”: “샤시포함 부분 리모델링됨, 세입자 승계나 24년 4월 입주, 편하게 연락”,  
“cfmYmd”: “24.07.18”,  
“prcInfo”: “1억 4,500”,  
“sameAddrCnt”: 6,  
“sameAddrDirectCnt”: 0,  
“sameAddrMaxPrc”: “1억 4,500”,  
“sameAddrMinPrc”: “1억 4,000”,  
“rltrNm”: “원탑공인중개사사무소”,  
“direction”: “동향”,  
}

I want to make the array data in the ‘list’ into a data table and store it in Excel. Perhaps because the ‘list’ is in the ‘result’, if you specify the value of dt as “Newtonsoft.Json.JsonConvert.DeserializeObject(jsonarray.ToString())” as an asset, the error continues.

---

<div class="post-metadata">

**Author:** ![mkankatala](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/mkankatala/32/484097_2.png) [@mkankatala](https://forum.uipath.com/u/mkankatala)\
**Post date:** [July 19, 2024, 5:25am UTC](https://forum.uipath.com/t/deserialize-json-to-datatable-error/754760/2 "2024-07-19T05:25:59Z")

</div>

Hi @ecosy6065

Can you refer the below thread,

> [@API Json response to datatable](https://forum.uipath.com/t/api-json-response-to-datatable/573083/3):
>
> Deserialize the JSON with: [grafik] output: myJObject | TypeArgument: JObject then we can convert this JObject to a DataTable by: myDataTable = Newtonsoft.Json.Linq.JArray.FromObject(new JObject(){myJObject}).ToObject(Of DataTable)

Hope it helps!!

---

<div class="post-metadata">

**Author:** ![pravallikapaluri](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pravallikapaluri/32/484755_2.png) [@pravallikapaluri](https://forum.uipath.com/u/pravallikapaluri)\
**Post date:** [July 19, 2024, 5:35am UTC](https://forum.uipath.com/t/deserialize-json-to-datatable-error/754760/3 "2024-07-19T05:35:47Z")

</div>

Hi @ecosy6065

```auto
1. Read Text File
   - FilePath: "path_to_your_json_file"
   - Output: jsonString (String)

2. Deserialize JSON
   - Input: jsonString
   - Output: jsonObject (JObject)

3. Assign
   - jsonArray = jsonObject("result")("list").ToString()

4. Assign
   -dataTable = JsonConvert.DeserializeObject(Of DataTable)(jsonArray)

6. Write Range
   - Input: dataTable
   - Destination: "path_to_your_excel_file"

```

 ![image](https://global.discourse-cdn.com/uipath/original/4X/c/d/d/cdd73b2cd02659b189586e0469908914167c65ab.png)

 ![image](https://global.discourse-cdn.com/uipath/original/4X/9/f/4/9f407c85dee6c07a1345df8fa1e040c1708243f5.png)

OutPut

 ![image](https://global.discourse-cdn.com/uipath/original/4X/b/a/d/bad304a2cd6431bf14f30c396bfc35de78af7911.png)

Json

```auto
{
  "result": {
    "list": [
      {
        "atclNo": "2435400759",
        "vrfcTpCd": "OWNER",
        "atclNm": "서신광진",
        "bildNm": "106동",
        "tradTpNm": "매매",
        "spc1": "74.82",
        "spc2": "59.98",
        "flrInfo": "15/15",
        "atclFetrDesc": "부분리모델링.빠른입주가능",
        "cfmYmd": "24.07.18",
        "prcInfo": "1억 2,300",
        "sameAddrCnt": 7,
        "sameAddrDirectCnt": 0,
        "sameAddrMaxPrc": "1억 2,300",
        "sameAddrMinPrc": "1억 2,300",
        "tradCmplYn": "N",
        "atclStatCd": "R0",
        "cpid": "bizmk",
        "cpCnt": 2,
        "rltrNm": "광진부동산공인중개사사무소",
        "direction": "남향"
      },
      {
        "atclNo": "2435304824",
        "vrfcTpCd": "OWNER",
        "atclNm": "서신광진",
        "bildNm": "106동",
        "tradTpNm": "매매",
        "spc1": "74.82",
        "spc2": "59.98",
        "flrInfo": "2/15",
        "atclFetrDesc": "샤시포함 부분 리모델링됨, 세입자 승계나 24년 4월 입주, 편하게 연락",
        "cfmYmd": "24.07.18",
        "prcInfo": "1억 4,500",
        "sameAddrCnt": 6,
        "sameAddrDirectCnt": 0,
        "sameAddrMaxPrc": "1억 4,500",
        "sameAddrMinPrc": "1억 4,000",
        "rltrNm": "원탑공인중개사사무소",
        "direction": "동향"
      }
    ]
  }
}

```

Hope it helps!!
