Convert specific json data to datatable

[gokul1904 (Glory 01)]

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 -

Please provide your inputs on the same .

Regards,
G

[Sanjit_Pal]

Hey @gokul1904,

Have a look on this thread.

Convert Json to Datatable (Specific data)

Hi Everyone, I have a json file i want to convert that json data into excel data. I’m unable to extract few details. Can anyone help me how to solve this. I’m attaching json file and my required output below. DOC042319-04232019125916.1.1.json (3.4 KB) O/P: Id: 0001 Left: 303 Right: 819 Top: 520 Bottom: 561 Id: 0002 Left: 954 Right: 1081 Top: 518 Bottom: 563 Etc… I need all id’s data , in excel sheet

Thanks,
Sanjit

[Gokul001 (Gokul Balaji)]

Hi @gokul1904

Check out this docs

How to Convert JSON data to DataTable UiPath - RPA Learners

Hope it will help

Regards
Gokul

[ppr (Peter)]

One of the quick options:

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

[ppr (Peter)]

Done on the JSON String

[gokul1904 (Glory 01)]

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

How to convert JSON output to DataTable?

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] [image] … and finally, send each variable to the Data Table: [image] But the “For Each” activity fails, [image] Debugging, I found this in JsonObject…so I guess I’m using the wrong format to retrieve…

Thanks a lot @ppr