Headers are only appearing from JSON file in Adhoc view

[youngsimon]

Hi hope you can help!

I'm new to json files but want to add a file into jasper server like below.

[
 {
   "lowest": "Abu Dhabi",
   "lev1": "TOPLEVEL",
   "lev2": "Europe Middle East and Africa and Aus Group",
   "lev3": "Middle East and Africa Division",
   "lev4": "Abu Dhabi",
   "lev5": "Unknown",
   "lev6": "Unknown"
 }
]

When I add this as a json file as per instructions into jasper server and create an adhoc view, I only see the column heading an no data.

Also what is the correct json file language to use for the type of file above?

JSON
json2.js
json_parse.js
json_parse_state.js
cycle.js

we are using Jasper Server Professional and version 6.3.2

your help appreciated