How to send a specific POST request to an API using Spring Boot

Question

I want to create a Post method for my controller for my Spring boot application, I have an Entity Alert, with the elements below, but I need to send a specific request format to my API, I tried using save() method but it doesn't work, does someone knows how to specify each element for the Json request? and also how to go to the next element when we use Serializable? Thank you so much for help

{
  "deviceEUIs": [
    "1122233344"
  ],
  "alertModes": [
    {
      "type": "MOTION",
      "notifyByEmail": true,
      "notifyBySMS": true,
      "notifyOnInterface": true
    }
  ]
}


@Entity
@Table(name = "Alert")
public class Alert implements Serializable{

    private static final long serialVersionUID = 1L;
    @Id
    @GeneratedValue(generator = "uuid2")
    @GenericGenerator(name = "uuid2", strategy = "uuid2")
    @Column(columnDefinition = "BINARY(16)")
    private UUID alertRef;

    @OneToMany(mappedBy = "alert", cascade = CascadeType.ALL)
    private Set<AlertModes> alertModes;

    @ManyToMany(cascade = CascadeType.ALL)
    @JoinTable
    private Set<Subscriber> subscribers;

    @ManyToMany(mappedBy = "alerts")
    private Set<Device> devices;

    @Column(name = "last_update", columnDefinition = "DATETIME", nullable = false)
    @Temporal(TemporalType.TIMESTAMP)
    private Date lastUpdate;

And for my controller:

@RestController
@RequestMapping("/api/alerts")
public class AlertsController extends AbstractController{
         @Autowired
         private AlertRepository alertRepository;
         @PostMapping()
         public void createAlert(@RequestBody Alert alert) {
                    alertRepository.save(alert);
         }
 }

debug your application put breakpoint on `alertRepository.save(alert);` and see what spring gets as your object. — mavriksc, Jun 07 '18 at 15:14
I got this: Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Column 'last_update' cannot be null — Bob, Jun 07 '18 at 15:24

score 0 · Answer 1 · answered Jun 07 '18 at 15:16

0

You are doing everything correctly but just aren't doing anything to your empty instance of alert and therefore aren't posting anything. In order to post something you would need to do something like alert.setSomething(something) and then alertRepository.save(alert) because you are currently saving nothing

answered Jun 07 '18 at 15:16

NickDim

17
3

not true the `@RequestBody` maps the post object to the POJO – mavriksc Jun 07 '18 at 15:17
yes I tried with this but still a have the other elements empty, so it gives an error saying they can't be NULL. – Bob Jun 07 '18 at 15:46

mavriksc · Answer 2 · 2018-06-07T15:49:59.027

0

most likely you need to create correct device objects.

{
    devices:[
        {
        "deviceEUIs": "1122233344"
        },{
        "deviceEUIs": "1122233355"}
    ]
}

for the error you posted in the comment above. add this to entity.

 @PrePersist
 @PreUpdate
 public void onUpdate() {
      lastUpdate= new Date();
 }

there is a solution here that shows you how you can use this in a super class and inherit all classes you want to have those fields on.

edited Jun 07 '18 at 15:49

answered Jun 07 '18 at 15:16

mavriksc

1,130
1
7
10

On my API contract I have: { deviceEUIs:[ "1122233344","1122233355" ] } – Bob Jun 07 '18 at 15:34

score 0 · Answer 3 · answered Jun 07 '18 at 17:01

0

Have you tried to use:

@Column(nullable=false)
@Temporal(TemporalType.TIMESTAMP)
@LastModifiedDate // this automatically generates a new date when the object is changed.
private Date updatedAt;

answered Jun 07 '18 at 17:01

Rafael Barros

1
1

How to send a specific POST request to an API using Spring Boot

3 Answers3