Hi, I want to convert Json array into datatable TxLog: [{“MSISDN”:“96”,“Status”:“Success”,“Error Message”:“”},{“MSISDN”:“96”,“Status”:“Failed”,“Error Message”:“MSISDN”}]

Hi @Deepak_Rawat Check the below thread. [image] JSON to DataTable gives System.String[] StudioX Hi, Hope the following sample will help you. [image] Sample20221230-1aL.zip (3.2 KB) Regards, This should help you. Regards

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 refe…

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

[image] 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] Assign Activity dtData | DataType: DataTable = JArray.Parse(YourJSONStringVar).ToObject(…

Hi @Deepak_Rawat , Assign jsonString = “{”“TxLog”“:[{”“MSISDN”“:”“96"”,““Status””:““Success””,““Error Message””:“”“”},{““MSISDN””:““96"”,”“Status”“:”“Failed”“,”“Error Message”“:”“MSISDN”“}]}” Deserialize JSON Input: jsonString Output: jObject Assign jArray = JArray.Parse(jObject(“TxLog”).…

Converting Json array into Datatable

Help Forum

vrdabberu (Varunraj Dabberu) July 8, 2024, 2:02pm 2

Hi @Deepak_Rawat

Check the below thread.

This should help you.

Regards

Topic		Replies	Views
JsonArray to Datatable Studio activities , webapi	23	13960	May 12, 2023
JSON Array to DataTable Help activities , webapi	5	7063	October 21, 2020
Jsonarray to DT Activities activities , system , webapi	1	693	June 30, 2022
Json Array to data table using assign activity Studio activities , system , webapi	16	2050	December 12, 2022
Convert Dynamic JsonArray into Datatable Help excel , activities , studio , system , webapi	17	6483	July 17, 2020

Converting Json array into Datatable

Related topics