Convert JSON to Array in java

Question

I have a JSON that represents a test query:

{"dctitle":"TestesStatus",
 "oslc_cmtotalCount":2,
 "oslc_cmresults":
 [
     {"dctitle":"33643640",
     "rdfabout":"XXXXXXXXXXX",
     "dbid":"XXXXXXXXXXX",
     "depto":"XXXXXXXXXXX",
     "sigla":"XXXXXXXXXXX",
     "Ciclo":"XXXXXXXXXXX",
     "State":"Executando",
     "dataplanejadainicial":"Thu Mar 30 00:00:00 Brasilia Time 2017",
     "dataEntradaEstado":"31\/03\/2017",
     "id":"SOL00089208",
     "executante":"RAFAEL"},

     {"dctitle":"33643641",
     "rdfabout":"XXXXXXXXXXX",
     "dbid":"XXXXXXXXXXX",
     "depto":"XXXXXXXXXXX",
     "sigla":"XXXXXXXXXXX",
     "Ciclo":"XXXXXXXXXXX",
     "State":"Executando",
     "dataplanejadainicial":"Thu Mar 31 00:00:00 Brasilia Time 2017",
     "dataEntradaEstado":"01\/04\/2017",
     "id":"SOL00089209",
     "executante":"MARIA"}
 ]
}

I am using GSON to convert to object.

public class Consulta 
{   
    private String dctitle;
    private String oslc_cmtotalCount;
    private List<Teste> oslc_cmresults;
}

public class Teste 
{
    private String dctitle;
    private String rdfabout;
    private String dbid;
    private String depto;
    private String sigla;
    private String ciclo;
    private String state;
    private String dataPlanejadaInicial;
    private String dataEntradaEstado;
    private String id;
    private String executante;
}

public static void main(String[] args) throws Exception
{
    Scanner in = new Scanner(new FileReader("src/resources/consulta.txt"));
    StringBuilder sb = new StringBuilder();
    while(in.hasNext()) 
    {
        sb.append(in.next());
    }
    in.close();
    String json = sb.toString();

    Gson gson = new Gson();
    Consulta consulta = gson.fromJson(json, Consulta.class);
}

But it is not returning the Test List, only the first Query attributes.

System.out.println(gson.toJson(consulta)); // Resultado:{"dctitle":"TestesStatus","oslc_cmtotalCount":"2"}

Answer 1

Your JSON has a syntax error between the first item of array. Also change the type of the two dates to String and do the conversion manually, since the formats are different.

Answer 2

Good afternoon, all good?

Try to create a class constructor, or leave variables as public, I’ve had this problem in C#.

   public class Consulta 
    {   
       private String dctitle;
       private String oslc_cmtotalCount;
       private List<Teste> oslc_cmresults;

        public Consulta(String dctitle, String oslc_cmtotalCount, List<Teste> oslc_cmresults){

           this.dctitle = dctitle;
           this.oslc_cmtotalCount = oslc_cmtotalCount;
           this.oslc_cmresults = oslc_cmresults;
        }

    }

Second possible solution:

public class Consulta 
 {   
    public String dctitle;
    public String oslc_cmtotalCount;
    public List<Teste> oslc_cmresults;

 }

Do these procedures in all model classes(Query and Test) and Test!