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

ppr (Peter Preuss) September 5, 2022, 1:41pm 5

Done on the JSON String

1 Like

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

Convert specific json data to datatable

Related topics