Parsing Multiple (Thousands) of JSON objects from a url in Java

Question

I have to deal with multiple thousands of JSON objects that I am getting from a url in Java. I tried using the usual JSON code I have but I get the error Exception in thread "main" org.json.JSONException: A JSONObject text must begin with '{' at 2 [character 3 line 1]

Because there are no curly braces present in the JSON data only square brackets around each JSON object.

I would appreciate any help I can get with this.

BTW the code I was trying to use was the code posted in the highest answer here:simplest way to read json from a URL in java

Thanks

The end result of dealing with this data will be storing each object in its own row in a MySQL database. — user, Mar 17 '15 at 19:23
It is what I am provided with and what I am forced to use unfortunately. — user, Mar 17 '15 at 19:28
It is the JSON data provided by the MailChimp list function. It treats every individual subscriber as a new JSON object. — user, Mar 17 '15 at 19:44
Please post an example of the input here and the code you used to process it. — Chin, Mar 17 '15 at 19:49
An additional piece of information is that there is one object per line with each line being separated by \n — user, Mar 17 '15 at 19:49
Okay, So I changed to JSONArray and ` System.out.println(json.toString());` Prints the header line but I cannot use the json.get function — user, Mar 17 '15 at 20:08

score 0 · Answer 1 · answered Mar 17 '15 at 20:15

0

I have found out the correct method for handling this.

Once I treat the data as JSON Arrays it works fine. I then specify the field I want by number reference rather that name. For example: System.out.println(json.toString()); System.out.println(json.get(2));

will print the header row then print the second field of the header row.

To process the next object, I presume a loop advancing the line number on each recursion would work fine.

answered Mar 17 '15 at 20:15

user

158
6
19

So if someone could point out how to deal with the multiple arrays I would be greatful – user Mar 17 '15 at 20:21
I find it very unlikely that MailChimp would return anything but syntactically correct JSON. I think you are deserializing the JSON incorrectly. – James Newman Mar 17 '15 at 23:45
Your right, I figured it out, I was just the way I handling the data. – user Mar 19 '15 at 14:51

Parsing Multiple (Thousands) of JSON objects from a url in Java

1 Answers1