# Converting Json array into Datatable

**URL:** <https://forum.uipath.com/t/converting-json-array-into-datatable/752311>\
**Category:** Forum\
**Tags:** forum, question\
**Created:** [July 8, 2024, 1:57pm UTC](https://forum.uipath.com/t/converting-json-array-into-datatable/752311 "2024-07-08T13:57:34Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deepak\_Rawat](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/deepak_rawat/32/513424_2.png) [@Deepak\_Rawat](https://forum.uipath.com/u/Deepak_Rawat)\
**Post date:** [July 8, 2024, 1:57pm UTC](https://forum.uipath.com/t/converting-json-array-into-datatable/752311/1 "2024-07-08T13:57:34Z")

</div>

Hi,

I want to convert Json array into datatable

TxLog: [{“MSISDN”:“96”,“Status”:“Success”,“Error Message”:“”},{“MSISDN”:“96”,“Status”:“Failed”,“Error Message”:“MSISDN”}]

---

<div class="post-metadata">

**Author:** ![vrdabberu](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/vrdabberu/32/484365_2.png) [@vrdabberu](https://forum.uipath.com/u/vrdabberu)\
**Post date:** [July 8, 2024, 2:02pm UTC](https://forum.uipath.com/t/converting-json-array-into-datatable/752311/2 "2024-07-08T14:02:58Z")

</div>

Hi @Deepak_Rawat

Check the below thread.

> [@JSON to DataTable gives System.String\[\]](https://forum.uipath.com/t/json-to-datatable-gives-system-string/503387/3):
>
> Hi, Hope the following sample will help you. [Sample20221230-1aL.zip](https://forum.uipath.com/uploads/short-url/j8OVDXFrdGkJOPoISGLufOfFaRE.zip) (3.2 KB) Regards,

This should help you.

Regards

---

<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 8, 2024, 2:25pm UTC](https://forum.uipath.com/t/converting-json-array-into-datatable/752311/3 "2024-07-08T14:25:39Z")

</div>

Hi @Deepak_Rawat

```auto
Read text file---> Output Json
Deserialize Json Array--->JsonArray
Build data table --->dt
For each JsonArray
  Add Data Row--->dt
 {currentJToken("MSISDN").ToString(),currentJToken("Status").ToString(),currentJToken("Error Message").ToString()}

Write Range Workbook

```

Please refer the below code snippets as reference

 ![image](https://global.discourse-cdn.com/uipath/original/4X/e/5/a/e5ac40a5314237a3376ef7f0edeb8392b6f931c0.png)

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

Hope it helps!!

---

<div class="post-metadata">

**Author:** ![pikorpa](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pikorpa/32/548059_2.png) [@pikorpa](https://forum.uipath.com/u/pikorpa)\
**Post date:** [July 8, 2024, 3:10pm UTC](https://forum.uipath.com/t/converting-json-array-into-datatable/752311/4 "2024-07-08T15:10:19Z")

</div>

Hey @Deepak_Rawat  
Try this solution:  
[BlankProcess130.zip](https://forum.uipath.com/uploads/short-url/qImJYKnvpXmXBUaITSwUb2nlV0k.zip) (3.5 KB)

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

---

<div class="post-metadata">

**Author:** ![ppr](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ppr/32/464097_2.png) [@ppr](https://forum.uipath.com/u/ppr)\
**Post date:** [July 8, 2024, 3:16pm UTC](https://forum.uipath.com/t/converting-json-array-into-datatable/752311/5 "2024-07-08T15:16:52Z")

</div>

> [@Deepak\_Rawat](#):
>
> TxLog: [{“MSISDN”:“96”,“Status”:“Success”,“Error Message”:“”},{“MSISDN”:“96”,“Status”:“Failed”,“Error Message”:“MSISDN”}]

lets assume TxLog is the Json String we can do

 ![grafik](https://global.discourse-cdn.com/uipath/original/4X/e/7/0/e70bf76b79a4db7cb4341387f1f7b4a223ccfe52.png)

Assign Activity  
dtData | DataType: DataTable =  
`JArray.Parse(YourJSONStringVar).ToObject(of DataTable)`

---

<div class="post-metadata">

**Author:** ![sandyarpa767](https://avatars.discourse-cdn.com/v4/letter/s/c89c15/32.png) [@sandyarpa767](https://forum.uipath.com/u/sandyarpa767)\
**Post date:** [July 8, 2024, 4:50pm UTC](https://forum.uipath.com/t/converting-json-array-into-datatable/752311/6 "2024-07-08T16:50:18Z")

</div>

Hi @Deepak_Rawat ,

1. Assign jsonString = “{”“TxLog”“:[{”“MSISDN”“:”“96"”,““Status””:““Success””,““Error Message””:“”“”},{““MSISDN””:““96"”,”“Status”“:”“Failed”“,”“Error Message”“:”“MSISDN”“}]}”

2. Deserialize JSON  
Input: jsonString  
Output: jObject

3. Assign jArray = JArray.Parse(jObject(“TxLog”).ToString)

4. Build Data Table  
Columns: MSISDN, Status, Error Message  
Output: dt

5. For Each item in jArray  
Add Data Row  
DataTable: dt  
ArrayRow: {item(“MSISDN”).ToString, item(“Status”).ToString, item(“Error Message”).ToString}

Regards  
Sandy

---

<div class="post-metadata">

**Author:** ![ppr](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ppr/32/464097_2.png) [@ppr](https://forum.uipath.com/u/ppr)\
**Post date:** [December 11, 2024, 6:16pm UTC](https://forum.uipath.com/t/converting-json-array-into-datatable/752311/7 "2024-12-11T18:16:22Z")

</div>

A post was split to a new topic: [JSON Transformation into DataTable](https://forum.uipath.com/t/json-transformation-into-datatable/785198)