Convert specific json data to datatable

Help Studio
, ,
1

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
image772×315 9.39 KB

Please provide your inputs on the same .

Regards,
G

2

Hey @gokul1904,

Have a look on this thread.

Thanks,
Sanjit

3

Hi @gokul1904

Check out this docs

Hope it will help

Regards
Gokul

4

One of the quick options:

grafik
grafik

grafik
grafik752×258 60.1 KB 

 myJArray.ToObject(of DataTable)
 myJArray.ToObject(of DataTable).DefaultView.ToTable(False, {"Description","Quantity","Unit Price","Line Amount"})
1 Like
5

Done on the JSON String

grafik
grafik770×147 42.3 KB

1 Like
6

This worked like magic.
Meanwhile just dropping another approach which I was referring to-

Thanks a lot @ppr

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.