Convert JSON array to Java Class Object List

Question

I have a JSON string that comes from a WFC service. When I try to convert JSON array into List object, I've got the following error :

".JsonMappingException: Can not deserialize instance of java.util.ArrayList out of START_OBJECT token at [Source: java.io.StringReader@41f27f18; line: 1, column: 1]"

The Java class (Card Class):

public class Card {
    public String ID;
    public String CompanyID;
    public String CompanyName;
    public String FiscalCode;
    public String Limit;
    public String StateID;
    public String CardState;
    public String Deleted;
    public String Sold;
    public String StartDate;
    public String InvoiceStartDate;
    public String Quantity;
    public String Value;
    public String CardTypeID;
    public String CardType;
    public String SoldChanged;
    public String DriverName;
    public String VehiclePlateNumber;
    public String VehicleID;
    public String Discount;
    public String ContractID;
    public String DiscountPerMonth;
    public String ProductID;
    public String ProductStateID;
    public String Mail;
    public String WithoutLimit;
    public String ContractSold;
    public String ContractLimit;
    public String NumberOfTransactions;
    public String DriverNameOnly;
    public String DriverSurnameOnly;
}

The Java code to deserialize :

strResponse = responseHandler.handleResponse(response);
if (strResponse.contains("Credit") || strResponse.contains("Debit")) {
    ObjectMapper mapper = new ObjectMapper();
    strResponse= strResponse.replace("\"GetCardsResult\":", "");
    userCards = mapper.readValue(strResponse, mapper.getTypeFactory().constructCollectionType(List.class, Card.class));
}

The JSON string:

{     "GetCardsResult":"[{\"ID\":3,\"CompanyID\":1155,\"CompanyName\":\"test\",\"FiscalCode\":null,\"Code\":\"1423127205\",\"Limit\":0.000,\"StateID\":1,\"CardState\":\"Activ\",\"Deleted\":false,\"Sold\":0.000,\"StartDate\":\"\/Date(1412974800000+0300)\/\",\"InvoiceStartDate\":\"\/Date(-62135596800000+0200)\/\",\"Quantity\":null,\"Value\":0.0,\"CardTypeID\":1,\"CardType\":\"Credit\",\"SoldChanged\":false,\"DriverName\":\"\",\"VehiclePlateNumber\":\"B 222 ART\",\"VehicleID\":null,\"Discount\":null,\"ContractID\":15,\"DiscountPerMonth\":null,\"ProductID\":null,\"ProductStateID\":null,\"Mail\":\"\",\"WithoutLimit\":true,\"ContractSold\":null,\"ContractLimit\":null,\"NumberOfTransactions\":null,\"DriverNameOnly\":null,\"DriverSurnameOnly\":null},{\"ID\":2881,\"CompanyID\":1155,\"CompanyName\":\"test\",\"FiscalCode\":null,\"Code\":\"test0000\",\"Limit\":125.000,\"StateID\":1,\"CardState\":\"Activ\",\"Deleted\":false,\"Sold\":132.330,\"StartDate\":\"\/Date(1436130000000+0300)\/\",\"InvoiceStartDate\":\"\/Date(-62135596800000+0200)\/\",\"Quantity\":null,\"Value\":0.0,\"CardTypeID\":1,\"CardType\":\"Credit\",\"SoldChanged\":false,\"DriverName\":\"aaa aaa\",\"VehiclePlateNumber\":\"aaa\",\"VehicleID\":null,\"Discount\":null,\"ContractID\":15,\"DiscountPerMonth\":null,\"ProductID\":null,\"ProductStateID\":null,\"Mail\":\"\",\"WithoutLimit\":true,\"ContractSold\":null,\"ContractLimit\":null,\"NumberOfTransactions\":null,\"DriverNameOnly\":null,\"DriverSurnameOnly\":null}]" }

Thanks in advance!

I thought ObjectMapper does that :) That's why all my class variables are strings — Vlad Marinescu
– Vlad Marinescu, Commented Jan 27, 2016 at 10:35
I guess he is using com.fasterxml.jackson.databind.ObjectMapper. — Wagner Tsuchiya
– Wagner Tsuchiya, Commented Jan 27, 2016 at 10:52
strResponse= strResponse.replace("\"GetCardsResult\":", ""); will destroy your JSON. You're only removing the key and the colon, not the leading and trailing curly braces. Additionally: your code is highly inefficient (has to work through the string up to four times) and likely to break (e.g. the webservice returns formatted JSON with a space in front of the colon) — toKrause
– toKrause, Commented Jan 27, 2016 at 10:53

Fabio Venturi Pastor · Accepted Answer · 2016-01-27 14:10:36Z

3

Try this:

    try {            
         JSONObject jsonObject = null;
         yourJSONString.replace("\\", "");
         jsonObject = new JSONObject(yourJSONString);
         String newJSONString = jsonObject.get("GetCardsResult").toString();
         JSONArray jsonMainArr = new JSONArray(newJSONString);
         //now just loop the json Array
         for (int i = 0; i < jsonMainArr.length(); ++i) {                     
         JSONObject rec = jsonMainArr.getJSONObject(i);                     
         card.set_id(rec.get("ID").toString());                     
         //....      
       }                                                       
       } catch (JSONException e) {
         e.printStackTrace();
       }

edited Jan 27, 2016 at 14:10

answered Jan 27, 2016 at 10:43

Fabio Venturi Pastor

2,5293 gold badges22 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vlad Marinescu Over a year ago

Let us continue this discussion in chat.

Ravi Over a year ago

yourJSONString.replace("\\", ""); Is it required??

Ronak Joshi · Accepted Answer · 2016-01-27 10:47:24Z

Try to use GSON its very efficient and easy to implement, As example below will be your POJO class.

public class Post {

    @SerializedName("id")
    public long ID;
    public String title;
    public String author;
    public String url;
    @SerializedName("date")
    public Date dateCreated;
    public String body;

    public List tags;

    public Post() {

    }
}

//Tag.java
public class Tag {

    public String name;
    public String url;

    public Tag() {

    }
}

And this will how you parse your JSON string to Object Class,

Reader reader = new InputStreamReader(content);
GsonBuilder gsonBuilder = new GsonBuilder();
gsonBuilder.setDateFormat("M/d/yy hh:mm a");
Gson gson = gsonBuilder.create();
List<Post> posts = new ArrayList<Post>();
posts = Arrays.asList(gson.fromJson(reader, Post[].class));
content.close();

DamianoPantani · Accepted Answer · 2016-01-27 10:45:48Z

0

What do you pass to the mapper - string before or after compiling the regular expression?
Did you try any external lib like Gson? Everything you need is just new Gson().fromJson(strResponse, new TypeToken<List<Card>>() {}.getType(););

answered Jan 27, 2016 at 10:45

DamianoPantani

1,4362 gold badges17 silver badges25 bronze badges

4 Comments

Vlad Marinescu Over a year ago

userCards= gs.fromJson(strResponse, new TypeToken<List<Card>>() {}.getType()); java.lang.IllegalStateException: Expected BEGIN_ARRAY but was BEGIN_OBJECT at line 1 column 2

DamianoPantani Over a year ago

what about new Gson().fromJson(strResponse, Card.class);

Vlad Marinescu Over a year ago

you thought that there's an object , not an array?

Vlad Marinescu Over a year ago

Can't convert Array to Card object. For sure, there's an array in JSON response. There are more than 1 card info, so , I need array , only if somehow I convert object by object

Collectives™ on Stack Overflow

Convert JSON array to Java Class Object List

3 Answers 3

2 Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related