0

Not able to get reviews using YQL from google search API

I am developing a mobile app in which i require to collect reviews about any places which google maps displays. For example,

http://maps.google.com/maps?f=q&sll=34...eviews&sa=X

I need to collect all the reviews in that page.

So i used YQL console and gave the query like below. I got the xpath from firebug.


select * from html where url='http://maps.google.com/maps?f=q&sll=34.01158,-118.49228&view=text&hl=en&ie=UTF8&latlng=34018803,-118497913,8560620448829222597&ei=xuvdStCVGJv4vAOIrtjqAw&sig2=Dg1DMpspewT6k6OejDz7Tw&cd=1&dtab=2&oi=md_reviews&sa=X' and xpath='/html/body/table[3]/tbody/tr/td/table/tbody/tr[10]/td/table/tbody/tr/td/span'

This is my query. But it doesnt give me the result.

<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng" yahoo:count="0" yahoo:created="2009-10-21T09:18:30Z" yahoo:lang="en-US" yahoo:updated="2009-10-21T09:18:30Z" yahoo:uri="http://query.yahooapis.com/v1/yql?q=select+*+from+html+where+url%3D%27http%3A%2F%2Fmaps.google.com%2Fmaps%3Ff%3Dq%26sll%3D34.01158%2C-118.49228%26view%3Dtext%26hl%3Den%26ie%3DUTF8%26latlng%3D34018803%2C-118497913%2C8560620448829222597%26ei%3DxuvdStCVGJv4vAOIrtjqAw%26sig2%3DDg1DMpspewT6k6OejDz7Tw%26cd%3D1%26dtab%3D2%26oi%3Dmd_reviews%26sa%3DX%27+and+xpath%3D%27%2Fhtml%2Fbody%2Ftable%5B3%5D%2Ftbody%2Ftr%2Ftd%2Ftable%2Ftbody%2Ftr%5B10%5D%2Ftd%2Ftable%2Ftbody%2Ftr%2Ftd%2Fspan%27">

<diagnostics>
<publiclyCallable>true</publiclyCallable>
<forbidden>robots.txt for the domain disallows crawling for url: http://maps.google.com/maps?f=q&sll=34...;/forbidden>

<user-time>7</user-time>
<service-time>0</service-time>
<build-version>3559</build-version>
</diagnostics>
<results/>
</query>


Could someone please help me out, could you try out once and tell me how should be my query so that i get all the reviews in javascript


THanks in advance,
Mani

by
1 Reply

Recent Posts

in YQL