How to Convert Datatable into Json object

[Ranjan (Ranjan Thakur)]

Hi

Is any Activity in UIPath which will convert Datatable into Json object ? Do you have any reference or example which shows datatable conversion into Json objects.

Thanks,
Ranjan

[vvaidya (Vinay Vaidya)]

Did you try JsonConvert.SerializeObject(DataTable)

[andrzej.kniola (Andrzej Knioła)]

This should work.

Do note that DataTable and JSON serialization have corner cases that don’t play nice with each other (deseriaized schema is completely based on first row).

[fabionj (Fabio Jacob)]

I couldnt get this to work. Could anyone assist with examples on how to convert a DATA TABLE to JSON? Or even CSV to JSON in UIPATH?

Thank!

[vvaidya (Vinay Vaidya)]

Whats the best way to convert CSV to JSON (2-way)?

csv-json.xaml (6.7 KB)

[bfish]

There is a bug when first trying to use the JsonConvert.SerializeObject. The function reads as an error until you create a variable of type JsonConvert. You can delete the variable afterward.

[Yusuf_Mansuri]

@vvaidya Can you please help me how to convert word file into Json.

I am very new to UIPATH please help me.

[negret (George Negret)]

thanks

[sanjay21051990 (sanjay shankhla)]

Hi @Ranjan,

Here you go below Are some Operation being Performed:-

1. Convert Text File To into Formatted Excel Data Column
2. Read the the Formatted DataTable and Convert to JSON

Attached the Sample Script:-

JSON_TO_DataTable.zip (26.4 KB)

Note:Require To Import NameSpaces

1.Microsoft.Office.Interop.Excel
2.Microsoft.Office.Tools.Excel

Below are The Sample ScreenShots:-

1.Raw Data

2. FormattedExcel

3.Final JSON Result

Regards
Sanjay Shankhla

[Cristian_Negulescu]

Hello Ranjan,
In this video I do a lot of stuff with JSON (Chapter included) :

15:55 Datatable to JSON
17:50 JSON to Datatable

UiPath Tutorial for JSON Parsing and Creation | 8 UseCase

Thanks,
Cristian Negulescu

[webhelprparobot2 (Robotix)]

Hi Mate,

I saw your suggestion for datatable to json string convert.

I have json format like this, how can ı turn it with Invoke Code with your method.

I tried json.searilize method but the result like this ;

[{“task_id”:509.0,“tesvik_isim”:“55ON”,“status”:“Teşvikten Yararlanabilirsiniz”,“tesvik_tutari”:“178,88 TL”,“aciklama”:“Kazanç :3.577,50 TL”}

I need it like this ;

[{“task_id”:“509”,“tesvik_isim”:“55ON”,“status”:“Teşvikten Yararlanabilirsiniz”,“tesvik_tutari”:“178,88 TL”,“aciklama”:“Kazanç :3.577,50 TL”}

Need to change 509.0 to “509” how can ı do that ?

Could you please help me about it?