How to extract the exact data from Json file

Help
5

Hi,
one possible way how to get given JSON into datatable:
1/ deserialize JSON as described by @KannanSuresh

2/ convert it into dictionary
dic = jsonObject.ToObject(of Dictionary(of string, string))

3/ build datatable using BuildDataTable activity

4/ convert dictionary into datatable
dt = (From row In dic Select dt.Rows.Add(row.Key.ToString,row.Value.ToString)).ToArray.CopyToDataTable

See also How to convert dictionary into data table with out for loop

Cheers

3 Likes