file.json (1.2 KB) json_dt.xaml (7.2 KB) Hi team , From the attached json , I want to extract 4 values - “Description” , “Quantity” , “Unit Price” and “Line Amount” for all the json items into a datatable like below - [image] Please provide your inputs on the same . Regards, G

One of the quick options: [grafik] [grafik] [grafik] myJArray.ToObject(of DataTable) myJArray.ToObject(of DataTable).DefaultView.ToTable(False, {"Description","Quantity","Unit Price","Line Amount"})

Convert specific json data to datatable

Help Studio

Sanjit_Pal (Sanjit Pal) September 5, 2022, 1:04pm 2

Hey @gokul1904,

Have a look on this thread.

Thanks,
Sanjit

Topic		Replies	Views
Convert Json to Datatable (Specific data) Activities excel , activities , question	22	5437	September 11, 2021
How to extract the data from Json to Excel datatable Help excel	6	6941	November 3, 2018
How to create datatable from Json object? Studio studio , question , project_panel	8	4099	September 27, 2021
How to convert JSON output to DataTable? Help datatable , studio , question , json	12	1817	January 27, 2021
Deserialize json in datatable Activities excel , activities , question	5	957	March 5, 2022

Most Active Users - Yesterday
Anil_G
ashokkarale
vrdabberu
Pujitha_Ande
Ajay_Mishra
Yoichi
anjani_priya
postwick
Marisa_Ontiveros1
J0ska
More details...

Convert specific json data to datatable

Related Topics