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, Jul 02 '21 at 06:48
do you have a public api from public domain network I could Invoke? @DivyeshKumar — Dolphin, Jul 02 '21 at 06:54
no its not in public domain , its in local as of now @Dolphin — Divyesh Kumar, Jul 02 '21 at 06:58
Does this answer your question? [Can not deserialize instance of java.util.ArrayList out of START\_OBJECT token](https://stackoverflow.com/questions/20837856/can-not-deserialize-instance-of-java-util-arraylist-out-of-start-object-token) — deepakchethan, Jul 02 '21 at 07:00

score 1 · Answer 1 · answered Jul 02 '21 at 07:42

1

Your controller code is:

@PostMapping("/getProductsByIds")

but the url you type in postman is:

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

answered Jul 02 '21 at 07:42

Desmond Stonie

99
5

I have requestmapping defined at class level something like this :- @RequestMapping("/api/excel") – Divyesh Kumar Jul 02 '21 at 07:45
I mean `getProductsByIds` vs `getProductsId` – Desmond Stonie Jul 02 '21 at 08:08

score 0 · Answer 2 · answered Jul 02 '21 at 07:23

0

Just change signature of method : ArrayList to interface List

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

answered Jul 02 '21 at 07:23

Mr_Thorynque

1,749
1
20
31

score 0 · Answer 3 · answered Jul 02 '21 at 08:17

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 02 '21 at 08:17

Divyesh Kumar

37
11

No, this thing is not required. Because at the top, You mentioned '@RestController' and It's a combination of '@Controller' and '@ResponseBody'. – Dhwanil Patel Jul 02 '21 at 10:05

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

3 Answers3