Getting anchor text from a webpage using xpath within YQL

Posted by Matt on Stack Overflow See other posts from Stack Overflow or by Matt
Published on 2010-05-12T20:58:16Z Indexed on 2010/05/13 5:24 UTC
Read the original article Hit count: 309

Filed under:

yql

|

xpath

SELECT content FROM html WHERE url="http://en.wikipedia.org/wiki/List_of_United_States_National_Parks_by_state" AND xpath="//a/text()"

does not work, whereas

SELECT * FROM html WHERE url="http://en.wikipedia.org/wiki/List_of_United_States_National_Parks_by_state" AND xpath="//a/text()"

does.

SELECT content FROM html WHERE url="http://en.wikipedia.org/wiki/List_of_United_States_National_Parks_by_state" AND xpath="//a"

also works, it seems YQL has a bug, or am I missing something?

© Stack Overflow or respective owner

Related posts about yql

Cross domain AJAX requests using JQuery and YQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi , I need to use YQL (Yahoo Query Language) to perform a cross domain ajax request then bind the XML response into a JSON object and retrieve a value from the XML. The link shows how this is done using the YQL service as a proxy for cross domain requests: http://ajaxian.com/archives/using-yql-as-a-proxy-for-cross-domain-ajax For… >>> More
How to implement YQL paging?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've read the YQL guide, and I keep reviewing http://developer.yahoo.com/yql/guide/yql-o...entables-paging and I have been looking at a few examples, but I'm still left pretty confused how YQL paging works. The problem that I am trying to tackle is creating a YQL open data table for the Mozilla… >>> More
Query a location's WOEID using YQL and javascript/jquery

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi , I need to query a locations WOEID and grab the WOEID value from the xml returned. So the user would type e.g. London, UK and I need to load the query as below: http://query.yahooapis.com/v1/public/yql?q=select%20woeid%20from%20geo.places%20where%20text%20%3D%20%22London%2C%20UK%2C%20UK%22&format=xml After… >>> More
Cross domain AJAX requests using YQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi , I need to query a locations WOEID and grab the WOEID value from the xml returned. So the user would type e.g. London, UK and I need to load the query as below: http://query.yahooapis.com/v1/public/yql?q=select%20woeid%20from%20geo.places%20where%20text%20%3D%20%22London%2C%20UK%2C%20UK%22&format=xml After… >>> More
Automating scraping of table data to XML

as seen on Stack Overflow - Search for 'Stack Overflow'
Problem I have a YQL query result that I'm trying to get converted and sort into a clean XML file. Background Being the pains that they are, information from the World Cup isn't freely available in an easy to reuse format. So, after a bit of finessing with YQL I have managed to liberate the required… >>> More

Related posts about xpath

xpath query in a servlet gives exception

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Document object initialized in the init() method of the servlet and use it in the doPost() method to service the requests. selectNodeList() xpath query gives exception when the servlet services many request at same time. The Exception is shown below: Caused by: javax.xml.transform.TransformerException:… >>> More
XPath to find element based on another XPath element

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have an Java AST and I try to find a variable inside it via XPath. Lets say the variable is called 'foobar' I could use //VariableDeclarator/VariableDeclaratorId[@Image='foobar'] but what if I dont know the text 'foobar', but want to read it from another element //VariableDeclarator/VariableDeclaratorId[@Image=//SynchronizedStatement/Expression/PrimaryExpression/PrimaryPrefix/Name] the… >>> More
Xpath question Xml Xpath

as seen on Stack Overflow - Search for 'Stack Overflow'
I need an xpath expression that would return the value of I need to get the value of this node. the value to extract is my xpath expression is //rates/rate[loantype='30-Year Fixed Rate'] The issue hre is that there are three value each node has a subtype element. Beside fileter for loantype… >>> More
php xpath query on and xpath result

as seen on Stack Overflow - Search for 'Stack Overflow'
Can I use an xpath query on a result already obtained using xpath? >>> More
how to use nokogiri methods .xpath & .at_xpath

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm learning how to use nokogiri and few questions came to me based on the code below require 'rubygems' require 'mechanize' post_agent = WWW::Mechanize.new post_page = post_agent.get('http://www.vbulletin.org/forum/showthread.php?t=230708') puts "\nabsolute path with tbody gives nil" puts post_page… >>> More