Back to YQL Forum
0

YQL Inconsistent results

I'm using YQL to retrieve site specific results (I don't need Google results for just my own site but for a variety of sites).

However, I'm getting inconsistent results. Using the YQL console for my query:

  • Executing a Test for the same query multiple times, sometimes returns result but 8 out of 10 times gives no result without producing an error.
  • When there are results, the number of results is often significantly less from manually executing a Google query on google.com

An example query that shows this behaviour is select * from google.search where q = 'site:www.freelas.net'

Any suggestions on this?

Kind regards, Marc

by
Report Abuse
4 Replies
  • Hi Marc,

    Doing a "desc google.search' query shows that the table takes in an "apiKey". Can you try providing your own API key in your query. I suspect that there is a single default in use for demo purposes and that is being blocked by Google.

    You can confirm by selecting the "Debug" option when running your query on the YQL console, and then clicking on the UUID hyperlink that shows up next to googleapis.com url in the response, like below:
    <url execution-start-time="419" execution-stop-time="989"
      execution-time="570"
      id="dc1d524b-13da-4246-8fff-083a71f91af2" proxy="DEFAULT"><![CDATA[http://ajax.googleapis.com/ajax/services/search/web?v=1.0&gl=en&userip=&hl=en&q=pizza&start=0&rsz=8]]></url>
    Sriram

    Report Abuse
    0
  • Thanks for that. Is that a Yahoo API key or a Google API Key? How to put it into a query?

    I tried adding api_key to the url and while it seemed to work initially. One test later, I had 0 results. It seems that the service is completely unreliable. 
    Report Abuse
    0
  • I would say 10% of the time a query gives a correct response and 90% of the time it gives an empty response. So, on top of getting the wrong thing, you're not even made aware that it's wrong or why!
    Report Abuse
    0
  • Marc,

    The google.search table is outdate and deprecated by Google. It's the Google endpoint that is working part of the time. Feel free to create a new google.search table using the newest API if you wish.

    Read: https://developers.google.com/web-search/docs/

    Note: The Google Web Search API has been officially deprecated as of November 1, 2010. It will continue to work as per our deprecation policy, but the number of requests you may make per day will be limited. Therefore, we encourage you to move to the new Custom Search API.

    Thanks -Paul
    YQL Team
    Report Abuse
    0
Ask a Question

Recent Posts

in YQL