YQL "Redirected to robots.txt restricted URL" for Google domain

Question

I use the YQL console and want to return the results from this link in Google Shopping

Using the following in YQL:

  select content from html where url="www.google.com/products/seller?hl=en&q=burkett+restaurant+equipment+reviews&tbo=u&tbm=shop&zmi=basequipment.com&cmi=12986189937115136" and xpath="//body"

He says: "Redirected to a robots.txt limited URL" and will not show any results, how to get around this in any way?

See here for the YQL console

Answer 1

You can use open tables:

http://developer.yahoo.com/yql/console/?q=show%20tables&env=store://datatables.org/alltableswithkeys#h=select%20content%20from%20data.headers%20where%20url%3D%22www.google.com/products/seller%3Fhl%3Den%26q%3Dburkett+restaurant+equipment+reviews%26tbo%3Du%26tbm%3Dshop%26zmi%3Dbasequipment.com%26cmi%3D12986189937115136%22