Product Search can't use IN operator when searching by SKU

Developer Support APIs & Integrations
1

Whenever I attempt to search for SKUs using the IN operator, I get back an empty result. If I do the same thing using hs_object_id, then I get back the correct results. Can’t seem to figure out if that property just can’t be searched using the IN operator, or if I’m doing something incorrect.

Here’s the body of my request

{

“filterGroups”: [

{

“filters”: [

{

“propertyName”: “hs_sku”,

“operator”: “IN”,

“values”: [

“PX”, “PX2”

]

}

]

}

],

“sorts”: null,

“query”: null,

“properties”: [

“hs_object_id”,

“hs_sku”

],

“limit”: 100,

“after”: 0

}

2

Hey, @JPeacock4 :waving_hand: One thing to watch out for with the Search API is that the IN and NOT_IN search operators require the values to be in lowercase. “Inputted values must be in lowercase.”
What happens if you set your values to something like:

{

“filters” : [

{

“propertyName” : “hs_sku” ,

“operator” : “IN” ,

“values” : [

“px” , “px2”

]

}

]

}

Talk soon! —Jaycee

3

That did the trick. Read through your documentation for like an hour and never saw the lowercase part. Thanks for the help.