How to parse a JSON File without root element using org.json.simple?

Question

I want to parse json file "c:/employeesRecord.json" using org.json.simple library. Below is sample json data, each record is sperated by next line in the file.

{"Employees ":["A ;B ;C ;D ;E ;F"],"JobTitle":"Software Engineer"}
{"Employees ":["A ;B ;C ;D ;E ;F"],"JobTitle":"Software Engineer"}
{"Employees ":["A ;B ;C ;D ;E ;F"],"JobTitle":"Software Engineer"}
...

How to parse such json file without root element using org.json.simple.

Split your string/buffer by newline (`.split("\n")`) and parse them one by one? — SOFe, Dec 30 '16 at 14:13
For Android using Gson it is solved in [link](http://stackoverflow.com/questions/22334650/convert-json-without-root-element-to-object-using-gson-ksoap2-json-net) — Bahadar Ali, Dec 30 '16 at 14:18
You are encouraged to post your own solutions as answers to your question. — SOFe, Dec 30 '16 at 14:20
Yes my json is not valid but i need to process such files. Thanks @PEMapModder your solution works for. — Bahadar Ali, Dec 31 '16 at 12:31
Sorry @PEMapModder I cannot vote your answer. I have no such privileges. — Bahadar Ali, Dec 31 '16 at 12:33

score 3 · Answer 1 · answered Dec 30 '16 at 14:16

3

You can "tweak" the input from the file and change it into a valid json format

String json = <your json from file>
json = "[" + json + "]";
json = json.replace("\n",",");
// parse your json, now it should be a valid.

answered Dec 30 '16 at 14:16

Marcx

6,806
5
46
69

score 2 · Answer 2 · answered Dec 30 '16 at 14:12

2

Since the full file is not a valid JSON object you will need to parse it line-by-line, ie. read first line, parse it using your parser, save the result and then repeat for the next line.

answered Dec 30 '16 at 14:12

AleSod

422
3
6

score 1 · Answer 3 · answered Dec 31 '16 at 14:19

1

Parse it line by line after spliting by \n.

String[] lines = json.split("\n");
List<JsonObject> objects = new ArrayList<>(lines.length); // depending on the JSON library you are using

for(String line : lines) {
    objects.add(parseJson(line));
}

answered Dec 31 '16 at 14:19

SOFe

7,867
4
33
61

How to parse a JSON File without root element using org.json.simple?

3 Answers3

Linked