Forum Discussion

franpp's avatar
franpp
Guide
12 years ago

Is there an API request URL to get products sorted by rating?

I need to get products sorted by rating, but can't find the correct API request for this in the API documentation. Is there any API request that returns this, or there is any sorting option for produ...
MichaelD's avatar
MichaelD
Lithium Alumni (Retired)
11 years ago
A product is not required to have associated rating information. This is the reason that the /restapi/vc/products/all was implemented such that all products would be returned independent of the rating.

Once you have obtained the id for a product you will be able to call the endpoint /restapi/vc/products/id/34/ratings/key/key to obtain the rating information for the product.

Presently the rest API does not provide a single endpoint for obtaining a list of products ordered by ratings. But the two endpoints discussed here can be used to build such a list.

I hope this helps.
petermanser's avatar
petermanser
Ace
11 years ago

MichaelD gosh! as we're having something around 200k products, this would mean we'd have to more than 200k calls to retrieve the top 10 products? (case: live request - no caching)

 

Thanks for your FAST replies, very helpful.

 

 

 

 

 

 

  • MichaelD's avatar
    MichaelD
    Lithium Alumni (Retired)
    11 years ago

    I think the ideal solution would be to provide a rest endpoint that returns a sorted list of all products that have an assigned rating.

    I have documented the request and forwarded it to our product management team for consideration as a future feature enhancement.

    Thank you for bringing our attention to this issue.