JsonArray to Datatable

Help Studio
15

@hemal
have a look on this block

"data ": [{
		"date": "09 - OCT - 2018 ",
		"initial_date": "29 - APR - 2018",
		"country": "India",
		"report": "Report",
		"id": ""
	}],

Here we do have an array. If additional element would occur then it could be the case that it comes into another structure or violate the strcture. So it has risk to disturb a fixed horizontal column structure

In such a scenario a more generic column structure is to suggest. An example could look like this:

grafik
grafik426×700 17.7 KB

so unforseen structures can be later deeper parsed as we do store the JSON string e.g.product_indication

Also this structure can be transformed into the structure of your EXCEL if the processed structure is consistent for all records

Find demo XAMl here
hemal.xaml (17.1 KB)

As I was forced to correct your JSON (it was not valid by copy and paste) run the XAML against my JSON file from here
data.json (673 Bytes)

1 Like