Searching for Products Using the IN Operator

Julie Muraski
Best Buy Developers
1 min readMar 3, 2015

--

Searching for products using an API can be frustrating, especially when you’re looking for more than one item at a time and don’t have time to enter your query over and over. The Best Buy Products API is designed to ease the pain, with multiple product search built in. Instead of a SKU value equaling a single SKU, when you use our in operator and enter a comma-separated list of SKUs as part of the main query syntax, we can return the full list of products searched for.

EXAMPLE

In the following example we are searching for 10 skus in a single call and returning various product attributes. To complete the search you will want to use our in operator: baseURL : http://api.remix.bestbuy.com/v1/ productQuery : products(sku in(8949452,5815013,8349749,8539099,2836657,3924148,8796018,6084131,6130098,5686019)) APIKey : ?apiKey=YourAPIKey showOptions : &show=sku,name,description,image,addToCartUrl,salePrice responseFormat : &format=json

fullURL : http://api.remix.bestbuy.com/v1/products(sku in(8949452,5815013,8349749,8539099,2836657,3924148,8796018,6084131,6130098,5686019))?apiKey=YourAPIKey&show=sku,name,description,image,addToCartUrl,salePrice&format=json

--

--