String to JSONArray giving exception because of slash in string

Question

I am trying to convert a json string to JSONArray of org.json.JSONArray class, the string contains a dateformat with forward slah, but I am getting the following exception because of the slash included in string.

public static void main(String args[]) throws JSONException{

        String jsonString = "[{ID:1, Name:Ann, DOB:14/08/1991}, {ID:2, Name:Vann, DOB:14/08/1992}]";
        JSONArray jsonArray = new JSONArray(jsonString);
        System.out.println(jsonArray.toString());
    }

Exception in thread "main" org.json.JSONException: Expected a ',' or '}' at 25 [character 26 line 1]
    at org.json.JSONTokener.syntaxError(JSONTokener.java:451)
    at org.json.JSONObject.<init>(JSONObject.java:230)
    at org.json.JSONTokener.nextValue(JSONTokener.java:380)
    at org.json.JSONArray.<init>(JSONArray.java:118)
    at org.json.JSONArray.<init>(JSONArray.java:147)
    at com.s4m.sftp.service.impl.SFTPServiceImpl.main(SFTPServiceImpl.java:1150)

As mentioned, the error is not due to the slash but an invalid json string, is that really the string that causes the error? — Joakim Danielson
– Joakim Danielson, Commented Jan 30, 2019 at 8:56
If I am using this json string [{ID:1, Name:Ann, DOB:14-08-1991}, {ID:2, Name:Vann, DOB:14-08-1992}] then it's working fine. The issue is because of the slashes. — theNoobProgrammer
– theNoobProgrammer, Commented Jan 30, 2019 at 9:02
Just to be sure: the version proposed by @DavidPérezCabrera is also not valid JSON. This is the correct JSON representation of your string in Java: String json = "[{\"ID\":1,\"Name\":\"Ann\",\"DOB\":\"14/08/1991\"}, {\"ID\":2,\"Name\":\"Vann\",\"DOB\":\"14/08/1992\"}]"; — Robby Cornelissen
– Robby Cornelissen, Commented Jan 30, 2019 at 9:10

Community · Accepted Answer · 2021-10-07 11:04:35Z

String values in JSON

Strings should be quoted... including the attribute names. See the JSON specification:

An object structure is represented as a pair of curly brackets surrounding zero or more name/value pairs (or members). A name is a string.

The representation of strings is similar to conventions used in the C family of programming languages. A string begins and ends with quotation marks.

Date values in JSON

JSON has no representation for date type. It must be represented as a string. See this answer for more information.

Online JSON validator

You can use online JSON validators to check the validity.

Valid JSON

[
   {
      "ID":1,
      "Name":"Ann",
      "DOB":"14/08/1991"
   },
   {
      "ID":2,
      "Name":"Vann",
      "DOB":"14/08/1992"
   }
]

However, I would use the format yyyy-mm-dd for date values instead of dd/mm/yyyy.

Valid JSON as Java String

String jsonString =
"[{\"ID\":1,\"Name\":\"Ann\",\"DOB\":\"14/08/1991\"},{\"ID\":2,\"Name\":\"Vann\",\"DOB\":\"14/08/1992\"}]";

Neethi P · Accepted Answer · 2019-01-30 09:13:01Z

1

Strings should be wrapped in double quotes.

try with the below JSON string

[{"ID":1, "Name":"Ann", "DOB":"14/08/1991"}, {"ID":2, "Name":"Vann", "DOB":"14/08/1992"}]

Maintain the type as string for all fields . Use toString to convert or just send an RFC 1123 date string ToString("r") to parse

answered Jan 30, 2019 at 9:13

Neethi P

94 bronze badges

Collectives™ on Stack Overflow

String to JSONArray giving exception because of slash in string

2 Answers 2

String values in JSON

Date values in JSON

Online JSON validator

Valid JSON

Valid JSON as Java String

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

String values in JSON

Date values in JSON

Online JSON validator

Valid JSON

Valid JSON as Java String

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related