Converting Json array into Datatable

Help Forum
,
1

Hi,

I want to convert Json array into datatable

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

2

Hi @Deepak_Rawat

Check the below thread.

This should help you.

Regards

3

Hi @Deepak_Rawat

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
image1871×795 70.3 KB

image
image1867×761 80.2 KB

Hope it helps!!

4

Hey @Deepak_Rawat
Try this solution:
BlankProcess130.zip (3.5 KB)

image

5

lets assume TxLog is the Json String we can do

grafik
grafik313×111 12.3 KB

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

6

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

7

A post was split to a new topic: JSON Transformation into DataTable