The eCom Search API allows me to search for a ProductPrice larger than 60 by adding this to a querystring:
&ProductPrice=60&ProductPrice_Type=5
But what if the price must be below 80?
&ProductPrice=80&ProductPrice_Type=4
If I combine these to qs:
&ProductPrice=60&ProductPrice_Type=5&ProductPrice=80&ProductPrice_Type=4
(&ProductPrice=60,80&ProductPrice_Type=5,4)
DW fails:
System.Data.SqlClient.SqlException: Error converting data type varchar to float.
Is it possible to make that kind of search?
/Morten