hi,
i have this response of best buy API which is working fine. It returns xml format and 1 record per page, sort desc order by price.
I bind this result with gridview with follow code
https://api.bestbuy.com/v1/products%28%28search=iphone%29%29?apiKey=zj7vgvjy3a2kbdmjy7ktyh3q&pageSize=1&sort=sale%20price.desc&format=xml
using (DataSet ds = new DataSet())
{
ds.ReadXml(Server.UrlDecode("https://api.bestbuy.com/v1/products((search=iphone6))?apiKey=zj7vgvjy3a2kbdmjy7ktyh3q&sort=name.asc&format=xml"));
GridView1.DataSource = ds.Tables["product"];
GridView1.DataBind();
}
I need an advice how can i apply where clause in xml response that returns values which is between 100 to 200 on sale price field
thanks