Hi, I am using Deserialize Json activity to parse the JSON received from an API, JSON Format: FileTest.json (1.7 KB) [image] ‘Deserialize JSON’ activity output (jsonObject): [image] I’m trying to iterate each field by using “For Each”, assigning each field value to a variable… [image] [ima…

Hi, Thank you for trying. For Each and AddDataRow might be slow. I’ve rewrite the above with Invoke Code as the following. Can you try this? Sequence.xaml (10.0 KB) Note: Can you try just “run file” (not debug) If you ran debug mode, because it’s very slow. Regards,

How to convert JSON output to DataTable?

Help

Tana20 (Tana20) January 26, 2021, 5:34am 10

Thanks @Yoichi With Regex was almost the same, 14 minutes for 1000 records.

How to create datatable from Json object?

Topic		Replies	Views
How to create datatable from Json object? Studio studio , question , project_panel	8	4019	September 27, 2021
Error in Json Data Studio studio , question , project_panel	16	556	June 26, 2023
How to Convert Json Output to Datatable Learn datatable , studio , question	15	8301	February 24, 2020
Datatable with multiple rows to json Studio studio , question , activities_panel	4	1472	September 5, 2022
JSON Object / Arrays - To datatable Activities activities , web , question	2	747	January 20, 2022

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

How to convert JSON output to DataTable?

Related Topics