XML : xpath troubles - no results

Using xpath "//*" as in the code below will retrieve the whole xml document

=IMPORTXML("https://api.bol.com/catalog/v4/search/?apikey=myapikey&format=xml&q=isbn","//*")

I haven't been able to just extract specific elements like Title. I've looked at the xpath documentation, tried a dozen or so variations, but I keep getting an empty result... What would the right Xpath be for extracting the Title?

An example XML document can be found here: https://developers.bol.com/wp-content/pagina/handleiding/xml/search.xml

   This XML file does not appear to have any style information associated with it. The document tree is shown below.     <SearchResults xmlns="http://api.bol.com/openapi-4.0.0">       <OriginalRequest>         <Category/>       </OriginalRequest>       <TotalResultSize>4875</TotalResultSize>       <Products>         <Id>9200000026739211</Id>         <EAN>5051888195819</EAN>         <GPC>dvd</GPC>         <Title>Harry Potter - Complete 8-Film Collection</Title>         <SpecsTag>Warner Home Video</SpecsTag>         <Summary>Dvd | 8 disks | mei 2014 | null</Summary>         <Rating>48</Rating>         <ShortDescription>    

No comments:

Post a Comment