POST request endpoint using Java/Spring-boot

Question

I'm trying to make a post request endpoint to send some form values to my database. When I test the request with postman, I get a 400 bad request error and this message in my console

JSON parse error: Cannot deserialize value of type abcd.Model.Quote from Array value (token JsonToken.START_ARRAY);

this is my controller:

    @ResponseStatus(HttpStatus.CREATED)
    @PostMapping("/createQuote")
    public boolean newQuote(@RequestBody Quote newQuote) {
    return quoteDB.saveQuote(newQuote);
};

my model:

public class Quote {
public int id;
public String type_building;
public int numElevator;
public String typeService;
public double total;
public double totalElevatorPrice;

public Quote(
        int _id,
        String _type_building,
        int _numElevator,
        String _typeService,
        double _total,
        double _totalElevatorPrice
){
    this.id = _id;
    this.type_building = _type_building;
    this.numElevator = _numElevator;
    this.typeService = _typeService;
    this.total = _total;
    this.totalElevatorPrice = _totalElevatorPrice;

}
public String getType_building() { return type_building; }
public void setType_building(String type_building) { this.type_building = type_building; }

public int getNumElevator() { return numElevator; }
public void setNumElevator(int numElevator) { this.numElevator = numElevator; }

public String getTypeService() { return typeService; }
public void setTypeService(String typeService) { this.typeService = typeService; }

public double getTotal() { return total; }
public void setTotal(int total) { this.total = total; }

public double getTotalElevatorPrice() { return totalElevatorPrice; }
public void setTotalElevatorPrice(int totalElevatorPrice) { this.totalElevatorPrice = totalElevatorPrice; }

}

and this is the function saveQuote where I try to post to the database:

    public boolean saveQuote(Quote newQuote){
    PreparedStatement getData;
    try {
        Connection c;
        c  = this.db.connectDB();
        getData = c.prepareStatement("INSERT INTO Quote VALUES (" +"'" +newQuote.getType_building() + "'" +"," + "'" +newQuote.getNumElevator() + "'" + "," + newQuote.getTypeService() + "," + newQuote.getTotal() + "," + newQuote.getTotalElevatorPrice() + ")");
        getData.executeUpdate();
        return true;
    }
    catch (SQLException e) {
        e.printStackTrace();
    }
    return false;
}

Thank you for your help.

UPDATE: this is the POST request im sending in postman:

[
{
    "id": 2,
    "type_building": "commercial",
    "numElevator": 10,
    "typeService": "standard",
    "total": 100000.0,
    "totalElevatorPrice": 1.0E7
}
]

please update the question with the request that you send with postman — Panagiotis Bougioukos
– Panagiotis Bougioukos, Commented Apr 7, 2022 at 20:05

Panagiotis Bougioukos · Accepted Answer · 2022-04-07 20:08:33Z

2

@PostMapping("/createQuote")
public boolean newQuote(@RequestBody Quote newQuote) {

Your controller expects as input a single object { ... } representing a Quote object as you have defined it in your code.

Cannot deserialize value of type abcd.Model.Quote from Array value (token JsonToken.START_ARRAY);

But you provide as input with the message that you send an array of objects [ {...}, {...}].

Your request must be without [ ] because those should be used if your controller expected an array of objects.

so it should be

{
    "id": 2,
    "type_building": "commercial",
    "numElevator": 10,
    "typeService": "standard",
    "total": 100000.0,
    "totalElevatorPrice": 1.0E7
}

answered Apr 7, 2022 at 20:08

Panagiotis Bougioukos

19.6k4 gold badges41 silver badges63 bronze badges

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

Collectives™ on Stack Overflow

POST request endpoint using Java/Spring-boot

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related