How to get list of entities from list of Ids in springBoot?

Question

my requirement is to get the list of entity from the list of ids , I was trying something like this and I when I am priting to string method I am getting the list but when I am trying to return it , It saying not found .

My repo code

  List<AddingProductForView> findAllByproductidIn(ArrayList<Integer> productid);

my servicecode:-

   public List<AddingProductForView> getListOfData(ArrayList<Integer> productid){
        List<AddingProductForView> findAllByProductIdIn = repository.findAllByproductidIn(productid);
         return findAllByProductIdIn;
    }

mycontrollercode:-

    @PostMapping("/getProductsId")
public List<AddingProductForView> getListOfData(@RequestBody ArrayList<Integer> productid) {
    List<AddingProductForView> findAllByProductIdIn = fileService.getListOfData(productid);
    return findAllByProductIdIn;
}

while priting toString method (getting the result as :-

`[AddingProductForView [productid=1, productname=RO, imagepath=./assets/1.jpeg, price=4000  , productdescription=best], AddingProductForView [productid=2, productname=RO, imagepath=./assets/2.jpeg, price=8000  , productdescription=cheap], AddingProductForView [productid=3, productname=RO, imagepath=./assets/3.jpeg, price=2000  , productdescription=values]]`

What I am trying to hit from postman:-

  [1,3,2]

Error:- { "timestamp": "2021-07-02T07:25:50.973+0000", "status": 404, "error": "Not Found", "message": "No message available", "path": "/api/excel/getProductsId" }

try put {"productId":[1,2,3]} in postman request body, you should tell us what is your problem, and what you want to do @DivyeshKumar — Dolphin
– Dolphin, Commented Jul 2, 2021 at 6:48

Desmond Stonie · Accepted Answer · 2021-07-02 07:42:57Z

1

Your controller code is:

@PostMapping("/getProductsByIds")

but the url you type in postman is:

"path": "/api/excel/getProductsId"

answered Jul 2, 2021 at 7:42

Desmond Stonie

1455 bronze badges

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

2 Comments

Divyesh Kumar Over a year ago

I have requestmapping defined at class level something like this :- @RequestMapping("/api/excel")

Desmond Stonie Over a year ago

I mean getProductsByIds vs getProductsId

Mr_Thorynque · Accepted Answer · 2021-07-02 07:23:08Z

0

Just change signature of method : ArrayList to interface List

public List<AddingProductForView> getListOfData(@RequestBody List<Integer> productid)

answered Jul 2, 2021 at 7:23

Mr_Thorynque

2,0621 gold badge26 silver badges38 bronze badges

Comments

Divyesh Kumar · Accepted Answer · 2021-07-02 08:17:31Z

0

we have to use @ResponseBody at the method level for such

@PostMapping("/getProductsId")
@ResponseBody
public List<AddingProductForView> getListOfData(@RequestBody List<Integer> productid) {
    List<AddingProductForView> findAllByProductIdIn = fileService.getListOfData(productid);
    return findAllByProductIdIn;
}

answered Jul 2, 2021 at 8:17

Divyesh Kumar

372 silver badges12 bronze badges

1 Comment

Dhwanil Patel Over a year ago

No, this thing is not required. Because at the top, You mentioned '@RestController' and It's a combination of '@Controller' and '@ResponseBody'.

Collectives™ on Stack Overflow

How to get list of entities from list of Ids in springBoot?

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related