News

XPath — I Don’t Think I’m Quite Getting It

So I’ve been working more with Google Spreadsheet’s importXML function, in association with Amazon’s ECS API. But I’m having some problems with filtering. Can someone help me understand this?

I’ve been using the XPath Query Expression Tool at http://www.xmlme.com/XpathTool.aspx to understand the output of Amazon’s ECS service. To get the titles from an output I can use the following syntax with importXML:

“SellerListingSearchResponse/SellerListings/SellerListing/Title”

And if I want to list only those titles that have a price of over $10.00, I can use this syntax:

SellerListingSearchResponse/SellerListings/SellerListing/Title|Price[Amount>1000]

What I can’t figure out is how to combine these two conditions — how to list only those titles which have a price of over $10. Price and Title are both children of SellerListing.

Am I missing something? I’ll keep looking…

Categories: News